← All postsAccounts clerk comparing a printed price table with the same rows opened in a spreadsheet

Pull a Six-Page Price List Out of a PDF and Into Excel

Extract tables from a PDF into an .xlsx with real numbers and dates, joined page breaks, and optional OCR for scanned pages.

PDF to Exceltable extractionsupplier price listaccounts payablespreadsheetOCR scanned PDFdata cleanupbrowser tools
5 min readPDF Tools

A supplier sends its annual price list as a six-page PDF, and accounts payable needs it in Excel before the purchase orders go out at noon. Copying from the PDF viewer gives you one long column of text where the prices have lost their rows. PDF to Excel finds the tables, keeps their columns, and writes numbers and dates as real spreadsheet values.

The clip below shows a PDF table being converted to a workbook.

Convert PDF tables to Excel

Convert PDF tables to Excel

How the tool decides what a table is

It looks for runs of at least three rows whose columns line up. A grid of part numbers, descriptions and prices qualifies. An ordinary paragraph, a bulleted list or two-column body text does not, and the paragraphs around a table are not written to the workbook at all. A table that carries on over a page break can be joined into one, with the repeated heading row on the later page dropped, and columns of right-aligned amounts stay in a single column rather than splitting at the decimal point.

Your PDF is read in the browser and is not uploaded. That includes scanned pages: for those the tool runs OCR, and the first time you use it the OCR engine and the language data for your document have to download to the page.

The options, and what each one changes

After dropping the file you see an Options box before anything runs. Sheets can be arranged as one sheet per table, one sheet per page, or everything on one sheet. For a price list that is really one long table split across pages, one sheet per table together with the join option gives you a single continuous sheet. Choosing one sheet per page switches the join option off, since pages are then kept apart on purpose.

The checkbox for writing numbers and dates as real values should usually stay on. It is what makes SUM, sorting and filters work. The date order menu matters when you see values like 09/02/2026, which could be 9 February or 2 September. The default works it out from the other dates in the same column, and if it cannot, it leaves those cells as text until you pick day first or month first. The OCR checkbox applies only to pages that have no selectable text, and it comes with a language menu that must match the document.

Steps for the price list

  1. Drop the PDF into the box. The file name and size appear.
  2. Under Sheets, pick one sheet per table, and leave "Join a table that continues on the next page" ticked.
  3. Leave real values on. If the price list uses European dates, set the order manually rather than relying on the guess.
  4. If the file is a scan from a copier, tick the OCR option and select the language of the page.
  5. Press Extract Tables. A progress bar shows while pages are read.
  6. Read the summary: how many tables, rows and sheets were found, how many numbers were converted, and which page range was joined.
  7. Open the preview for each sheet and compare the first rows against the PDF. Then download the workbook, named after your PDF with an .xlsx ending. The download is where a trial use is counted.

What a good result looks like

Say the list has 148 product rows with the heading Part No, Description, Unit, Price repeated at the top of every page. A clean run reports one table across six pages, with the repeated heading dropped on pages two to six, and the Price column converted to numbers. In Excel, click the Price header and sort smallest first. If the column sorts like text, with 110.00 landing before 9.50, those cells were not recognised as numbers, and the preview would have shown them left-aligned instead of right-aligned.

Part numbers that begin with zeros, such as 00417, and ZIP or postal codes are kept as text on purpose, so they do not lose their leading digits. That is the desired behaviour, but remember it when you try to add that column up.

Where it struggles

The tool's own notes list the weak spots. A table with only one or two rows is not treated as a table. Merged cells and text wrapped over several lines inside one cell may come out as separate rows or be missed. Charts and images are not carried over. Scanned tables depend on the scan, so a skewed or low-contrast page can produce wrong digits, and a 6 read as a 5 in a price is the sort of error you will not notice until the invoice is wrong.

For anything read by OCR, spot-check at least the totals and a few random rows against the original. If you have a bank or card statement instead of a price list, Bank Statement to CSV is built for that layout, and the guide to converting bank statement PDFs to CSV goes through it.

Common mistakes

  • Expecting the whole document. Only tables are written, so contract clauses or notes around the table will not appear in the workbook. If you need the text, use PDF to Word or Extract Pages and Text.
  • Changing an option after extraction. The result on screen was made with the old settings, so it is cleared when you change one; run the extraction again.
  • Dropping a 60-page report when only pages 12 to 17 hold the table. Cut the pages out first with Split PDF, so the preview is quick to check.
  • Forgetting the OCR language. A German price list read with the English setting is more likely to misread umlauts and other accented letters.
  • Treating the first run as final. Compare the row count in the summary with the number of rows you can count in the PDF.

Before you send the workbook on

Add a total row in Excel and compare it with the PDF's own total, if it has one. Check the lowest and highest price, filter the Description column for blanks, and confirm that no row is split into two. Keep the original PDF next to the workbook and say in the file name which is which. If the data goes to a supplier or client, remember that a spreadsheet is easier to change than a PDF, so note the source and date in the first cell.

The reverse direction is also covered: Excel to PDF takes spreadsheet data back to a fixed-layout file. All of these sit in the PDF tools category.

Which documents give you the most trouble when you try to get data out: statements, invoices, price lists or reports? Let us know on the contact page.

Open PDF to ExcelOpen Split PDFOpen Extract Pages & TextOpen Bank Statement to CSV