KSeF XML to Excel and CSV converter
Choose invoice files
E-invoice XML files or ZIP archives without a password. You can keep adding files – they go into the same summary.
What you get in the Excel file
| Sheet | One row is | Main columns |
|---|---|---|
| Invoices | an invoice | KSeF number, type, invoice number and date, sale date, NIP (tax ID) and name of seller and buyer, currency, net, VAT, gross, VAT in PLN, net and VAT separately for each rate (23/22%, 8/7%, 5%, 0% domestic, intra-EU supply, export, exempt, not taxable, reverse charge, margin scheme), payment method and due date, bank account, corrected invoice data |
| Lines | an invoice line | invoice number, line no., name, index, GTIN, PKWiU, CN, GTU, unit, quantity, net and gross unit price, discount, net and gross value, VAT rate, procedure, state-before-correction flag |
Amounts in Excel are numbers, so you can sum, filter or use them in a pivot table straight away. The CSV files use a comma as the separator and a dot as the decimal mark. Column headers, sheet names and values such as invoice type and payment method are in English; names, descriptions and other text come from the invoice as issued (usually Polish).
Which files it supports
- E-invoice XML in the FA(3) structure, the one in which invoices go to KSeF 2.0, and in the older FA(2) structure.
- ZIP archives without a password containing XML files, also in subfolders.
- Files of other kinds (e.g. UPO, JPK files) are skipped and shown in the list of warnings, as are damaged XML files and repeated invoices.
The KSeF number is not part of the invoice XML file: KSeF assigns it only when the invoice is accepted.
The converter reads it from the file name if it contains it (e.g. 5260250274-20261001-0100A1B2C3D4-36.xml).
If the name does not contain it, the column stays empty, so invoices downloaded from KSeF are best saved under their KSeF number.
Corrections, advance invoices and currencies
- Corrective invoice: totals in the FA(3) schema are the difference amounts, so they may be negative. In the Lines sheet, rows describing the state before the correction have "yes" in the "State before correction" column.
- Advance invoice: the net and VAT amounts are the value of the advance and the tax on it, as on the invoice.
- Foreign currency: net, VAT and gross are in the invoice currency. The "VAT in PLN" column shows the tax converted into zloty (fields P_14_xW), if the issuer provided it.
What it is useful for
A list of invoices split by VAT rate makes it easier to reconcile purchases and sales with the VAT records, check costs in a spreadsheet or prepare data for an accounting firm. Lines with indexes and GTIN codes help compare prices between suppliers. If the invoices also have to go into the books, see the article JPK_KR_PD and KSeF on the KSeF number in the records.
Frequently asked questions
Are the invoice files sent to a server?
No. The converter runs entirely in the browser: the XML and ZIP files are read on your computer, and the Excel workbook and CSV files are created locally. When you close the tab, the data is gone.
Which XML files does the converter support?
E-invoices in the FA(3) structure used in KSeF 2.0, and in the older FA(2) structure. You can choose many XML files at once or a ZIP archive without a password containing XML files.
Where does the converter take the KSeF number from?
From the file name. The KSeF number is not part of the invoice XML file, because KSeF assigns it only when the invoice is accepted. If the file name does not contain the number, the "KSeF number" column stays empty.
How does the converter show corrective invoices?
The amounts in the Invoices sheet come from the invoice totals, and in a correction these are differences, so they may be negative. In the Lines sheet, rows describing the state before the correction have "yes" in the "State before correction" column.
Filing JPK_KR_PD in Poland?
Before you submit the file, we check it with over 80 substantive checks that the Ministry of Finance gateway does not run. Report in English.
Order JPK_KR_PD validationNeed such summaries regularly, for many invoices or with ready-made analyses, e.g. purchase price history? See the KSeF invoice analytics service.
Other free tools: KSeF invoice XML to PDF (a printable visualisation) and the KSeF collective identifier generator for the transfer title.