Join Over 20,000 Members at XelPlus Academy and master Power Query: https://www.xelplus.com/courses/
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
Read the blog post: https://www.xelplus.com/bulk-import-pdf-files-to-excel/
🎬 LINKS to related videos:
How Power Query Will Change the Way You Use Excel: https://youtu.be/6lBqYInBldk
Properly Convert PDF to Excel: https://youtu.be/p2304BjvrB8
🎒 Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
📚 Excel RESOURCES I Recommend: https://www.xelplus.com/resources/
🎥 GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
👉 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
0 Comments