Bulk Combine PDF files to Excel without losing formatting & NO 3rd party software

Easily combine multiple PDF files with one click and get them properly formatted in Excel.
Don't waste your time copying and pasting because copying and pasting a pdf into Excel doesn't work. Everything ends up in a single column and you will have to manually correct each field. In this video I'll show you how to import all PDF files from a folder by using Excel's Power Query - Get Data functionality. You'll also learn how to make it automatic so when a new file is dropped in the folder, you just need to refresh your combined result and you get the latest data added. I'll also show you potential errors you could run into, for example Power Query showing a "corrupt" error when another file type is added to the folder. You'll learn how to exclude other file types and add additional filters to your query.

You'll also learn how to apply filters to make sure only files with a certain extension are imported and merged.

00:00 Bulk Import of PDF files into Excel
00:26 Get Data From Folder
02:39 Extract a Text Between Delimiters
03:58 Update Report with New Files
04:28 Merge Columns with a Separator
05:06 Filter Files with Specific Extensions
06:45 Filter File Extensions on Sample Level
08:35 Wrap Up

🎬 LINKS to related videos:

🚩Let’s connect on social:

This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel #powerquery

[ugabrew]

Wow! You have a way of designing these examples and walking us through them that deserves a Teacher-of-the-Year award. Possibly also a Medal of Freedom. We all owe you a big thanks!

[bill]

Thank you, Leila! You're the best! After watching several other videos on this topic that were too complicated, too wordy or just "too-something", I discovered your video. What a breath of fresh air! Concise and successful! Can't ask for anything more than that. Your video helped me to accomplish exactly what I needed it to do. Again, thank you!

[joshuablack]

This is awesome. I would normally combine the PDFs in Adobe Pro and then export them as an excel, but that's a one-time solution. Having the ability to refresh the file as more PDFs are added to the folder makes the process look much more streamlined.

[GarthShaner]

Holy Moley! I am thinking about how much time this would have saved me on a project I did back in 2007. This is amazing! Thank you so much for sharing!

[excellover]

This is awesome.. A big thanks for your time and efforts. For me this task was impossible until I watched this video. May you live long in good health and peace so that you can enlighten us with your latest contents in excel. Always love to spend time to watch your videos. Thanks once again.

[timsulzberger]

Nicely done, Leila! Excellent explanation of a complicated problem. Thank you for explaining this in such a straightforward way.

[besthobbit]

Thank you SO SO much. People at work think it's a good idea to save their spreadsheets as MULTIPAGE PDFs and send them around the org instead of just sending the Excel file.... now I won't need to spend so much time making them an Excel file again.

[villiamo]

Excellent vid. The thing about filtering for the sample file was very good - not very obvious (to me, at least!) when you're looking at an error and thinking you've already filtered to get just pdfs!
Thanks!

[TickyMN]

Wow! That was amazing. Thank you so much Leila! I'll be applying this today.

[tristangeoffroy]

Hi Leila, …I loved this demonstration, once again you taught me something I through I knew already. For you to have a smile: I was used for years doing this process by making my first file query, then advanced edit to change it into the function I will invoke against the filtered files query.
Then recently, I saw this help query. Saying myself, what’s that noise? I didn’t ask for, it’s weird It looks like something I need but didn’t know how to use it, so I trashed it all, and redo it my own old way of doing. …ridiculous, no?
As you already mentioned this tool is one of the best productivity and solid tool I have ever used for years in the area, tremendous, powerful, fit to a large range of users, from basic to advanced.
Thank you for the knowledge sharing

[Thatien]

Amazing. That's very helpful. I ran a test with my PDF data, and it worked perfectly.

[mikelight]

Wow, you're amazing and think of major potential issues and resolve them. Amazing.

[rppr]

This is an amazing feature, and this video clearly demonstrates it. Awesome job. Thanks.

[clashwithketan]

I'm glad I found this channel. I've saved MS Excel Playlist and planning to watch all videos very soon. High quality content is highly appreciated. I will support this channel. From India ❤

[arineems]

This is therapeutic. I feel calm watching this video ❤️

[goldendice]

Excellent job Leila. Thanks for making our tasks super easy 🙂

[williambell]

Leila, you are THE MAGNIFICIENT! I appreciate you, and your channel so much!

[islamv]

Well explained, i rarely comment on videos, but you deserve it, thanks for sharing.

[thenotidevil]

Super awesome as usual. Thanks a lot for sharing this with us all. it's really helpful

[chrism]

Wow! I didn’t know this could be done. Thanks Leila!