Turn a PDF table into an Excel workbook
Copying a table out of a PDF by hand usually leaves every value crammed into one column. This guide shows how to get the rows and columns into an .xlsx workbook you can open in Excel or any other spreadsheet program.
Your file is never uploaded. The PDF is read in your browser and makes no network requests while it works.
Open the PDF table to Excel / CSV tool
Steps
- Open the tool and drop your PDF onto the box, or click it to pick the file.
- Wait for the status line to report how many pages, rows and columns were found.
- Set Output to XLSX (Excel).
- Look over the preview, which lists up to 50 rows.
- Click Download to save a workbook named after your PDF.
Good to know
One sheet, called Table
Every page you select goes into a single worksheet named Table, stacked top to bottom. Split it into separate tabs afterwards if you prefer one tab per page.
Numbers arrive as text
Cells are written exactly as the characters in the PDF, so 1,234.56 or (12.00) land as text, not numeric values. Use your spreadsheet's convert-to-number or Text to Columns feature before running sums.
Headings and notes
A title line above the table becomes its own row, usually in the first column. Delete those rows once the file is open.
Questions
Does it keep fonts, colours or borders?
No. Only the text is carried over. Styling, lines and images in the PDF are not part of the workbook.
Can I open the file in LibreOffice too?
Yes. The download is a standard .xlsx file, which most spreadsheet programs can open.
Have bank statements as PDFs instead? RowSmith converts text-based PDF statements to CSV or Excel in your browser.
This guide was written with AI assistance and reviewed against the tool's behaviour. Always review your output before using it.