Skip to content
OrderSync LogoOrderSync

Excel to EDI 850 Converter

Load an Excel sheet of order lines, check the column matches, and download a valid X12 850 purchase order.

Runs in your browser. Nothing you enter or paste is sent to OrderSync.

Try a sample:

1. Load your order lines

One row per line item, with a header row. Rows that share a PO number become one purchase order.

Or paste CSV text

Why Spreadsheets End Up as EDI

Plenty of buyers still plan orders in Excel, and plenty of suppliers still receive them that way, then retype them into an EDI portal or ERP. When a trading partner asks for an EDI 850 instead, the spreadsheet already holds everything the 850 needs: a PO number, the items, quantities, prices and where to ship. The converter maps those columns to X12 segments and builds the envelope, so the file passes the same structural checks a partner's translator runs.

Getting the Spreadsheet Right

  • One row per line item; repeat the PO number on every line of the same order.
  • Put UPCs in their own column as numbers or text with all 12 digits. Excel drops leading zeros from numbers, which breaks the check digit; format the column as text.
  • Use two-letter X12 units: EA each, CA case, PK pack, BX box.
  • Keep prices as plain numbers. Currency symbols and thousands separators are removed.

Then check the result in the EDI viewer and validator, with a retailer selected under Validate for. For the meaning of each segment, see the 850 purchase order guide. Working with CSV exports instead? Use CSV to EDI; it is the same converter. If your system exports orders as XML, see how the fields line up in XML to EDI. To answer a PO you received, reply to a PO with an 855, 856 or 810.

From One File to Every Order

If spreadsheets are how orders reach you every week, OrderSync can read them as they arrive by email, check them against your catalog and pricing, and create clean orders for your team to approve, alongside your EDI, PDF and portal orders. See multi-format order processing or the free order form template for buyers who still send spreadsheets.

Frequently Asked Questions

Can I turn an Excel file into an EDI 850?

Yes. Choose an .xlsx file with one order line per row and a header row. The converter reads the first worksheet, matches your column headers to 850 fields, and builds a valid X12 850 you can download, copy, or open in the EDI viewer.

Is there an Excel template?

Yes. Download the Excel template above the converter. It has every column the converter understands and three sample lines across two purchase orders, so you can see how rows group into POs.

Do I need to use the template's column names?

No. Headers such as Order #, Item Code, Qty Ordered, Unit Cost or Store Number are recognised, and you can change any match by hand. Each row needs a quantity and an item number or UPC. If the sheet has no PO number column, type one PO number to use for every row. A title row above the headers is left out, and you can pick the header row yourself.

Does it read .xls files or several sheets?

It reads the first worksheet of an .xlsx file (Excel 2007 and later) and CSV files. Save older .xls workbooks as .xlsx first. Dates typed as Excel dates are converted to CCYYMMDD.

Is my spreadsheet uploaded?

No. The workbook is unzipped and converted in your browser. Nothing is sent to OrderSync.

Can it create 810 invoices or 856 ship notices?

This page builds 850 purchase orders. To reply to a purchase order you received, paste it into the EDI Response Builder (ordersync.io/tools/edi-response-builder). It drafts the 855 acknowledgment, the 856 ship notice with SSCC carton numbers, and the 810 invoice.

Related Free Tools

CSV to EDI 850 Converter

Turn a CSV of order lines into a valid X12 850 purchase order. Map your columns, check every row, download the EDI.

EDI Viewer and Validator

Open an X12 or EDIFACT file, see every segment and element named, find errors by segment, check retailer rules and generate a 997.

EDI Translator

Translate an X12, EDIFACT or TRADACOMS file into plain English: who sent it, what was ordered, and when it is due.

Order Form Template

Build a wholesale order form with your SKUs, case packs and prices. Download Excel, CSV or PDF.