# Convert a UBL invoice to Excel

Drop a UBL 2.1 Invoice or CreditNote, whatever the sending country. The document is mapped onto the same columns as every other format here, so a UBL file and a CII file end up looking alike.

Source: https://tally-stick.com/ubl-invoice-to-excel

## One syntax under many national names

UBL 2.1 is the OASIS document standard that XRechnung, Peppol BIS Billing 3.0 and several national formats all sit on top of. That is why an invoice can be called four things and still be the same XML underneath. Credit notes are a separate document type in UBL, not an invoice with a minus sign, and they are read here as such.

## What you get out

- Invoice or CreditNote, detected and labelled, not assumed
- Header: number, type code, issue and due date, currency, references
- AccountingSupplierParty and AccountingCustomerParty in full
- InvoiceLine detail with quantity, unit code, price and VAT category
- TaxSubtotal per rate and the LegalMonetaryTotal block

## Questions

### Does the namespace prefix matter?

No. The parser matches on local element names, so cbc, cac, ubl or no prefix at all are all read the same way.

### Which UBL document types are supported?

Invoice and CreditNote, plus the SelfBilledInvoice and DebitNote variants. Orders and despatch advices are not invoices and are not read.

### My file is Peppol BIS. Is that different?

Peppol BIS Billing 3.0 is UBL with extra rules, so it reads here without anything special. There is a Peppol page if that is the wording you were looking for.

## Related

- [UBL to JSON](https://tally-stick.com/ubl-to-json)
- [Peppol BIS to Excel](https://tally-stick.com/peppol-bis-to-excel)
- [CII to Excel](https://tally-stick.com/cii-to-excel)
- [Facturae to Excel](https://tally-stick.com/facturae-to-excel)
- [EN 16931 validator](https://tally-stick.com/en16931-validator)
- [UBL invoice to PDF](https://tally-stick.com/ubl-invoice-to-pdf)
- [PDF invoice to JSON](https://tally-stick.com/pdf-to-json)

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