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
------------------------