Why the XML file is hard to read
A Vietnamese e-invoice is an XML file at its source. Open it in a text editor or browser and you see tags, not a table. To add up amounts or filter by seller, you need the data in Excel.
Typing a few dozen invoices by hand takes hours and invites mistakes. This tool reads the whole batch at once.
How to convert e-invoice XML to Excel
- Get the XML files Download them from hoadondientu.gdt.gov.vn (the tax authority's e-invoice portal) or from your invoice provider. Keep ZIP files as they are.
- Drop the files Open E-invoice XML to Excel and drop .xml files, .zip files or a whole folder.
- Check the list Each invoice shows its date, seller, tax code and total, plus any warnings.
- Download the Excel file Press Download Excel. The page sends only the number of invoices, to count your free invoices. It never sends the invoices.
What is in the Excel file
One .xlsx file with two sheets. Invoices has one row per invoice: seller, buyer, tax codes, amount before tax, tax, total, warnings and more. Line items has one row per line of goods or services.
Amounts and dates are real numbers and dates, so you can add them up and filter them in Excel.
Which invoices it reads, and which it does not
- It reads the XML format set by the tax authority in Decision 1233/QD-CT, versions 2.0.0 to 2.1.1, for all nine invoice types.
- It was tested with real public invoices from 14 providers, among them VNPT, MISA, Viettel, BKAV and EasyInvoice.
- Invoices in the format used before July 2022 (TT32) are not supported yet.
- It cannot read PDF, image, Excel, RAR, 7z or old .inv files. For each one, it tells you the problem and what to do.
- It warns when the lines do not add up to the total, a tax code is missing, or a series C invoice has no tax authority code. The same invoice added twice is kept once.
- It does not check the digital signature. Look the invoice up on hoadondientu.gdt.gov.vn for that.
Frequently asked questions
How do I convert Vietnam e-invoice XML to Excel?
Open E-invoice XML to Excel on Yangopen, drop the XML or ZIP files, then download the Excel file. It runs in your browser.
Can it read invoices from VNPT, MISA, Viettel or BKAV?
Yes. It reads the tax authority's XML format (Decision 1233/QD-CT, versions 2.0.0 to 2.1.1) and was tested with real invoices from 14 providers, including those four and EasyInvoice.
Is it free?
You get free invoices every day, with or without an account. More invoices use prepaid credit, which needs an account. See the pricing page for the current numbers.
Are my invoices uploaded?
No. The XML files are read in your browser. When you download the Excel file, the page sends only the number of invoices, to count your free ones.
Does it read the ZIP files from the tax portal?
Yes. It reads .xml files, .zip files (also a ZIP inside a ZIP) and whole folders.
Does it verify that an invoice is genuine?
No. It does not check the digital signature. It only warns about data problems, such as totals that do not match. To verify, look the invoice up on hoadondientu.gdt.gov.vn.
Updated: