# Convert an EDI 810 invoice to Excel

Drop the 810 as it came off the VAN or the SFTP drop. The invoice is laid out as a table, with the ISA and GS envelope kept in view so you know who sent what.

Source: https://tally-stick.com/x12-810-to-excel

## Why a European company ends up reading an 810

An exporter selling into the United States receives American documents back from American buyers, and X12 is what those look like. The 810 is the invoice of that family. It matters here because the same finance clerk who has to issue an XRechnung at home is the one opening an 810 from a US customer in the same week. Few tools on the market handle both worlds at once.

## What you get out

- ISA and GS envelope: sender, receiver, control numbers, date
- BIG invoice number and date, plus purchase order references
- N1 loop parties with their identification codes
- IT1 line items with quantity, unit price and product identifiers
- TDS, SAC and TXI amounts, and every other segment in raw form

## Questions

### My element labels look wrong.

Only the standard-defined ones are labelled. X12 element meaning is frequently agreed between trading partners, so anything partner-specific is shown as the raw segment rather than given a name that might be somebody else's.

### Does the file need to be split first?

No. Drop the whole interchange. Multiple ST to SE transactions inside one file are read individually.

### Which separators are supported?

They are read from the ISA segment itself, so unusual element, component and segment terminators are handled without a setting.

## Related

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

## 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.