Invoice to Excel

One row per invoice, in the columns you name.

Upload a folder of PDF invoices, say which fields you want in the spreadsheet, and get one Excel workbook back with a row for each document.

  1. 01

    Upload the invoices

    Select a folder of PDF invoices. Each file is one record, so suppliers with different layouts can go in together.

  2. 02

    Name the columns once

    Type the fields you want — the nine below are a starting point, not a fixed template. Describe a field if its meaning is ambiguous, or set its data type.

  3. 03

    Extract each document

    Every invoice is read against the same column set, so the output is one consistent table rather than nine different shapes.

  4. 04

    Review before you download

    Each invoice appears as one row with its source file beside it. A value that could not be located confidently is left blank rather than guessed at.

A worked example

Three invoices, three suppliers, one table.

These three PDFs came from different suppliers in different formats and different currencies. Asking for the same nine columns turns them into three rows you can sort, total and hand to an accountant. The last invoice quotes no purchase order, so that cell is blank rather than filled with a guess.

Example extraction result
Source PDFSupplierInvoice NumberInvoice DateDue DateSubtotalTaxCurrencyTotalPO Number
inv-4471.pdfNorthgate Supplies LtdINV-44712026-08-032026-09-021,840.00368.00GBP2,208.00PO-10233
ACME-0925.pdfAcme Components GmbH2026/09252026-08-112026-09-10640.50121.70EUR762.20PO-10241
statement-aug.pdfSeri Jaya Trading Sdn BhdSJ-088122026-08-192026-09-183,120.00187.20MYR3,307.20

The fields an invoice usually carries

These are the columns most accounts-payable spreadsheets are built from. You name them once and they apply to every document in the batch — and you are not limited to them.

  • SupplierThe billing entity as printed, not the trading name on the letterhead.
  • Invoice NumberThe supplier's own reference, however they format it.
  • Invoice DateThe issue date, normalised to one format across every supplier.
  • Due DateEither the printed date or the one the payment terms imply.
  • SubtotalThe net figure before tax.
  • TaxVAT, GST, SST or sales tax, whichever the document uses.
  • CurrencyRead from the document rather than assumed from the supplier's country.
  • TotalThe amount payable, matching the figure the supplier expects.
  • PO NumberYour own purchase-order reference, where the invoice quotes one.

Why the columns are yours to choose

A converter with fixed invoice fields only helps if your spreadsheet happens to be shaped the same way. Most are not: a bookkeeper reconciling a bank feed wants the total and the date, a procurement team wants the PO number and the delivery reference, and an auditor wants the tax broken out. Naming the columns yourself means the output lands in the sheet you already use instead of a sheet you then have to rearrange.

It also means an invoice field nobody anticipated is not a dead end. If the document prints it, you can ask for it.

The same workflow applies to any repeated document, not only invoices: multiple PDFs to one Excel describes choosing the columns once and running a whole folder through them.

What re-typing a batch of invoices costs

Copying 200 invoices into a spreadsheet by hand, at 2 minutes each, is 6 hours 40 minutes of typing. That figure is arithmetic on those two assumptions rather than a measurement — they are printed here so you can substitute your own batch size and your own pace and see whether the manual route is worth it for you.

Every row keeps its source file

The preview shows which PDF each row came from, which is what makes checking possible: a total that looks wrong can be traced back to the document it was read from in one step. Values that could not be found confidently stay blank, so the gaps are visible rather than papered over. How it works walks through the same flow with a smaller example.

Free tools for the work around the invoices

Some of the handling before and after an extraction does not need an account at all. Merge PDF combines a month of single-page invoices into one file, Split PDF separates a multi-invoice statement back into documents, the page counter tells you how large a batch actually is, and Extract Text shows you whether a document has a text layer at all. All of them run in your browser, and the rest are on the free tools page.

Reading further

Extracting invoice data from PDF to Excel goes through the field-by-field decisions this page summarises — which of an invoice's several dates belongs in the Date column, how to handle tax and foreign currency, and why a value that is not printed on the document stays blank. For the month-end version of the job, including reconciling the finished sheet against supplier statements, consolidating multiple invoices into Excel picks up where a single batch leaves off.

What it costs and what is kept

There is no subscription — you buy credits and spend them when you convert something. The pricing page has the current packs and what a credit covers, and the FAQ covers retention, refunds and what happens to a file that fails.

Ready to turn a folder of invoices into a spreadsheet?

Name the columns you need, upload the PDFs, and check the preview before you download the workbook. No template to configure and no subscription to start.

Convert invoices to Excel

Invoice extraction questions

01

Do all the invoices have to come from the same supplier?

No. That is the case this is built for. Each PDF is read on its own against the columns you named, so twelve suppliers with twelve different layouts still produce one table with your headings. Nothing has to be sorted or grouped beforehand.

02

What happens to a field an invoice does not have?

The cell stays empty. A supplier who never quotes a PO number should produce a blank PO Number cell, not a plausible-looking one — a wrong value that reads as real is worse than a gap you can see and fill in yourself.

03

Can I use columns other than the ones listed here?

Yes. The nine fields on this page are the ones invoices usually share, not a template. Payment terms, a cost centre, a delivery reference, a supplier tax ID, a line-item description — if it is on the document, you can name it as a column.

04

Does it work on scanned invoices?

A scan with no text layer is a different job from a digital PDF, and the honest answer depends on the scan. If you have a batch of them, run one through first and look at the preview before committing the rest.

05

Do I have to review the result?

You should, and the preview exists so you can. These are financial documents, and figures that go into an accounting system or a tax return are worth checking against the source before you rely on them.

06

What happens to the invoices after the workbook is made?

They are held only as long as the conversion needs them and then deleted, and you can delete a conversion yourself at any time. The privacy page states the retention period and what is kept.