Import PDF data into Excel and refresh it automatically. Microsoft Excel 365 or 2024 for Windows has a refreshable PDF connector that lets you import tables or entire pages from PDF files using the Get & Transform tool. This means you can set up a process once and optionally refresh your spreadsheet whenever the PDF changes, ideal for weekly reports or recurring data updates.
Excel can detect tables in the PDF, choose one or more tables to import into Excel. Or import entire pages.
Importing details from PDF files isn’t ideal but sometimes it’s the only option available.
This uses the powerful PowerQuery part of Excel for Windows with all it’s nifty features for transforming the data to make it suitable for your needs. Go to Data | Get Data | From file | from PDF.
Using Get & Transform means that the PDF import options are repeatable and refreshable.
For example, a weekly PDF of values can be imported into Excel using the same settings each time.
Password protected PDF’s are not supported. That’s a pity and a little strange because Word can open a PDF after prompting for the password. Important data is more likely to be locked in a passworded PDF. It would be useful if Get & Transform could unlock a PDF with a saved password.
This feature available in Excel 365 and Excel 2024 for Windows
So-called ‘Edit PDF’ feature is coming to Word for Mac
Three ways to add a PDF into a Word document
