Credentials
Stored encrypted and decrypted only while a job is running. Use an IAM user scoped to the bucket below.
Temporary credentials
Leave empty for a long-lived IAM user key.
Location
Where browsing starts. Leave it empty to start at the top of the bucket. Saved work addresses objects by their full path, so this is a starting point rather than a restriction.
Secure Google OAuth authentication. Your password never reaches DataConverter. Only an encrypted refresh token is stored, and you can revoke access at any time from your Google Account settings.
Opens Google's secure account selection screen
Explicit privacy guarantees
- Load selected spreadsheets only: Read access is granted only to the spreadsheets you explicitly select.
- Every tab included: A picked spreadsheet loads with all of its tabs, and you choose which one to use.
- Zero extra access: Unselected spreadsheets and the rest of your Drive remain completely unreadable.
Waiting for Google… Finish signing in using the Google window that just opened.
Closed the Google window?
Google account
Reconnect if access was revoked or you need a different account.
Secure Google OAuth authentication. Your password never reaches DataConverter. Only an encrypted refresh token is stored, and you can revoke access at any time from your Google Account settings.
Opens Google's secure account selection screen
Explicit privacy guarantees
- Import selected files only: Read access is granted only to files you explicitly select.
- Direct output exports: Save converted files directly into your designated Drive destination.
- Zero extra access: Unselected files and non-target folders remain completely unreadable.
Waiting for Google… Finish signing in using the Google window that just opened.
Closed the Google window?
Google account
Reconnect if access was revoked or you need a different account.
Extract PIES Purchase Order to Fixed Width
Automatically parse buyer details, shipping info, and line items from PIES purchase orders into structured Fixed Width data.
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.
1Buyer & supplier
Who placed the order and who it went to. Repeated on every row so you can filter by either one.
2Order details
The PO number is the key that invoices and packing slips are matched on.
3Ship-to & delivery
Where the goods go and when they're due, so you can plan receiving.
4Line items
One row per ordered line, in the order printed on the PO, including across page breaks.
5Totals & approval
Kept out of the line-item rows, so summing the lines doesn't count anything twice.
Upload
A PIES, a scan, or a photo of the purchase order.
Check the columns
Rename, drop, or reorder columns to match your import.
Export
Excel, CSV, JSON, XML, SQL, and more.
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.
| PO Number | Order Date | Supplier | Deliver By | Item Code | Description | Qty | UoM | Unit Price | Line Total |
|---|---|---|---|---|---|---|---|---|---|
| PO-4471 | 2026-09-02 | Kessler Commercial Kitchens | 2026-09-16 | KCK-SP-2040 | Stock pot, 40 qt, stainless | 6 | EA | 89.00 | 534.00 |
| PO-4471 | 2026-09-02 | Kessler Commercial Kitchens | 2026-09-16 | KCK-HP-1218 | Hotel pan, full size, 4 in | 24 | EA | 14.50 | 348.00 |
| PO-4471 | 2026-09-02 | Kessler Commercial Kitchens | 2026-09-16 | KCK-SB-0600 | Sheet pan rack, 20 tier | 2 | EA | 212.00 | 424.00 |
| PO-4472 | 2026-09-03 | Linden Linen Supply | 2026-09-20 | LLS-TW-3060 | Bath towel, 30×60, white | 200 | EA | 6.40 | 1,280.00 |
| PO-4472 | 2026-09-03 | Linden Linen Supply | 2026-09-20 | LLS-SH-Q400 | Queen sheet set, 400 TC | 60 | SET | 38.00 | 2,280.00 |
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 APIcurl -X POST "https://dataconverter.io/api/v1/convert/pies-to-fixed-width" \ -H "Authorization: Bearer YOUR_TOKEN_HERE" \ -F "file=@po-4471.xml" \ --output po-4471.txt✓ 200 OK · po-4471.txt · 5 line items
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.