Excel → EDIFACT DESADV
Convert Excel to EDIFACT DESADV without a brittle one-off script
Turn the first non-empty worksheet with a stable heading row into a confirmed canonical shipment, then render and validate EDIFACT DESADV per partner route.
Direct answer
Direct answer
The conversion builds a UNB/UNH envelope and DESADV message, placing dispatch identity and dates in BGM/DTM, parties in NAD, shipment and package structure in CPS/PAC, references in RFF, item identity in LIN and quantity in QTY. The exact directory version and partner qualifiers must come from the receiving partner guide. The Excel side is mapped once from a representative file and reused only when its exact heading signature matches.
Why mapping needs a controlled workflow
A direct Excel-to-EDIFACT DESADV script usually mixes source parsing, partner identifiers, hierarchy rules and transport in one fragile job. Shipment Sentry separates them: source inspection, human-confirmed canonical mapping, versioned partner route, deterministic renderer and final validation. That separation makes a changed source fail visibly instead of corrupting a production ASN.
What the control should check
- 01Parse Excel as the first non-empty worksheet with a stable heading row.
- 02Confirm purchase order, shipment reference, item, quantity and container fields.
- 03Pin the UN/EDIFACT directory and DESADV association version.
- 04Configure sender, receiver, party and item qualifiers from the partner guide.
- 05Preserve package-to-item relationships in CPS and PAC.
- 06Escape release characters before segment rendering.
- 07Recount segments and validate UNH/UNT plus UNB/UNZ controls.
Working example
Sheet: Dispatch
PO | Shipment | SKU | Qty | UOM | SSCC | Ship date
PO-77821 | ASN-1042 | SKU-104 | 12 | EA | 000123456789012343 | 2026-07-19
BECOMES
UNH+1+DESADV:D:01B:UN'BGM+351+ASN-1042+9'DTM+11:20260719:102'RFF+ON:PO-77821'LIN+1++SKU-104:SA'QTY+12:12:EA'UNT+6+1'The output is abbreviated to show the transformation boundary. Production rendering generates the complete envelope and validates its counts and controls.
Failure modes worth catching
- A formula is exported instead of its displayed value.
- Merged cells hide a shipment reference from later line rows.
- A partner identifier from one route leaks into another partner output.
- The output passes envelope checks but violates the current account implementation guide.
Put it into the dispatch workflow
- 1Create and test the EDIFACT DESADV partner route.
- 2Analyze a representative Excel source and confirm the mapping.
- 3Submit up to 1,000 files using the same partner code over SFTP, email or API.
- 4Generate EDIFACT DESADV separately for every admitted file.
- 5Download the output or inspect the per-file quarantine and validation result.
Questions
Implementation answers
Does the converter guess missing values?
No. Critical shipment fields require confirmation, and route-specific identifiers must be configured. Missing required output data fails closed.
Can I send many source files at once?
Yes. SFTP, authenticated email and the partner-batch API accept up to 1,000 routed files within channel size and plan limits.
Is partner compliance guaranteed?
No. The implemented renderer and public base checks reduce deterministic errors; the receiving account implementation guide and agreement remain controlling.
Sources and limits
Reviewed 2026-07-19. Public references cannot establish every partner-specific rule. Current implementation guides and agreements remain controlling.
Keep investigating