What gets extracted
The converter looks for tables, so on an invoice it extracts the line-item grid:
| Item | Description | Qty | Unit price | Total |
|---|---|---|---|---|
| A-102 | Printer paper, A4, 5 reams | 4 | 18.50 | 74.00 |
| B-220 | Toner cartridge, black | 2 | 42.00 | 84.00 |
- Quantities, prices and totals are written as numbers, so you can add a check column such as
=C2*D2-E2to catch errors. - Subtotal, VAT and total rows come through when they are printed as part of the table grid.
- Multi-page invoices whose item table continues onto the next page are joined into one table with Merged output.
The converter exports tables only. Header details printed outside the table, such as the invoice number, date and supplier address, are not exported as separate fields; add them as columns yourself if you are combining several invoices.
How to convert an invoice PDF to Excel
- Save the invoice PDF from the email or supplier portal.
- Drop it on the converter on this page.
- Keep Tables only. Choose Normal PDF for invoices generated by accounting software, or Scanned (OCR) for paper invoices that were scanned.
- Choose Merged for a single item table, or Split if the invoice has several separate tables (for example, goods and services listed separately).
- Convert, download, and compare the total in Excel with the total on the invoice.
Common problems and fixes
- Descriptions split across two rows. Long product descriptions often wrap. The converter merges continuation lines into the row above, but check items with very long descriptions.
- Currency symbols and thousands separators. "£1,250.00" and "1.250,00 €" are parsed as numbers. If a column stays as text, check the invoice uses one number format throughout.
- Totals block outside the grid. If the subtotal, VAT and total are printed to the side rather than as table rows, they may not be included. Type them in or use
=SUM()on the line totals. - Logo or stamp over the table. On scanned invoices, stamps and signatures over the table confuse OCR. Use Accurate mode and check the affected rows.
Working with many invoices
Convert each invoice, then copy the rows into one master sheet and add Supplier, Invoice number and Invoice date columns. From there a pivot table gives spend by supplier or by item. For a recurring supplier the layout stays the same each month, so the columns line up every time.
If invoices arrive as one combined PDF, the converter handles each table it finds. Use Split output to get one sheet per invoice table.