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.
price-list.pdf, 2 pages, 4 columns Start from: Price list, Sheets: All pages in one sheet, Numbers: 1,234.56 (UK)
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
Pick a starting preset
Bank statement, Price list or Report tables, a sheet per page set sensible detection values. You can fine-tune afterwards.
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.
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.
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.
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 see | Try |
|---|---|
| Each row split across two lines | Move the line tolerance slider up |
| Two columns merged into one | Move the smallest gap slider down |
| One column split into two | Move the smallest gap slider up |
| Amounts treated as text | Set Numbers to the style your PDF uses |
| No rows at all | The 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