EDI Order Files to CSV
Turn X12 850 purchase orders and EDIFACT ORDERS files into a line-item spreadsheet on your own computer.
For people who receive business order files and need to inspect the items, quantities and supplied prices in Excel or another spreadsheet. Download the tool, start it with Python 3.10 or later, then select your files in its local browser interface. A command-line option is included.
Python is required. This download is intended for people comfortable installing Python and running a command. Your computer needs a desktop browser; the conversion does not need an internet connection. Tested so far on Linux with Python 3.10 and 3.12 in Chromium only; Windows and macOS are not yet tested, so try the free preview first.
Try your file first
X12 850 files require ISA envelopes; EDIFACT ORDERS files require UNB envelopes. The free preview uses the same converter and exports up to five line-item rows. Check the item identifiers, quantities and prices against your original order before buying. The preview checks the whole input but its saved rows cover only the sample. Some order formats and partner conventions fall outside its supported extraction rules.
Download the free five-row preview
What you get
- CSV with one row per accepted order line: source filename, standard, order number, raw order date, currency, line number, item identifier and qualifier, other identifiers, description, quantity and its qualifier, unit, supplied price and its qualifier, price basis quantity and price basis unit where supplied.
- JSON containing selected mapped order fields and diagnostic details about rejected messages. It is not a lossless copy of every source segment; keep your original files.
- A local browser interface and a command-line converter, with no third-party Python packages to install.
- Repeat conversions on your computer, with up to 20 files per batch and a 5 MiB limit for each file.
Files stay on your computer during conversion. The tool does not upload order files to Madrasco.
Read the output before using it
The CSV is for inspecting order data. It does not map fields to your ERP, send orders, or certify a trading partner's requirements. Check the output before importing it into another system.
The converter rejects messages with detected structural errors, missing order numbers or missing ordered quantities, and ambiguous supported price fields. An exported message can still have warnings, and passing its checks does not establish complete EDI compliance. Review the diagnostic report.
Dates retain their source representation. Product identifiers retain their qualifiers; absent line numbers and item identifiers stay blank. A missing quantity unit stays blank. EDIFACT AAA (net) and AAB (gross) prices retain their qualifiers, and price basis quantities and units have separate columns. Check these before treating a supplied price as a price per ordered unit. The tool does not calculate discounts, tax or line totals. It does not convert invoices or acknowledgements into order rows. The CSV contains selected order fields, not the complete message. When opening CSV in a spreadsheet, import identifier columns as text to retain leading zeroes.
Support
Questions or a file the preview cannot convert? Contact [email protected] without attaching business order files. Tell us the standard and the diagnostic code first.
Madrasco builds and maintains this product with AI agents. Support replies may be AI-assisted; you can ask to reach the human owner.
Refunds · Terms · Licence: use within your own business; no redistribution.