# Convert XRechnung XML to Excel

Drop the XRechnung XML your customer or supplier sent. Both permitted syntaxes are read, the German-specific fields come along, and what you get back is a spreadsheet instead of a wall of tags.

Source: https://tally-stick.com/xrechnung-to-excel

## XRechnung is a rule set, not a file

XRechnung is Germany's national reading of EN 16931: a rule set, not a file format. The same invoice can arrive as UBL 2.1 or as UN/CEFACT CII, both valid and looking nothing alike. Public authorities have required it since 2020, and the B2B mandate phases in from 2027. This page reads both syntaxes onto the same columns.

## What you get out

- Leitweg-ID and buyer reference, the routing fields German authorities insist on
- Invoice number, type code, issue date, due date and currency
- Seller and buyer name, address, VAT number and tax registration
- Every line: number, description, quantity, unit, unit price, VAT rate, net amount
- VAT per rate and category, taxable base, and the totals block down to amount due
- IBAN, BIC, payment terms and payment means code

## Questions

### Is my file UBL or CII?

You do not need to know. Both are XRechnung, both are read here, and both come out with the same column names. If you are curious, the format pill above the results tells you which one it was after you drop the file.

### Does it read XRechnung 3.0?

Yes, and 2.x as well. The differences between versions sit in validation rules rather than in where the data lives, so the extraction is the same.

### The Leitweg-ID is missing from my export.

Then it was not in the file. It is mandatory for public-sector invoices but not for B2B ones, so a supplier invoice between two companies often has none. The column stays empty rather than being invented.

## Related

- [XRechnung to CSV](https://tally-stick.com/xrechnung-to-csv)
- [XRechnung to PDF](https://tally-stick.com/xrechnung-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.