Spreadsheet template
E-invoice from Excel
Do you write your invoices in Excel? Download the spreadsheet template, enter your invoice data and upload the file. The data opens in the invoice form. There you check it, validate it and create the e-invoice (ZUGFeRD or XRechnung).
Download template (.xlsx)How it works
- Download the template. No account is needed.
- Fill in the sheets "Invoice" and "Line items" and save the file as Excel workbook (.xlsx).
- Upload the file. The data opens as a draft in the invoice form.
- Check the draft, validate it and create the e-invoice. To download the e-invoice you need a free account.
The file itself is not stored; only the values transferred into the draft are saved.
Upload the filled-in template
What the template is not
- The spreadsheet is not an e-invoice – and neither is a PDF printed from it. The e-invoice is created in the form.
- There is no Excel add-in and no plugin.
- Word documents are not supported.
- One file contains one invoice with at most 500 line items.
Questions about the spreadsheet template
Is an invoice written in Excel an e-invoice?
No. An e-invoice is a structured file in the XRechnung or ZUGFeRD format that can be processed automatically. An Excel or Word file, or a PDF printed from it, is not an e-invoice.
Is there an Excel add-in or a Word template?
No. There is no add-in and no plugin. The spreadsheet template only carries your invoice data into the invoice form. Word documents are not supported; fill in the form directly instead.
What happens to formulas and macros?
Formulas are not calculated and macros are not run. Only the values stored in the cells are read. Files with macros (.xlsm) are not accepted. Amounts and totals are calculated in the form.
Can I put several invoices in one spreadsheet?
No. One file contains one invoice with at most 500 line items.
What happens if a value in the spreadsheet is not correct?
No draft is created. You see a list of the affected cells with a note for each, correct the file and upload it again.