PDF DocOfficeHow to Convert a PDF Table into an Excel Spreadsheet (XLSX)
Copying a table out of a PDF usually ends with every value squashed into one column. Converting the document to a real spreadsheet lets you sort, filter, total and chart the data straight away.
The PDF to Excel tool reads the position of every word on the page, groups words into rows and columns, and writes the result to an .xlsx file. Because this reconstruction is computation-heavy it runs on our Python server, and your file is removed immediately after the download.
How it works
Tables in a PDF are only lines and words drawn at certain coordinates. There is no real table object. To rebuild one, the converter has to decide which words belong to the same row, where the column boundaries are, and which cells are empty. When columns are separated by clear gaps this works very well, and when text crosses column borders it needs a closer look.
When this is useful
- Moving bank or card statements into a budget spreadsheet.
- Analysing supplier price lists and catalogues that arrive as PDF.
- Collecting figures from annual reports for charts and comparisons.
- Reconciling invoices against purchase orders.
- Turning timetables, rosters or scoreboards into sortable lists.
Step-by-step instructions
- Open the PDF to Excel tool and select your PDF (up to 50 MB).
- Start the conversion and wait for the progress indicator to finish.
- Download the .xlsx file and open it in Excel, LibreOffice Calc or Google Sheets.
- Scan the first rows and the totals against the original PDF to confirm that the columns lined up correctly.
Tips for the best results
- Tables with clear column gaps and consistent spacing convert most accurately.
- Scanned statements are pictures, not text. Run them through Image to Excel & Word so that OCR can read the numbers.
- After conversion, set the number format of amount columns so that Excel treats them as numbers instead of text.
- Merged header cells in the PDF may become separate cells in Excel. Merge them again if you need the original look.
- Convert only the pages you need by splitting the PDF first. This keeps the spreadsheet tidy.
Common problems and how to fix them
Two columns are merged into one
Use Data > Text to Columns in Excel to split on spaces or a delimiter, or insert a column and cut the text manually.
Amounts have a leading apostrophe or align left
Excel is treating them as text. Select the cells, apply a Number format, and re-enter or use Value conversion.
Rows are out of order or duplicated
Compare with the source page. Multi-line cells in the PDF sometimes become several rows, so merge them back together.
What happens to your file?
Frequently asked questions
Does it work for bank statements and invoices?
Yes, as long as the PDF contains selectable text. Always verify totals against the original before you rely on the numbers.
Why are some numbers shown as text in Excel?
Excel sometimes keeps imported values as text. Select the column, choose a Number format, or use Data > Text to Columns to convert them.
Is there a page or table limit?
The practical limit is the 50 MB file size. Very long documents are easier to handle in several smaller parts.
Related guides
- How to Convert a PDF to an Editable Word Document (DOCX)
- How to Convert an Image (JPG or PNG) into Excel or Word with OCR
- How to Split a PDF into Separate Files or Page Ranges
Try PDF to Excel now — free, no sign-up