How to Convert a PDF to Excel THE RIGHT WAY (Office 365)

I have a PDF that I'd like to convert to EXCEL, The columns headers are dates and the numbered lines are text categories. I'd like to reverse that. I'd like the numbered lines to be chronological dates and the heading of the columns to be the text, Is this possible?

WHAT TO DO IN MACBOOK? THERE IS NO OPTION OF PDF

Thanks!

Sir which Microsoft version are you using to import PDF Because in 2016 version it is not available

The background music is redundant and annoying.
You are doing videos about IT. Remove the music.

I follow the steps Data>Get Data dropdown but I don't have .pdf as an option. Is there a setting I need to change?

Thank you very much. easy peasy

Hello! Everything was working great for me until I got to the “Pivot Column” part. When I pivoted my data back, it rearranged my first column in alphabetical order, but I need it to stay in the order as it appears (I’m referencing a company’s balance sheet). Any solutions to this?

Hi, How can convert a PDF Bank statement or a credit card statement to Excel? Please advise. Thanks

Not all heros wear capes!

Thank you for the video. But my dropdown does not have the pdf option

Please merge all tables in singles then do this....

Fantastic! Thank you for sharing.

What happends if you have a File that has 300 rows. I see that it only works with the first lets say 50 lines. Is there a way to download them all together at once? or do we need to do individually

100K VIEWS!! 🎉

Hi thanks for your video I cannot add numbers after I convert PDF to Excel ie I am not getting the total using the sum function, unless I manually change the figures in each cell which defeats the reason for converting- any suggestion on what I can do-Many Thanks

I don't have the from file "from pdf" option in the drop-down menu - now what? Excel 2019

I am using Office 365 and not on a Mac but I do not see the .pdf option. There are 2 options: data from pictures and Data from Power BI. Any suggestions?

Does this work on excel on a mac? I only see get data (power query) and can't find the pdf

Extremely helpful!! Thank you

WOW, that was impressive, thank you very much.

great presentation thanks

duuuuuuude! This blew my mind. I was walking through the process myself as you went and I'm telling you. Absolute genius! I appreciate you and this video so much. Thank you, thank you, thank you.

How do you fix the issue of getting "This table is empty" in the Navigator screen? The document has data but it won't convert. Thanks.

I am having trouble with importing the PDF file. It shows no data. The PDF file is a scanned image of a report. Does the format of the scanned PDF a factor?

Amazing video thank you !

I don't have pdf option, why? (macbook)

Oh God I was struggling whole day and finally at midnight your video came up in search, I thank you dearly.

Wonderful post and very helfpul. However, this is a really clean table. I am dealing with a "Project Profile" that is more like a form structure with data all over the place, no column headers, but rather field headers scattered throughout. Any ideas on how to apporach this, or a resource you can point me to? Thank you!

This is a "work smarter, not harder" solution. Thank you.

Hey thanks man, saved me a lot of time.
Could you pls let me know if there is a way to combine all the tables together. during the load it split them into separate tabs:/

What version of Excel are you using because mine doesn't have this option.

If PDf file created by scan then how we converting ?

Wow thanks for the very clear explanation. I am trying to convert my credit card statement which is password protected into excel using your method but it gives me an error because of the password. Is there anyway I can by pass the password or enter the password?

It is giving me gibberish text.

tks so much! you helped me to save a lot of time ;)

You can also try Table2XL, it's faster as you don't have to go through all these steps.

T H A N K Y O U !!!!!!!

this option have Office 365 Professional plus or not

Looking for something like this. get a manager coming to me in a panic because something was sent over in a PDF for some reason. I never used the feature before but this helped me learn. thanks for doing this.

well if your pdf file is that simple you’ll have no problem

Did not work on a scanned PDF.

Very Helpful thankyou but so so painful trying to listen to what you are saying with that "music" in the backround. I couldn't get to the end.

Absolutely a lifesaver, thank you. I do have a question about changing the columns from text to numbers. I have a few columns I need to convert into numbers, $ currency & decimal points, but when I try to change them I get an error message in the header box. How do I make the changes? Cheers

This was VERY helpful!!!

Excellent video! I had no idea it was this easy to convert PDF to excel. Thank you for the great tutorial!

thank you

this requires the newest version of excel, what about older versions ?

Thank you for an xcellent video. There is one thing though: The background music is really annoying and make it very hard to hear what you are saying at some points.