Easily combine multiple PDF files with one click and format them correctly in Excel.
Don't waste your time copying and pasting because copying and pasting a pdf into Excel does not work. Everything is in a single column and you will have to manually correct each field. In this video, I will show you how to import all PDF files in a folder using Excel's Power Query – Get Data feature. You will also learn how to make it automatic. So when a new file is dropped into the folder, you just need to refresh your combined result and get the latest added data. I'll also show you potential errors you might encounter, 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.
Join 400,000 professionals in our courses here https://link.xelplus.com/yt-d-all-courses
You will also learn how to apply filters to ensure that only files with a certain extension are imported and merged.
00:00 Bulk import of PDF files into Excel
00:26 Retrieve folder data
02:39 Extract 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 at sample level
08:35 Conclusion
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
Correctly convert PDF to Excel: https://youtu.be/p2304BjvrB8
️ Join this channel to access the benefits: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
Get the official XelPlus MERCH: https://xelplus.creator-spring.com/
Not sure which of my Excel courses is best for you? Take the quiz: https://www.xelplus.com/course-quiz/
RESOURCES I recommend: https://www.xelplus.com/resources/
Let's connect on social media:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus
This description contains affiliate links, which means that, at no additional cost to you, we will receive a small commission if you make a purchase using these links. This helps support the channel and allows us to continue making videos like this. Thank you for your support!
#Excel #powerquery
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments