How to Convert PDF to Excel

In this step-by-step tutorial, learn how to convert an Adobe PDF file to a Microsoft Excel file.

⌚ Timestamps
0:00 Introduction
0:36 Example PDF with table of data
1:07 How to import PDF data into Excel
4:24 Wrap up

📚 Resources

📃 Watch related playlists

🚩 Connect with me on social

🙏 Request How To Tutorial Videos

🔔 Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

#stratvert

[carolfluter]

This is about as amazing as anything I've ever seen. What a huge timesaver! Thank you!

[terribowman]

Thank you for not dragging this out and getting to the point. Very helpful!

[johnakidd]

A straightforward way to convert PDF to EXCEL is exactly what I have been looking for. Thanks.

[hawaiisplantationvillage]

Thank you Kevin. This is one of the best tutorial I've seen. Very very helpful!

[mohamedadjal]

Hi, Professor, you have provide in a lot of effort for these videos, thank you, I have a question if we have for example in cell "a1" the number 10.00 m, how to have this number with the same format in cell "b1 "using a text function or some other function, thank you very much.😃👍

[richardwaldron]

Was sat copying/pasting from PDF table into Excel thinking A it was going to take all day and B there must be a way to import this. Very, very glad you posted this. Really easy and helpful, thank you.

[ksltechnology]

Good I find it awesome that the feature is built into excel to make extremely seamless. I never thought this would be possible until seeing you share this tutorial, so thanks for the awesome lesson Kevin. :)

[MariaM-fcpp]

Whoo hoo magic!😀 I love your tutorials!

[MichaelToub]

I had no idea you could do that, thank you so much!

[robrayborn]

Power Query works wonders on PDF tables! I've found that it doesn't work quite so pretty on PDF files do not have the data within a table. The 'table' is the main factor that makes it easy. However, a PDF without a table (like a Sales Invoice) could possibly import gibberish that might take even longer to clean the data. Any suggestions for PDF importing to Excel where there isn't a table present ?

[michaelwhite]

Hi Kevin! Thanks for the video! Can you also share how we can convert complex notepad to excel format? Like a very complex notepad text 🥲

[generaldvw]

This one made me a hero today...GO Kev!

[LoraTange]

You made it look so easy! There were multiple tables in my pdf. When I clicked LOAD, the tables went to a list section to the right called Questies & Connections. When I bring up each table I see a lot of NULL values. There must be extra steps with multiple tables to get them imported correctly.

[troyezell]

Great video Kevin, thanks again!
One question, is their a way to import a PDF in its exact formatting appearance into Excel?

[toddlasvegas]

I have been using Excel for many years, and I cannot believe I did not know how to do this. So easy, thank you so much!

[texasseastar]

I’ve needed to know this for the longest time. PDF to WORD is fairly smooth, but PDF to Excel has been a much bigger challenge. It never occurred to me to go through the DATA tab. I will DEFINITELY be giving this a try.
Thanks Kevin!

[joannaj]

Helpful video! When I follow your steps, however, I get queries and can't figure out how to resolve them. Would you be able to do a video on that? I'm converting a loan amortization pdf and want to reconstruct the formulas. Thanks!

[MrWasphantom]

Awesome stuff Kevin, really helpful 😄

[Imanbobbi]

OMG....this is indeed a life saver. I have wasted so many hours of my life doing this the hard way lol. Thank you for this

[TylerStanczak]

I find it awesome that the feature is built into excel to make extremely seamless. I never thought this would be possible until seeing you share this tutorial, so thanks for the awesome lesson Kevin. :)