Convert PDF tables to Excel

When a PDF “table” is not a spreadsheet

A table in a PDF is usually a visual arrangement of text. The file rarely stores rows and columns the way Excel does. Characters are placed on a page. Lines wrap. Headers repeat. Totals sit in the same visual grid as products. A converter that only dumps text in reading order will scramble that grid. Linework groups text by position, guesses a header, and builds candidate product rows. You still decide which header is correct and which columns mean code, description, pack and price.

That is why this tool is a PDF table extractor with review, not a promise to clone any layout into a workbook.

The workflow

1. PDF
2. Detect table rows
3. Map columns
4. Review extracted data
5. Download Excel

Choose the file on the converter. Automatic mode reads selectable text and uses English OCR on sparse pages. Confirm the header row. Map each Linework field to a PDF column, or mark a field as not in the PDF. Set decimal comma or decimal point. Then walk the rows beside the page preview. Remove section titles and totals. Merge a description-only continuation into the row above when it belongs there. Mark each valid row checked, then download.

What Linework extracts

The working table is product-shaped:

• Product code or SKU
• Description
• Pack size
• Unit price
• Currency
• Source page and source text

It is a good fit for price lists, catalogue tables and itemised product quotations. It is a poor fit for reconstructing a multi-sheet financial model, a graphic-heavy brochure, or an invoice with tax logic.

Use cases

Typical jobs include turning a supplier price list into a working file, pulling a catalogue table into rows you can filter, and preparing product lines from a quotation. If the table is a scan, use the scanned PDF converter path and expect more checking.

Limitations

Files are limited to 15 MB, 50 pages, 20 OCR pages and 3,000 candidate rows. Matching repeated headers can follow a table across pages when columns shift, but wrapped descriptions, multiple tables on one page, footers and non-English headers still need care. Linework does not invent missing cells or rebuild merged visual cells as Excel merges.

Privacy

Your PDF is processed locally in your browser and is not uploaded to Linework for document processing. See PDF to Excel without uploading.

Copy-paste versus a reviewed extract

Copying a table from a PDF viewer often looks successful until you sort a column. Hidden line breaks sit inside descriptions. Prices arrive as text with mixed commas. A code that looked like 00124 becomes 124 the moment Excel guesses a number. Linework does not remove the need to check, but it does give you an explicit header, column map, decimal format and a checked-row gate before download.

If you already have a clean text table, selectable-text mode is the fastest path. If you only have a scan, you are not copying text at all—you are recognising an image. Those two jobs fail in different ways, which is why the reading-mode control exists.

Preparing a file before you convert

Split a document that is larger than 15 MB or 50 pages. If more than 20 pages are scans, split those too. Unlock password-protected PDFs first; Linework cannot read them. Prefer the original digital list over a photographed printout. If you must photograph a page, keep it upright, evenly lit and cropped to the table. Then decide whether you need every page: a 40-page brochure with four pages of prices should be reduced to those four pages when you can.

After export, keep the PDF and the spreadsheet together. The source-page column is there so a later reader can reopen the same page. If a colleague only receives the XLSX, they lose the ability to see a smudged digit in context.

Frequently asked questions

Supplier price listsWhy conversions go wrongFull workflow