Need to total a statement, sort an invoice list, or reuse a table from a report? Moving PDF data into Excel can save retyping, but a conversion is only a starting point: columns may shift, dates may be misread, and scanned pages may contain images rather than extractable text.
Choose the method based on the PDF and the sensitivity of its contents, then compare the spreadsheet with the original before relying on its numbers.
Choose a method
- A text-based PDF with tables: If your Excel version offers the PDF connector, use Power Query. It can show tables found in a PDF so you can select and transform the data before loading it. See Microsoft's Power Query PDF connector guide.
- A one-off, non-sensitive file: A dedicated converter can be convenient. CleverPDF's PDF-to-Excel tool is one option; check the service's current terms before uploading a document.
- A scanned or image-only PDF: Run optical character recognition (OCR) with a tool approved for your data first. OCR turns page images into text, but it can confuse similar characters and still needs review.
- A confidential file: Prefer a workflow that keeps the document on an approved local device. Don't upload invoices, payroll, customer records, or financial statements to an online service unless you are authorized and have checked how it handles uploaded files.
Import a PDF with Excel Power Query
- In Excel, open Data and choose Get Data > From File > From PDF. Menu labels can vary by version.
- Select the PDF. In Navigator, inspect the tables and pages Excel finds; select the relevant table rather than assuming the first result is complete.
- Choose Transform Data to review and clean the table in Power Query, or Load if the preview is already suitable.
- Check the result against the PDF before using it. Microsoft's connector documentation also describes handling large PDFs and cases where multi-line rows aren't identified as expected.
If the PDF connector isn't available in your Excel setup, use an approved desktop converter or a trusted online service only for a file that is appropriate to upload.
Clean the spreadsheet and verify it
PDFs preserve page layout, not necessarily the structure of a spreadsheet. Before analyzing the result:
- Remove repeated page headings, footers, blank rows, and stray totals that have become part of the table.
- Check that each value is under the right heading, especially rows that wrap across lines or continue on another page.
- Review dates, decimal separators, negative amounts, and currency symbols. Keep identifiers such as account numbers or postal codes as text when leading zeros matter.
- Compare row counts and important totals with the source. Spot-check records from the beginning, middle, and end of the document; for a short table, check every row.
- Keep the original PDF and make corrections in a separate spreadsheet so you can trace any discrepancy.
Only after those checks should you use filters, formulas, or charts to support a business decision. If you're preparing your operations for more work, see our guide to preparing your business for expansion.
Cover photo by John Schnobrich on Unsplash
