How to Convert a PDF to Excel THE RIGHT WAY (Q&A) | Office 365

[@Veronica-wu6uo]

Hit it out of the park on this one! Awesome job answering all of these questions. 😁

[@soup1207]

What about if the table in the new PDF moved to let say another page? How to update those setting please?

[@ExcelUpNorth]

Interesting question! Assuming that the name of the table remains the same then it can exist on any page and this method will work just fine. If the name ends up changing however, then that’s a different story!

[@mariaaguileragarcia9526]

@@ExcelUpNorth Could you do a video on that please?

[@yejjk]

Thanks ur videos are such I huge help, follow up question how do you fix a pdf in power query when it has multi source problems? Like the data fields are the same but the format when extracted to power query between the two tables becomes different?

[@ExcelUpNorth]

I’m really glad that you found the video helpful! As far as your question goes, if the tables share the same column header names then everything should work just fine. Could you describe what the other format differences are?

[@RA-rh5lb]

Wow amazing video on power query. Thanks for uploading. I subscribed your channel and hit the bell button too

[@ExcelUpNorth]

Thank you for stopping by, leaving a comment, and subscribing! Welcome to the channel! 😀

[@AdrianCastro-fCMO]

For some reason, in the MacOS, the Excel Microsoft 365 for Mac does not have support for PDF???

[@ExcelUpNorth]

Unfortunately the feature isn't available in the MacOS version. Hopefully one day it gets included!

[@rajeshshah6758]

Hi, your video and explanation is excellent. I have to regularly convert bank statements from pdf to excel and I am using free conversion online applications. But some of the statements, even when converted with online help, require a lot of cleaning which takes hours to clean. I am using excel 2019. Is there any way I could convert pdf to excel in my system itself.?

[@ExcelUpNorth]

Thank you for leaving a comment! Cleaning up data can be very time consuming and PowerQuery is a great tool to help with that. This video was created using the Office 365 version of Excel. Does Excel 2019 have the same options to choose from (Data > Get Data > From File > From PDF)?

[@rajeshshah6758]

@@ExcelUpNorth it does have other options except pdf

[@ExcelUpNorth]

That’s too bad that it isn’t included in your version of Excel. Maybe it will become available through more updates. If you’re able to upgrade to Office 365 that would be the most ideal situation.

[@rajeshshah6758]

Ok Thanks. @@ExcelUpNorth

[@soloboygamer]

there is no pdf option in ms office 2019

[@ExcelUpNorth]

That’s brutal. The example in this video uses Microsoft Office 365.