Convert a PDF to an Excel spreadsheet
Drop in your PDF and the tool finds the tables on each page, then saves them in an Excel workbook (.xlsx), one sheet per table, with numbers converted to real numbers. It works on PDFs that contain text, not on scans. The server deletes your file as soon as the download starts.
- ✅ Free
- 🔒 No sign-up
- 📱 Works on mobile
- ⚡ Instant results
🔒 This conversion runs on our secure server. Your files are deleted automatically after 1 hour and are never read or kept.
📌 Key facts
- To turn a PDF to Excel, the tool reads the position of every word and line on each page, then rebuilds the tables.
- Each table becomes a sheet in the .xlsx workbook, named for example P2-T1 for page 2, table 1.
- Cells that hold only a number become real numbers that you can sum and sort.
- A scan or a photo produces no table, so run it through OCR first.
- The file can weigh up to 20 MB, the first 60 pages get read, and the server deletes everything after sending.
How the converter finds tables
It reads the position of every word and every line on the page. Two methods run in order:
- Tables with borders: the lines drawn in the PDF mark out the cells. This is the most reliable method.
- Tables without borders: when no lines are drawn, the tool looks for aligned columns of text. It skips ordinary paragraphs, whose "columns" would cut words in half.
Each table becomes a sheet named P2-T1 (page 2, table 1) with a bold header row. Numbers such as 1,250.50 or 1 250,50 become real Excel numbers, so you can sum and sort them.
What it can't do
A PDF is a picture of a page, not a spreadsheet, so tables are rebuilt rather than read. Know the limits before you start:
| Situation | Result |
|---|---|
| PDF made from Word, Excel or accounting software | Very good |
| Table with merged cells | Merged cells split across columns |
| Scan or photo of a table | No table found: run OCR first |
| Password-protected PDF | Refused |
| More than 60 pages | The first 60 pages are read |
Limits: 20 MB per file and 15 conversions per hour per person.
Check the result in Excel
Open the file and check three things: the row count, the total of a column you already know, and the dates. If a total differs from the PDF, a cell was probably split or merged. When a table runs across several pages, each page gets its own sheet: paste them one under the other into a single sheet.
PDF to Excel: prepare the file for a clean result
For a smooth PDF to Excel conversion, look at the document first. In fact, the result depends on the software that made the PDF. So try selecting text with your mouse. If you can, the PDF holds real text and extraction has a good chance of working.
- First, open the PDF and select a cell of the table.
- Next, note which pages hold the tables you need.
- Then split the file if it passes 60 pages or 20 MB.
- Finally, run the conversion and open the workbook in Excel.
PDF to Excel: which documents give the best tables
| Document type | Odds of success | Tip |
|---|---|---|
| Statement or invoice from software | Very good | convert it directly |
| Table with clear borders | Good | check the totals afterward |
| Borderless table with aligned columns | Medium | check where the columns land |
| Scan or photo | None without OCR | run text recognition first |
So you know ahead of time whether a PDF to Excel job needs cleanup. Also, a table that spans several pages gives several sheets, which you can paste one under the other.
Common mistakes when you convert PDF to Excel
- Converting a scan: because the tool reads text only, it finds no table.
- Trusting totals blindly: in fact, one merged cell can shift a column.
- Forgetting units: for example, a cell with $12.90 stays text.
- Uploading a protected PDF: but the tool refuses it, so remove the password first.
If your text is an image, try OCR PDF. Next, convert the PDF to Word for a text document. To go the other way, use Excel to PDF. Finally, compress the PDF when it passes the limit.
After you convert a PDF to Excel: clean up the workbook
Once the PDF to Excel conversion is done, a few minutes of cleanup is enough. First, delete any empty columns that extraction created. Next, check that dates sort properly, because a foreign format sometimes leaves them as text. Finally, recompute a total you already know to confirm nothing is missing.
- Use Data, then Text to Columns, to turn stray text into numbers.
- Freeze the top row to read large tables.
- Keep the original PDF next to the workbook for comparison.
That way, your PDF to Excel file becomes a real working table, ready for filters and pivot tables.
3 real-life examples
A 3-page statement exported from your bank
The PDF holds one table per page, 25 rows each. You get 3 sheets: P1-T1, P2-T1, P3-T1. In Excel, paste them into one sheet and total the Amount column with =SUM(D2:D76).
A price list from a supplier
Prices are printed as "$12.90". They land in Excel as text with the dollar sign, because only pure numbers are converted. Use Find & Replace (Ctrl+H) to remove the "$" and the cells become numbers you can calculate with.
A report with no table in it
A 12-page text report with a single chart: the tool answers "no table found". That's expected, it doesn't invent tables out of paragraphs. To get the text instead, use PDF to Word.