Extract tables from a PDF into an Excel spreadsheet
Turn statements, invoices and reports into rows and columns you can sort and calculate with. The tool finds the columns by alignment, and your PDF stays in your browser.
- Files never leave your browser.
- No account needed
- No watermark added
- Works on any device
How it works
Step 1: Choose or drop a text-based PDF.
Step 2: Choose one sheet per page or all pages in one sheet.
Step 3: Select Convert to Excel.
Step 4: Download the .xlsx file and open it in Excel, LibreOffice Calc or Google Sheets.
How rows and columns are found
A PDF has no real tables: it only knows that a piece of text sits at certain coordinates. The tool reads every text fragment together with its position (using PDF.js), groups fragments that share a baseline into rows, and then looks for vertical alignment across those rows to decide where the columns are. Each fragment lands in a cell of an .xlsx workbook.
You choose how the workbook is laid out: one sheet for every page, or every page stacked on a single sheet. The second option is convenient for a statement that runs over many pages with the same columns, because you can sort and filter the whole thing at once.
Why use this tool
Data you can calculate with
Instead of copying figures one by one, you get cells you can sum, sort, filter and chart.
Fits multi-page statements
Put all pages on one sheet to filter a long bank statement, or keep one sheet per page to stay close to the original.
Nothing leaves your device
Financial documents are read in your browser. The PDF is not uploaded and the workbook is created locally.
No account or watermark
Convert as many files as you need without signing up, and the workbook contains only your data.
Common uses
Bookkeeping from supplier invoices
Move line items from a PDF invoice into your accounting spreadsheet instead of typing quantities and prices.
Reviewing a bank statement
Load a month of transactions into one sheet, then filter by amount or description to find a charge.
Analysing a published report
Pull the data tables from an annual report or a price list so you can build your own charts and totals.
Timetables and rosters
Turn a schedule that was only shared as a PDF into a sheet you can sort by person or day.
Comparing quotes
Extract the prices from several supplier PDFs and line them up side by side in a single workbook.
Which PDFs convert well
The tool works from alignment, so the cleaner the grid, the better the result. Documents produced by accounting software, banks and reporting tools are usually made of neat text columns and convert best.
- Good candidates: invoices, bank and card statements, price lists, timetables and data tables exported from spreadsheets or databases.
- Harder cases: pages with text wrapped across several lines inside one cell, columns without consistent spacing, and pages combining a table with paragraphs of prose.
- Not possible: tables that are pictures. If you cannot select the numbers in your viewer, run OCR PDF first.
Tidying the result in Excel
Expect to spend a minute or two cleaning up. Look at the first and last rows of each page for headers or page numbers that ended up as data, delete them, and check that numbers and dates are recognized as such by your spreadsheet. If a column looks split in two, merge the cells or use a formula to join them.
Supported formats
- Input
- PDF files (.pdf) with a text layer, not password-protected.
- Output
- One Excel workbook (.xlsx).
Scanned PDFs need OCR PDF first, otherwise there is no text to place in cells.
Good to know
- Merged cells, borders, colours and cell formatting are not reproduced; you get plain cell values.
- Detection relies on text alignment, so tables without a consistent grid, or pages with several tables side by side, may come out misaligned.
- Scanned or photographed PDFs contain no text and need OCR PDF before conversion.
- Always check totals and column alignment against the original before you rely on the numbers.
Your files never leave your browser
This tool runs entirely on your device using your browser. Your files are not uploaded to our servers and are not stored anywhere. Closing the tab discards everything.
Frequently asked questions
Does PDF to Excel work on scanned documents?
Not directly. A scan is a picture with no text to place in cells. Run OCR PDF first to add a text layer, then convert the resulting file.
Should I pick one sheet per page or one sheet for everything?
Use one sheet for everything when the pages share the same columns, such as a multi-page statement, so you can filter and sort all rows. Use one sheet per page when pages differ or you want to compare against the original page by page.
Is the PDF uploaded to a server?
No. The text and positions are read in your browser and the .xlsx is created there, so the document is not uploaded.
Will formatting, borders and merged cells be kept?
No. You get plain values in cells. Borders, colours, fonts and merged cells are not reproduced, so you can format the sheet as you like.
Why are some columns misaligned?
Columns are inferred from text alignment, which can fail when spacing is irregular or several tables sit side by side. Correct those cells in Excel, or try converting again with the other sheet option.