English
How to convert a PDF table to Excel
This PDF to Excel converter finds the tables in a text-based PDF and writes them to an .xlsx or .csv file, all inside your browser. Nothing is uploaded. Steps:
- Choose the PDF or drop it on the box. Try a sample PDF loads a two-table example.
- Look at the grid under Preview of what will be exported. Each table has a tick box, so you can leave out a table you do not need. Use the page menu to move through the document.
- If columns are joined or split in the wrong place, change Column spacing. If no table is found at all, switch to Every line as a row.
- Press Download .xlsx or Download .csv.
How are the columns found?
A PDF stores text at coordinates and has no idea of rows and columns. The tool groups text on the same baseline into a line, cuts the line wherever there is a wide gap, and then looks for vertical white strips that run through several lines. Those strips are the column borders. A table needs at least two rows with two or more cells that line up.
Column spacing sets how wide a gap has to be before the line is cut.
| Setting | A gap counts from about | Pick it when |
|---|---|---|
| Tight | 0.5 times the font size | Two columns are glued together in one cell |
| Normal | 0.9 times the font size | Most statements, price lists and reports |
| Wide | 1.6 times the font size | A column is cut into several cells, for example names with spaces |
Headers that do not sit above their numbers, such as a left-aligned title over right-aligned figures, are matched to the right column. Cell text that wraps onto a second line is joined back into its cell.
Numbers: 1.234,56 or 1,234.56?
Indonesian, German and Spanish documents write one thousand two hundred thirty-four and fifty-six cents as 1.234,56. US and UK documents write 1,234.56. When both marks appear the meaning is clear. A single mark with three digits after it is the problem: 1.234 can be a thousand or a bit more than one. With Detect automatically the tool counts which style the document uses, and falls back on the page language if it cannot tell. You can override it.
| Text in the PDF | Becomes in Excel |
|---|---|
| 1.234,56 or 1,234.56 | 1234.56 |
| 1.234 (decimal comma format) | 1234 |
| 1.234 (decimal point format) | 1.234 |
| 12,5 | 12.5 |
| (1,500.00) or 1.500,00- | -1500 |
| Rp 1.234.567 | 1234567, the currency name is dropped |
| 12.5% | 12.5%, stored as 0.125 with a percent format |
| 00123 | Stays text, so leading zeros survive |
| 12/03/2026 | Stays text, dates are not guessed |
Cells with real numbers keep their decimal places and thousands separators as number formats, so they look like the PDF but still add up. Header rows are never converted.
One sheet per page or all pages on one sheet?
Per page gives sheets named Page 1, Page 2 and so on, handy when every page is a different table. One sheet stacks all tables in order, which is what you want for a bank statement that runs over several pages. When the header row is the same on every page it is written once, and tables with the same columns follow each other without a blank row. Tick Add a Page column to keep track of where each row came from. In our test, a two-page statement with 70 transactions gave 71 rows and a Page column on a single sheet.
XLSX or CSV?
XLSX keeps number formats, a bold frozen header row and column widths. CSV is plain text for importing into other software. It is saved as UTF-8 with a byte order mark so accents, Chinese and Arabic open correctly in Excel. Excel with a decimal comma setting reads semicolon-separated files, so choose the semicolon separator there. CSV always writes numbers with a decimal point. With several sheets you can also download one ZIP with a CSV for each page.
Scans, merged cells and other limits
A scanned PDF has no text. The tool offers OCR, but digits in scanned tables are misread often enough that you should compare the grid with the original before trusting totals. Merged cells become one cell holding the text, with the cells beside it empty. Tables drawn as pictures, tables without clear columns, and tables split over two columns of page text are not reliable. When a table is missing, Every line as a row exports all text so nothing is lost, and you can tidy it in Excel. Files up to 150 MB and 600 pages per run are accepted, and a page range keeps big files quick.
Frequently asked questions
How do I convert a PDF table to Excel without uploading the file?
Drop the PDF here, check the grid under Preview and press Download .xlsx. Your browser finds the columns from the text positions and writes the workbook itself, so the PDF never leaves your device. A 10-page statement takes a few seconds.
Why are my PDF columns merged or split into too many cells?
A PDF has no real table, only text placed at positions, so columns are guessed from the gaps. If two columns are joined, set Column spacing to Tight. If one column is cut into pieces, set it to Wide. The grid updates straight away.
How does it handle numbers like 1.234,56 and 1,234.56?
Both are read as numbers. With Detect automatically the tool counts which style your document uses and applies it to ambiguous values such as 1.234, which is one thousand two hundred thirty-four in Indonesian or German style and one point two three four in US style. You can force either format. Values like (1,500.00) become negative, 12.5% becomes a percentage, and codes with leading zeros such as 00123 stay text.
Can I get one sheet per page or everything on one sheet?
Yes. One sheet per page names the sheets Page 1, Page 2 and so on. All pages on one sheet stacks every table, drops a repeated header row on later pages, and can add a Page column so you know where each row came from.
Can I convert a scanned PDF or a bank statement photo?
Only after OCR. A scan has no text, so the tool offers to read the pages with Tesseract OCR in your browser. Numbers and columns from scans are often misread, so compare the grid with the original, especially digits.
What is the difference between Detected tables and Every line as a row?
Detected tables keeps only blocks where several lines share columns, and ignores paragraphs. Every line as a row exports all text on the page and splits each line into cells at wide gaps. Use the second one when the first finds nothing.
Can I download CSV instead of XLSX?
Yes. The CSV is UTF-8 with a byte order mark so accents and Chinese or Arabic text open correctly in Excel. Choose a semicolon separator if your Excel uses a decimal comma, because that version of Excel reads semicolons. With several sheets you also get all CSV files in one ZIP.
Is there a size limit?
PDFs up to 150 MB and 600 pages at once can be opened. Pages are read one by one with a progress bar and a Cancel button. Type a page range such as 1-10 to export only those pages.