Skip to main content

How to import XML e-invoices into DataSnipper for Excel

How DataSnipper for Excel converts supported XML e-invoices into readable PDFs when you import them

Overview

You can import XML e-invoices into DataSnipper for Excel the same way you import PDFs. DataSnipper converts each supported e-invoice into a readable PDF, with the original XML stored inside it. No setup or license is required.

How to import an XML e-invoice

  1. Click the DATASNIPPER tab in the Excel ribbon.

  2. Click Import, then select Documents or Folder.

  3. Select the XML e-invoice(s) you want to import.

The converted PDF shows every value in the invoice, grouped into sections such as totals, invoice lines, seller, buyer and VAT breakdown. You can snip, comment on, search and run AI Extractions on it like any other document. Snips, comments and markups never change the original XML.

When you export with the PDF source file option, DataSnipper saves the PDF and the original XML side by side.

Supported formats

  • Converted: EN 16931 invoices and credit notes in UBL and CII, including Belgian Peppol and XRechnung CII. Older formats such as Peppol BIS 2 and e-FFF 3.0 convert on a best-effort basis, so a few values may appear without their business term.

  • Not converted: national formats outside EN 16931, such as FatturaPA and KSeF, as well as ZIP files, signed .p7m files and XML files with several invoices. These fail on import with an error message.

  • Other XML files import as plain text, as before. Factur-X and ZUGFeRD files import as normal PDFs.

Values appear exactly as written in the XML, so codes such as 380 or S show without a description. Files attached inside the XML stay in the embedded XML and do not show in the PDF.

Did this answer your question?