PDF to Excel: How to Convert PDF Tables to a Spreadsheet
Bank statements, invoices and reports often arrive as PDFs, but you need the numbers in a spreadsheet to sort, total or chart them. A PDF to Excel converter pulls the text out and arranges it into rows and columns.
Quick answer
- Open the DailyConvertTools PDF to Excel converter.
- Choose your PDF.
- Click Convert to Excel (.xlsx) and download the file. Each PDF page becomes its own sheet.
- Open it in Excel or Google Sheets and check the columns line up.
How the conversion works
The converter reads the text in your PDF along with its position on the page. Text at the same height becomes a row, and text that starts at the same horizontal position becomes a column. As a result, it works well for clean digital tables, such as statements and price lists.
What converts well (and what doesn’t)
| PDF type | Result |
|---|---|
| Exported from Excel, Word or accounting software | Usually good: rows and columns line up |
| Simple tables with clear columns | Good |
| Merged cells, multi-line cells, rotated text | May need tidying |
| Scanned paper or photos of documents | Won’t convert: there’s no selectable text |
How to tell if a PDF is scanned: try to select a word with your cursor. If you can’t, the page is an image and needs OCR (text recognition) before it can become a spreadsheet.
Tidying the spreadsheet
- Delete header and footer rows (page numbers, logos) that came across with the table.
- If Excel stores numbers as text, select the column and use Data → Text to Columns, or multiply by 1.
- Combine pages: copy each sheet’s rows into one sheet if the table spanned several pages.
- Check totals against the original PDF before relying on the data.
Other options
In Excel for Microsoft 365 on Windows, you can also use Data → Get Data → From File → From PDF to import tables directly. For the reverse job, use an Excel to PDF converter, and see what is a PDF for background on the format.
Frequently asked questions
How do I convert a PDF to Excel for free?
Upload it to a free PDF to Excel converter and download the .xlsx file.
Why didn’t my PDF convert?
It’s probably a scan with no selectable text. Run OCR on it first.
Does the formatting carry over?
You keep the data and the row and column layout; however, fonts, colours and merged cells usually don’t carry over.
Can I convert a PDF to Google Sheets?
Convert it to Excel first, then upload the .xlsx file to Google Sheets.
