# Convert an EDIFACT INVOIC to Excel

Drop the .edi or .txt file exactly as your partner sent it. The INVOIC message is parsed into a table, and the segments that only mean something to your trading partner are shown as they are rather than guessed at.

Source: https://tally-stick.com/edifact-invoic-to-excel

## Where EDI stops being self-explanatory

EDIFACT is older than any of the XML formats and far more permissive: the same INVOIC message can be written a dozen legal ways, and the meaning of a qualifier is frequently agreed in a partner-specific implementation guideline rather than in the standard. This parser names what the standard names, and for the rest it shows you the segment, the element and the value. A wrong label on a finance document is worse than an unlabelled one.

## What you get out

- BGM document number and type, DTM dates, CUX currency
- NAD parties, with the qualifier they were sent under
- LIN line items with quantity, price and applicable tax
- MOA monetary amounts and TAX rows
- Every remaining segment, element by element, unlabelled and unaltered

## Questions

### Which directory versions work?

The common invoice directories, D.93A through D.01B and later. The segment structure of INVOIC has been stable for a long time, which is why the file is still in use.

### Why are some values shown as raw segments?

Because their meaning depends on your agreement with that partner. Anything unambiguous is labelled; anything that would be a guess is shown as the raw segment so you can read it against your own guideline.

### Can it read a file with several messages?

Yes. Each UNH to UNT message is read on its own within the interchange.

## Related

- [EDI 810 to Excel](https://tally-stick.com/x12-810-to-excel)
- [EDI 850 to Excel](https://tally-stick.com/x12-850-to-excel)
- [CII to Excel](https://tally-stick.com/cii-to-excel)
- [EDIFACT INVOIC to PDF](https://tally-stick.com/edifact-invoic-to-pdf)
- [EDI 856 to Excel](https://tally-stick.com/x12-856-to-excel)

## How it works

The invoice is read on your own device. No file is uploaded, no account is required, and the fair usage limit is the only cap. Exports are PDF, Excel, CSV and JSON.