PDF to Excel Converter

In this step-by-step tutorial, learn how to bulk extract data from multiple PDF files into an Excel spreadsheet. To extract data, we use Power Query functionality that is built into Microsoft Excel and this requires no third party add-ins.

👋 Additional resources:

⌚ Timestamps
0:00 Introduction
0:32 Overview of sample files
1:51 Import one PDF into Excel
4:07 Refresh data
6:31 Bulk import PDF files into Excel
10:03 Power Query Editor
11:30 Transform data
12:15 Transpose
12:49 Use first row as headers
13:05 Add custom column
16:08 Remove row
16:41 Update column header
17:01 Applied steps
17:49 Review & transform aggregate data
19:07 Update data type
19:58 Remove column
20:14 Close & load
20:44 Bring in more data
21:56 Wrap up

📃 Watch related playlists and videos

🚩 Connect with me on social:

🔔 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

[JustBlankNoInfo]

Oh, Kevin, I think this is getting intense, HATRICK PDF Tutorials in a row: ) I am just obsessed now! Hats of as always!

[TylerStanczak]

These animations and visuals are just becoming next level! Seriously so impressed. Great vid as always Kevin :)

[silvanodemetrio]

The more I watch your vídeos, the more I know that I know nothing. Thanks for sharing your knowledge with us. Really great.

[luckymadikane]

Thanks for the tutorial. I had to install Office 356 to get more of these options. On my excel sheet - 1. I do not get the Get Data from file - PDF option. 2. The from folder option to a point of Combine and Load says - “We do not recognise the format of your first file. Please filter the list of files so it contains only supported types (Text, CSV, Excel workbooks, etc.) and try again.

[veryutils]

I really enjoyed your informative video! You might want to consider using the VeryPDF PDF to Excel Converter. This Windows software automatically converts PDF files into Excel spreadsheets and can even combine multiple PDF files into one while preserving formatting.

[farjanamammi]

Thank you so much, sir. May Allah bless you and your family with all the happiness in the world and hereafter.

[gregw]

Thank you for explaining what the Cancel button does! That was super helpful!

[SylviaSimicic]

Great Information! I transfer information from a PDF to excel all the time. I also import tables from Word to Excel.

[pcoladawg]

There should be a love button. I have been looking for two days for a video to explain this. The old Adobe system looked much easier than this newer one. Then I went to flow or whatever it is called now but didn't want to spend money on a system I didn't know would work and then the 3rd party apps started coming into play. UGH. This bypassed all of that. Thank you!

[graebeard]

Great video and tutorial Kevin. I've just been introduced to this pdf to excel feature and want to use it to grab my monthly bank statements and insert into excel. However, my pdfs usually consist of two pages and 3 or 4 tables. The first one is irrelevant as it consists of my account, name, balances and various notes and comments. The actual data I want is in the other ones. Could you do a demo on how to do something like that?

The idea of automatically adding a new month's worth of data is very exciting.

Thanks

[rosehuang]

Happened to find an easier way to get file names from a folder (better than cmd) by doing "Load data from folder". haha Great! Thank you!

[helbox]

Darn it. I have been trying to do this with the project I’m working on. The data is in multiple tables. Each pdf has 7 tables with different kind of data related to the product. Can’t get it to work. Perhaps you could in a future video make an example with importing that many tables into Excel. Thanks

[thethunderic]

You are sharing really cool windows tips and tricks 😎

[veenas]

Kevin, I truly enjoyed video making myself....tried and followed your video editor tutorial video...
Many many thanks Kevin

[BMG]

This video is great Kevin. Thank you so much. It will help me with my project big time! But now I want a cookie and I don't have man!

[tootiefruitie]

This was amazing TY! The pdf I'm working with has paragraph sections for example 1.1 text, 1.2 text, 1.3 text etc that I need to put into a table. This is going to be labor intensive. Your video is brilliant!

[JustBlankNoInfo]

Lots of work put off! Weeks, perhaps months of work just in flashes! Lovely vid: )

[ashikuzzamanabir]

Thanks a bunch. You are a great teacher. Take respect.

[Aalok]

I think the time is different today in Seattle when it is uploaded in 00:00 am and that time is equal to 1:30 pm in India but today 00:00 am in Seattle = 12:30 pm

[madhavdesai]

Thanks a lots to handle PDF format to excel without using any conversation tools 👍