How to Convert PDF Tables to Excel
Import PDF tables with Excel Power Query, clean and verify the cells, and handle scanned PDFs using text recognition first.
Start with the original spreadsheet if you have it. If the PDF is your only source, try importing the table into a version of Excel with the Power Query PDF connector.
Import a table in Excel
- Go to Data → Get Data → From File → From PDF, then choose the file.
- In Navigator, select the table that matches the PDF and inspect the preview.
- Choose Transform Data to remove repeated headers, split combined columns and set data types. Keep IDs with leading zeros as text.
- Load the table, compare row counts and totals with the PDF, and save the workbook. Microsoft Support
Prepare a scanned table
Use OCR to make the text selectable. If Power Query still cannot detect the table, copy small sections or export text, then rebuild the columns and verify the cells against the scan. PdfWord produces searchable PDF or plain text for this workflow. Excel handles the workbook output.