Extract ORC Purchase Order to TSV

Automatically parse buyer details, shipping info, and line items from ORC purchase orders into structured TSV data.

Drop your Apache ORC file here (or click to browse).
(100 MB or less file)
0%
Uploading...
Loading...
Sign-up to upload larger files
What you get

Transform Purchase Orders into Structured Data

Extract complete purchase order details in a single step. Parse document headers and line items into clean structured outputs with zero manual entry.

VENDOR 1 PURCHASE ORDER PO NO. PO-4471 DATE 2026-09-02 TERMS NET 30 2 SHIP TO DELIVER BY 2026-09-16 3 4 AUTHORIZED BY ORDER TOTAL 2,020.77 5

1Buyer & supplier

Who placed the order and who it went to. Repeated on every row so you can filter by either one.

buyer_namebuyer_addresssupplier_namesupplier_id

2Order details

The PO number is the key that invoices and packing slips are matched on.

po_numberorder_daterevisionpayment_termscurrencybuyer_contact

3Ship-to & delivery

Where the goods go and when they're due, so you can plan receiving.

ship_todeliver_byship_viaincoterms

4Line items

One row per ordered line, in the order printed on the PO, including across page breaks.

line_noitem_codedescriptionquantityuomunit_priceline_total

5Totals & approval

Kept out of the line-item rows, so summing the lines doesn't count anything twice.

subtotalfreighttax_amountorder_totalapproved_by
1

Upload

A ORC, a scan, or a photo of the purchase order.

2

Check the columns

Rename, drop, or reorder columns to match your import.

3

Export

Excel, CSV, JSON, XML, SQL, and more.

The output

Standardize and aggregate orders before export

Rearrange columns, rename fields to match your workflow, and combine purchase orders from different suppliers into one clean, ready-to-use file.

TSV open-orders-2026-09.tsv 148 rows · 23 purchase orders
PO Number Order Date Supplier Deliver By Item Code Description Qty UoM Unit Price Line Total
PO-44712026-09-02Kessler Commercial Kitchens2026-09-16 KCK-SP-2040Stock pot, 40 qt, stainless6EA89.00534.00
PO-44712026-09-02Kessler Commercial Kitchens2026-09-16 KCK-HP-1218Hotel pan, full size, 4 in24EA14.50348.00
PO-44712026-09-02Kessler Commercial Kitchens2026-09-16 KCK-SB-0600Sheet pan rack, 20 tier2EA212.00424.00
PO-44722026-09-03Linden Linen Supply2026-09-20 LLS-TW-3060Bath towel, 30×60, white200EA6.401,280.00
PO-44722026-09-03Linden Linen Supply2026-09-20 LLS-SH-Q400Queen sheet set, 400 TC60SET38.002,280.00
Automate it

Extract purchase orders from your own code

The API uses the same extraction engine. Send each PO as it arrives by email, lands in storage, or comes in through a webhook, and get rows back.

Explore the API
extract-purchase-order-data.sh
curl -X POST "https://dataconverter.io/api/v1/convert/orc-to-tsv" \  -H "Authorization: Bearer YOUR_TOKEN_HERE" \  -F "file=@po-4471.orc" \  --output po-4471.tsv✓ 200 OK · po-4471.tsv · 5 line items
Who it's for

Built for anyone handling purchase orders

Whether you manage purchasing or process incoming orders, eliminate manual data entry across every step of the transaction.

Procurement & purchasing

Keep a live list of open orders, what's due and from whom, without a purchasing suite.

Accounts payable

Put PO lines next to the invoice lines and catch quantity or price differences before you pay.

Sales order desk

Customer POs arrive in dozens of layouts. Turn each one into rows your order entry can import.

Warehouse & receiving

Know what's arriving this week, line by line, so you can check deliveries at the dock.

Finance & spend analysis

Total committed spend by supplier, category, or month before any invoice arrives.

Developers

Export to JSON or call the conversion API to feed POs into your ERP or order system.

Set up once, reuse for every PO

Save your column names and order as a template. The next batch of purchase orders comes out in the same shape, with no setup.

Frequently asked questions

Does it work with POs from any purchasing system?

Yes. The purchase order is read as a document, not matched against fixed templates, so a layout it has never seen still comes out as rows.

What happens with multi-page purchase orders?

Line items maintain their natural order across page breaks. Header details are appended to every row so each line item carries its full document context.

Which formats can I export to?

22+ output formats, including Excel (XLSX), CSV, JSON, XML, and SQL. Pick your target type on the upload page before you convert.