Map Extract
Free tool

Convert PDF tables to Excel

Suppliers send price lists as PDFs, councils publish data tables as PDFs and banks send statements as PDFs. Copying them into a spreadsheet by hand is slow and error-prone. This tool rebuilds the rows and columns from where the text sits on each page.

Runs in your browser. Nothing you enter is uploaded.

Example: a wholesaler's trade price list

A garden shop receives a two-page trade price list as a PDF and wants it in a spreadsheet to add its own margins. We built a list like that, with the header repeated at the top of page 2, and used the Price list preset.

The repeated header on the second page is dropped, so the sheet has one header and five products. With numbers set to the UK style, £1,240.00 becomes the number 1240 in the XLSX, ready for formulas.

Input
price-list.pdf, 2 pages, 4 columns
Start from: Price list, Sheets: All pages in one sheet, Numbers: 1,234.56 (UK)
Result
Columns (page 1): 4, Rows found: 6, Sheets: 1
Code | Product | Pack | Trade price
TP-440 | Terracotta planter 40 cm | 6 | 14.5
WB-900 | Window box 90 cm | 2 | 1240
HB-210 | Hanging basket 21 cm | 10 | 3.2

Converting a PDF table

  1. Pick a starting preset

    Bank statement, Price list or Report tables, a sheet per page set sensible detection values. You can fine-tune afterwards.

  2. Choose the PDF

    Pages are read one by one. If no text is found at all, the tool tells you the PDF is scanned and needs OCR first.

  3. Tune the detection

    Raise Rows: line tolerance if one row is split in two; lower Columns: smallest gap if two columns run together. The preview updates as you move the sliders.

  4. Set sheets and numbers

    Put all pages in one sheet or one sheet per page. Choose UK (1,234.56) or European (1.234,56) number style, or keep everything as text.

  5. Download

    Download CSV or Excel (XLSX) for the first sheet, JSON for developers, or Every sheet (XLSX) for a workbook with all sheets.

Fixing common problems

You seeTry
Each row split across two linesMove the line tolerance slider up
Two columns merged into oneMove the smallest gap slider down
One column split into twoMove the smallest gap slider up
Amounts treated as textSet Numbers to the style your PDF uses
No rows at allThe PDF is scanned; run OCR first

Questions people ask

How do I convert a PDF table to Excel for free?

Open the PDF here, choose the preset closest to your document, check the preview and press Excel (XLSX). Rows and columns are rebuilt from where the text sits on each page. The file is read in your browser, so price lists and statements are not uploaded to a converter.

Can I convert a scanned PDF to Excel?

Not directly: a scanned page is an image with no text positions to read. Make the PDF searchable with an OCR tool first, then open the new copy here. Check the result closely, because recognition errors in figures are easy to miss.

Why do my numbers appear as text in Excel?

Either the Numbers option is set to keep as text, or it is set to the wrong style for your document. UK documents use a comma for thousands and a point for decimals; many European ones do the reverse. Pick the matching style and download again.

Can each page go on its own sheet?

Yes. Choose One sheet per page, or start from the Report tables preset, which does this by default. Then use Every sheet (XLSX) to download a workbook with one sheet per page. The CSV and single XLSX buttons give the first sheet only.

Where your data goes

Text positions are read from the PDF and turned into rows by your browser. The document and the spreadsheet you download are created and kept on your own computer, with nothing sent to a server.

Checked against the tool on

Top