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

Video Description

Get the Full Power Query Course here 👉 https://www.xelplus.com/course/excel-power-query/ 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. Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses 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 ➡️ Join this channel to get access to perks: 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 fits 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: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus 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