Home › Invoices, banking and VAT › E-invoices to Excel: XRechnung, ZUGFeRD, Peppol, KSeF (batch)
E-invoices to Excel: XRechnung, ZUGFeRD, Peppol, KSeF (batch)
Many e-invoice files or one ZIP into ONE Excel list: number, dates, seller, VAT ID, net, VAT by rate, gross, IBAN, with a sum check per invoice.
- Press Select files and pick all the invoice files (.xml or ZUGFeRD .pdf), or one .zip with them.
- Choose Excel (all lines on a second sheet) or CSV (one row per invoice).
- Press Make the Excel list.
- Look at the Sum check column: “check” means the invoice does not add up. Then press Download.
💡 Simple guide · no technical skills needed
When do I need this?
You receive many e-invoices (XRechnung or ZUGFeRD from Germany, Peppol, KSeF from Poland) and need them in ONE list for booking, paying or your accountant, without opening each file.
Good to know
- A normal PDF invoice (a scan or a printout) has no data inside: only ZUGFeRD / Factur-X PDFs work here. For a normal PDF use PDF to Excel.
- Files that could not be read are listed on the sheet “Problems” with the reason.
Words explained
- Excel
- A spreadsheet program (tables with rows and columns). Google Sheets and LibreOffice open the same files.
- XRechnung
- The German official e-invoice format.
- ZUGFeRD
- A German e-invoice: a normal PDF with the invoice data hidden inside.
- Peppol
- A network for sending e-invoices between companies across Europe.
- e-invoice
- An invoice sent as a data file (not a picture or normal PDF), required more and more in the EU.
- ZIP
- A box that holds several files in one. Double-click (or tap) it to see the files inside.
- VAT
- Sales tax in Europe. Companies have a VAT number that starts with the country letters.
- IBAN
- Your bank account number in the international format, e.g. DE89 3704 0044 0532 0130 00.
Stuck? Press Help in the bottom corner and write your question in any language. You get an answer in seconds, or a real person answers you.
Questions
Which e-invoice formats can I put into one Excel list?
XRechnung (both CII and UBL syntax), ZUGFeRD and Factur-X PDFs with the XML inside, Peppol BIS invoices (UBL) and Polish KSeF invoices (FA(2) and FA(3) XML). You can mix them in one run, or upload one ZIP with up to 300 files. A normal PDF invoice without XML inside is listed under Problems; use PDF to Excel for it.
What does the sum check in the Excel list check?
For every invoice it adds the lines, the VAT per rate and net + VAT = gross and amount due. 'ok' means everything adds up, 'check' means something does not, and the next column says what. The sheet Totals adds net, VAT and gross per currency.
Is it free, and do I need an account?
10 invoices per run are free, without sign-up or card. Your files are deleted as soon as the list is ready, the result after 24 hours.
🌍 DeutschFrançaisEspañolPortuguêsItalianoNederlandsPolskiČeštinaSvenskaRomânăΕλληνικάTürkçe
More free tools
How does this tool compare? XRechnung / ZUGFeRD viewers: free limits and prices side by side.