Purchase Order to Excel

One row per purchase order, in the columns you name.

Upload a folder of PDF purchase orders and get one Excel workbook back with a row for each. The usual order columns are filled in already — change any of them before you convert.

Try the workflow

Build the spreadsheet you actually need.

Drop your PDFs in — the columns are filled in for you, and you change whatever you like. Files upload to private storage, and AI extracts only the fields you asked for into a reviewable table.

Interactive converter
Private AI extraction
01

Upload PDFs

Invoices, receipts, or repeated business documents.

Drop your PDF invoices or receipts hereorUp to 100 files · 20 MB each · 400 MB total
No PDFs selected0 KB
02

Choose Excel columns

Describe only the information you want in the workbook.

Quick add
  1. Column 1
  2. Column 2
  3. Column 3
  4. Column 4
  5. Column 5
  6. Column 6
  7. Column 7
  8. Column 8
03

Extract and review

Securely upload each PDF and extract only the columns you requested.

Anti-abuse verification
PDF rows
0
Excel columns
8
Estimated output
  1. 01

    Upload the orders

    Select a folder of PDF purchase orders. Each file is one record, so orders from different customers, or to different suppliers, can go in together.

  2. 02

    Adjust the columns

    The eight below are already filled in. Rename them to match the sheet you keep, remove the ones your orders do not print, or add anything else on the document — a project code, a cost centre, payment terms.

  3. 03

    Extract each order

    Every order is read against the same column set, so a stack of different buyer templates becomes one consistent table.

  4. 04

    Review before you download

    Each order 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 orders, three buyers, one order log.

Three purchase orders laid out three different ways — a manufacturer's printed form, a retailer's portal export and a one-page order from a small firm. Asking for the same eight columns turns them into three rows you can sort by delivery date. The middle order names no delivery date and the last one prints no separate delivery address, so those cells are blank rather than filled with a guess.

Example extraction result
Source PDFPO NumberOrder DateSupplierBuyerDelivery DateDelivery AddressCurrencyTotal
po-4471.pdfPO-44712026-08-03Northgate Fabrication LtdHalberd Manufacturing — Procurement2026-09-01Unit 7, Halberd Works, SheffieldGBP14,820.00
order-export-2208.pdf45002188442026-08-07Seri Jaya Trading Sdn BhdPasaraya Timur RetailLot 12, Jalan Perindustrian 4, Shah AlamMYR9,340.50
bright-lane-po.pdfBL-00922026-08-19Cedar Print Co.Bright Lane Studio2026-08-29EUR1,275.00

The columns this page starts you on

These eight are already in the converter above. They are a starting point rather than a template: rename them, change a data type, reorder them, remove the ones your orders do not carry, or add anything else the document prints.

  • PO NumberThe buyer's own reference, however that company formats it.
  • Order DateThe date the order was raised, normalised to one format across every buyer.
  • SupplierThe company the order is placed with, as printed rather than as you file them.
  • BuyerThe ordering company, department or named contact — useful whichever side you are on.
  • Delivery DateThe date the goods are required by, where the order states one.
  • Delivery AddressWhere the goods are to be sent, which is often not the buyer's billing address.
  • CurrencyRead from the order rather than assumed from the supplier's country.
  • TotalThe value the order commits to, on whatever basis the order states it.

Why a purchase order is not an invoice in reverse

An invoice is written after the work, to be paid: it carries an issue date, a due date, a tax breakdown and a payable total. A purchase order is written before anything is supplied, to commit to it — so it names where the goods go and when they are wanted, which no invoice does, and it frequently carries no due date and no tax figure at all, because nothing has been billed yet. That is why this page seeds a delivery date and a delivery address, and why it does not seed a tax column that most orders would leave blank. Invoice to Excel starts on the invoice set instead, and both keep a PO Number column so the two sheets share a key.

One row per order, not one row per part

Each document becomes a single row. An order for fifteen part numbers gives you the header — the reference, the supplier, the delivery date and the committed value — and not the fifteen lines beneath it. For an order log, a delivery schedule or a committed-spend figure that is the shape the spreadsheet wants. If you need the parts themselves, this is not the tool for that job today.

Both sides of the order are seeded

A purchase order has a buyer and a supplier, and either of them may be the one holding the folder of PDFs. A supplier filing incoming customer orders reads the buyer and the required-by date; a finance team filing its own outgoing orders reads the supplier and the value. Both columns are seeded so neither case has to add one, and the one you do not need comes out in a click.

Every row keeps its source file

The preview shows which PDF each row came from, which is what makes checking possible: an order value 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 handling around a batch

Some of the work before an extraction does not need an account at all. Split PDF separates a printed run of orders back into one file each, Merge PDF does the reverse, and Extract Text shows you whether a scanned order has a text layer at all. All of them run in your browser; the rest are on the free tools page.

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.

Purchase order extraction questions

01

Are these eight columns fixed?

No. They are filled in because they are what purchase orders usually share, and every one of them can be renamed, retyped, reordered or removed before you convert. If your sheet wants payment terms, a project or cost-centre code, a requisition number, an incoterm or a contact email, add it and it applies to the whole batch.

02

Can I get the ordered line items?

Not today. Each purchase order becomes one row, so an order for fifteen part numbers gives you the header — the PO number, the supplier, the delivery date and the order value — and not fifteen rows of parts. If what you are building is an order log, a delivery schedule or a committed-spend figure, that is one row per order, which is what this produces. If you need the parts themselves, this is not the tool yet.

03

Do the orders have to use the same template?

No. That is the case this is built for. Every buyer lays a purchase order out differently and each PDF is read on its own against the columns you named, so a folder from twenty customers still produces one table with your headings. Nothing has to be sorted beforehand.

04

What happens to a field an order does not print?

The cell stays empty. Plenty of orders give no delivery date, or send goods to the same address as the invoice and print it once. A blank you can see is better than a plausible-looking value that was inferred, and the gaps are where you look first when you check the sheet.

05

Does it work if I am the supplier receiving the orders?

Yes, and both directions are seeded for exactly that reason. A supplier filing incoming customer orders cares about the buyer and the delivery date; a finance team filing its own outgoing orders cares about the supplier and the committed value. Both columns are there and either can be removed in one click.

06

Can I match the orders against the invoices later?

That is up to your spreadsheet, but the PO number is the column that makes it possible, which is why it is first. Invoice to Excel seeds a PO Number column for the same reason, so the two workbooks share a key you can look up on.

07

What happens to the orders 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.