# Convert FatturaPA to Excel

Drop the FatturaPA XML as the Sistema di Interscambio delivered it. The Italian element names are mapped onto the same columns as every other format here.

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

## The Italian file and its signature

Italy has run mandatory e-invoicing through the SdI longer than anyone else in the EU, which means a lot of these files sit in archives waiting to be read back. One practical catch: invoices are often delivered as .xml.p7m, a CAdES container wrapping the XML. Unwrap it first and the XML inside opens here. The signed container itself is not read, and pretending otherwise would just fail later.

## What you get out

- DatiGeneraliDocumento: number, TipoDocumento, date and currency
- CedentePrestatore and CessionarioCommittente with partita IVA and codice fiscale
- DettaglioLinee line by line, with quantity, unit price and aliquota IVA
- DatiRiepilogo per VAT rate, including natura where the rate is zero
- Payment data: IBAN, terms and the ImportoTotaleDocumento

## Questions

### My file ends in .p7m and will not open.

That is the signed container, not the invoice. Strip the CAdES signature with any tool that handles p7m and drop the XML that comes out.

### Which FatturaPA versions are read?

The 1.2 family, which is what the SdI has been carrying for years, including the ordinary and simplified layouts.

### Is natura kept when the VAT rate is zero?

Yes. A zero rate with no reason is an invoice you cannot defend, so the exemption code comes along with the tax rows.

## Related

- [Facturae to Excel](https://tally-stick.com/facturae-to-excel)
- [KSeF invoice to Excel](https://tally-stick.com/ksef-to-excel)
- [Peppol BIS to Excel](https://tally-stick.com/peppol-bis-to-excel)
- [UBL to JSON](https://tally-stick.com/ubl-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.