Convert PDF to Excel | Convert Multi-Page PDF to Excel | Import Multiple PDFs Tables into Excel

 

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ Thank you! 👍👍 Upload the pdfs featured in the video: https://www.bluepecantraining.com/wp-content/uploads/2021/11/pdfs.zip In this video I demonstrate how to import a table of data into Excel from a pdf file. Often the data you want to import from a pdf is in a table. If you have ever tried copying and pasting a table directly from a pdf into Excel, you will know it doesn't work. If, however, you first paste into Microsoft Word and then into Excel, it does work. Microsoft Word also allows you to convert a pdf into a Word document, from where you can also copy and paste. If you are regularly importing from pdfs and you want new pdfs or updated pdfs to automatically update your spreadsheet, then you should be using Power Query. This video demonstrates how to convert a pdf containing a multi-page table as well as importing multiple pdfs within a folder. Table of Contents: 00:00 - Intro 00:59 - Copy Paste into Microsoft Word and then into Excel 01:44 - Convert PDF to Word and then Copy Paste into Excel 02:47 - Power Query: Import One of Many Tables in a PDF into Excel 04:08 - Power Query: Import Table that Spans Multiple Pages in a PDF into Excel 06:56 - Power Query: Update spreadsheet when PDF changes 07:58 - Power Query: Import Multiple PDFs in the Same Folder into Excel 10:39 - Power Query: Update spreadsheet when new PDFs added to folder ------------------------