You do not need macros or manual retyping to get a PDF purchase order into Excel.
PDF, JPG, PNG, BMP, HEIC, TIFF
Submit your purchase orders
Drop documents here, or choose a file
Up to 50 files per batch
Uploading...
You do not need macros or manual retyping to get a PDF purchase order into Excel. Upload the file, let the AI read every field, and download a clean spreadsheet in seconds. Here is exactly how it works.
A purchase order looks like a table, so it seems like it should paste straight into a spreadsheet. In practice the header fields, the line-item grid, and the totals are laid out for printing, not for analysis, and every supplier lays them out differently.
Selecting text in a PDF and pasting it into Excel usually drops everything into one column, or splits descriptions across several rows. Rebuilding the grid by hand takes longer than typing the order.
The PO number, order date, supplier, ship-to, and payment terms sit in boxes around the page, not in the table. A table extractor ignores them, so the spreadsheet has line items with no idea which order they belong to.
A scanned or photographed purchase order is an image. Excel and most PDF converters cannot read it at all without a separate OCR step, which adds its own errors.
Power Query steps and converter templates are built around one layout. A new supplier, or a small change to an existing template, and the rules have to be rebuilt.
PurchaseOrders reads the document as a purchase order rather than as a picture of a table. It finds the header fields wherever they sit on the page, reads the line-item grid across page breaks, and writes both into a spreadsheet with the same columns every time.
PO number, order date, delivery date, supplier, ship-to, bill-to, currency, and payment terms are captured alongside the line items, so every row in the export can be traced back to the order it came from.
SKU, description, quantity, unit of measure where printed, unit price, and line amount each land in their own column, including tables that continue over several pages.
Image-based PDFs, scans, and phone photos go through the same reader as native PDFs, so there is no separate OCR step to run first.
Download an Excel workbook for review, or a CSV for importing into an ERP, accounting system, or database. JSON is also available for developers.
The direct route is the purchase order PDF to Excel converter, which returns one clean row per line item; if your ledger prefers a flat file, the CSV export works the same way. Accurate purchase order line item extraction is what fills the table correctly across any supplier format, including scans handled by image to Excel extraction. Have a whole folder to convert? Batch process multiple purchase orders in one upload.
Not sure which fields to keep? Our reference on purchase order fields explains what each box on a PO means, and if the spreadsheet is going to become your running record of open orders, see how to set up a purchase order log.
Each method ends with a spreadsheet. They differ in how much cleanup the spreadsheet needs and how they cope with new suppliers and scans.
| AI extraction | Generic PDF converter | Excel Get Data from PDF | Manual typing | |
|---|---|---|---|---|
| Header fields | Captured with the lines | Often lost or misplaced | Only if inside a table | Typed by hand |
| Line-item table | One clean row per line | Visual copy, columns shift | Works on tidy tables | Row by row |
| Multi-page tables | Joined across pages | Split per page | One query per page table | More pages, more typing |
| Scans and photos | Read directly | Usually empty cells | Not supported | Retyped from the image |
| New supplier layout | Works on first upload | Same cleanup every time | Query steps rebuilt | Read from scratch |
| Batch of orders | Many files in one upload | One file at a time | One file at a time | One order at a time |
Excel Get Data from PDF is available in Microsoft 365 versions of Excel for Windows. It reads tables that exist as text in the PDF and does not read scanned images.
The same three steps work for a single order or a folder of them.
Drag in a PDF, scan, or photo of the PO. Native PDFs, image PDFs, JPG, PNG, and multi-page orders all go through the same upload, with no template to choose.
Tip: Upload the most complicated order you have first. If that one comes out clean, the simpler ones will too.
The AI reads the PO number, supplier, dates, ship-to, terms, and the line-item table with SKU, description, quantity, unit price, and line amount. Check the fields on screen against the document, paying most attention to quantities and unit prices.
Export an XLSX with one row per line item and consistent column headers. Open it in Excel or Google Sheets, filter and sort it, or add it to a running log of orders.
Tip: Choose CSV instead if the next step is an import into an ERP or accounting system.
Upload the PDF to an extraction tool that reads purchase orders, review the fields it finds, and download the result as an XLSX file. PurchaseOrders returns the header fields and one row per line item, so the spreadsheet is ready to sort, filter, or import without rebuilding the columns.
Excel for Microsoft 365 on Windows can import tables from a text-based PDF through Get Data. It works on tidy tables, but it does not read scanned documents, and header fields outside the table such as the PO number or supplier are usually missed. Each new layout also needs its own query steps.
At minimum: PO number, order date, supplier, SKU, description, quantity, unit of measure, unit price, and line amount. Add delivery date, ship-to, currency, and payment terms if you track deliveries or pay against the order. Keeping the PO number on every line row is what makes filtering and matching work.
Yes. Scans and phone photos are read with built-in OCR and AI vision, so there is no separate OCR step. Results depend on how legible the image is, so check quantities and prices on screen before you download, especially on faxed or low-resolution copies.
The line-item table is read across page breaks and returned as one continuous set of rows rather than one table per page. Check that the line amounts add up to the order subtotal before you use the file, which is a quick way to confirm nothing was missed.
Yes. You can upload a purchase order and see the extracted result before paying, and a free account includes a page allowance for testing on your own documents. Paid plans start at $49 a month.
Choose your plan