Upload the pdfs featured in the video:
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
——————————————-
All enrolments and purchases help this channel:
Free Excel Templates by Simple Sheets
Enrol in the Excel University – FREE taster course available
Enrol on the **Ultimate Excel VBA Course**
30+ hrs – includes certification
*************************************
Mediocre wall art and other stuff by Chester Tugwell
…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Nice. Could you do a tutorial where a PowerQuery extracts the entirety of a PDF of varying page length into Excel dynamically? In other words, without specifying each time how many pages the file has. It's a nice functionality to embed into a VBA subroutine.
Very useful, much appreciated Chester!
How to convert pdf histogram graph into excel in table form?
Also after uploaded the tables, the numbers are not adding up. Please advise why
Thank you. I loaded table 1 and table 2. How do I remove header/titles row from table 2 so that the header doesn’t repeat when both tables are combined in one tab? There is no delete row option after the tables are uploaded. I can only hide or group rows
When you want to load multiples pdf files and each PDF has mutiples tables, it does not work. Power Query seem to load only 1 table from each PDF
Spent a big portion of the weekend learning Power Automate Desktop Flows and RegEx to try and scrape data from PDF's. The solution is this! If only I found this 24h ago 🙂
Pdf option is not available
Superb explanation. Thank you for sharing this valuable topic.
Great Chester! Super useful PDF conversion tips and tricks. Thanks for sharing :)) Thumbs up!!
Thanks Chester, this video has been really useful.