Etoolio

CSV to UAE E-Invoice Converter

Free bulk converter from Excel or CSV to UAE e-invoices. One row per invoice line becomes one PINT AE (UBL 2.1) XML per invoice, with TRNs, VAT and totals checked. Download as a zip. Never uploaded.

Updated

1. Seller (you)

Used for every invoice, unless your file has seller_name and seller_trn columns.

2. Your invoices (CSV, one row per invoice line)

Drop your CSV file here

Rows with the same invoice number become one invoice. The file is read in your browser and never uploaded.
Or paste CSV text
Which columns can I use?
ColumnNeededNotes
invoice_numberYesRows with the same number become one invoice
issue_dateYes2026-11-14 or 14/11/2026 (day first)
due_dateNoOptional
currencyNoOptional, AED if empty
exchange_rateNoAED per 1 unit, needed when not AED
buyer_nameYesLegal name
buyer_trnYes15 digits
buyer_cityNoOptional, Dubai if empty
seller_nameNoOptional, overrides the Seller box
seller_trnNoOptional, overrides the Seller box
seller_cityNoOptional
descriptionYesLine item
quantityYesMore than 0
unit_priceYesBefore VAT
vat_rateNo5, 0 or exempt; 5 if empty
unit_codeNoOptional, EA if empty

Common header names such as "Invoice No", "Customer", "Qty" and "Price" are recognised too.

Creates PINT AE (UBL 2.1) tax invoices with the core fields: both parties' TRN and 0235 Peppol ID, lines, VAT breakdown and totals, and the VAT in AED for foreign-currency invoices. The Ministry of Finance lists 51 mandatory fields for a tax invoice, so treat these as drafts and send them through your Accredited Service Provider, which runs the full validation. Credit notes are not covered.

From a spreadsheet to UAE e-invoices

Many UAE businesses still raise invoices in Excel, or can export them from their accounting system only as a spreadsheet. Under UAE e-invoicing that is no longer the invoice: the legal invoice is a PINT AE XML file sent through an Accredited Service Provider. This converter bridges the gap. Save your sheet as CSV with one row per invoice line, open it here, and you get one PINT AE (UBL 2.1) XML per invoice, checked and ready to download as a zip.

How to prepare the CSV

  1. Start from the template (the "Download the CSV template" link) or rename the headers in your own sheet. Common names such as Invoice No, Customer, Qty and Price are recognised.
  2. One row per line item. An invoice with three items is three rows with the same invoice number, buyer and dates.
  3. Save as CSV. In Excel choose File, Save As, "CSV UTF-8 (Comma delimited)". Google Sheets: File, Download, Comma-separated values.
  4. Enter your own details once in the Seller box (legal name, TRN, emirate), then open the CSV.
ColumnNeededExample
invoice_numberYesINV-1001
issue_dateYes14/11/2026 or 2026-11-14 (day first)
buyer_name, buyer_trnYesAl Noor Trading LLC, 100234567800003
description, quantity, unit_priceYesWebsite maintenance, 1, 2500
vat_rateNo (5 if empty)5, 0 or exempt
currency, exchange_rateNo (AED if empty)USD, 3.6725
due_date, buyer_city, unit_codeNo14/12/2026, Abu Dhabi, HUR

What it checks

Before creating any XML it checks every row and lists problems by spreadsheet row number, so you can fix them in Excel and open the file again:

  • TRNs: yours and each buyer's must have 15 digits. The 0235 Peppol ID (0235 followed by the first 10 digits, the TIN) is filled in for both parties. To clean a customer list first, use the TRN to TIN and Peppol ID converter.
  • Dates and amounts: real dates, quantities above 0, prices that are numbers (commas and "AED" are fine), and a due date that is not before the issue date.
  • VAT: 5% standard, 0% zero-rated or exempt on each line. VAT is calculated per category on the category total, as EN 16931 requires, so it never drifts by a fils.
  • Consistency: every row of one invoice must have the same buyer, dates and currency; a different value is usually a copy and paste mistake.
  • The finished XML: each file is read back with the same parser as the e-invoice XML viewer and checked with its totals rules before you can download it.

Invoices in a foreign currency

A PINT AE invoice can be in US dollars, euros or any other currency, but the VAT must also be stated in AED. Add currency and exchange_rate columns (AED per one unit, such as 3.6725 for USD) and the converter adds the AED tax currency and the VAT total in AED to the XML.

What it does not do

  • It creates tax invoices (type 380) only, not credit notes.
  • It carries the core fields. The Ministry of Finance lists 51 mandatory fields for a tax invoice, such as full addresses and payment details, which your ASP or accounting system adds and validates.
  • It does not send anything. Invoices reach your customer and the FTA through your Accredited Service Provider.

To make a single invoice by hand, use the PINT AE invoice generator. Everything here runs in your browser: the CSV, the XML files and the zip never leave your device.

Good to know

CSV to UAE E-Invoice Converter, frequently asked questions

Can I create UAE e-invoices from Excel?

Yes. Save your sheet as CSV (in Excel: File, Save As, CSV UTF-8) with one row per invoice line, open it here and you get one PINT AE XML file per invoice. Rows that share an invoice number become one invoice, so a three-line invoice is three rows.

Which columns does the CSV need?

invoice_number, issue_date, buyer_name, buyer_trn, description, quantity and unit_price. Optional: due_date, currency, exchange_rate, buyer_city, vat_rate (5, 0 or exempt, 5 if empty), unit_code, and seller_name and seller_trn if one file holds invoices from several of your companies. Common headers such as Invoice No, Customer, Qty and Price are recognised too. Download the template to start.

Is a PDF or Excel invoice valid under UAE e-invoicing?

No. Once your e-invoicing date arrives, the legal invoice is the PINT AE XML exchanged through Accredited Service Providers over Peppol. The Ministry of Finance says PDF, Word, Excel, scanned and emailed invoices are not e-invoices. A spreadsheet is still a fine place to prepare the data, which is what this converter is for.

How does it handle invoices in US dollars or other currencies?

Add the currency and an exchange_rate column (AED per one unit, for example 3.6725 for USD). The XML keeps the amounts in the invoice currency and adds the VAT total in AED, which PINT AE requires for foreign-currency invoices.

What does it check before creating the XML?

Each invoice needs a valid issue date, a 15-digit TRN for you and the buyer, a description, a quantity above 0, a price and a VAT rate of 5, 0 or exempt on every line, and the same buyer and dates on every row of the invoice. Any row that fails is listed with its row number. Each XML it creates is then read back and checked with the EN 16931 totals rules.

Can I send these files straight to the FTA?

No. Invoices go through your Accredited Service Provider, which validates them, delivers them to your customer's provider and reports the tax data to the FTA. The files here carry the core PINT AE fields and are best used as drafts, for testing with your ASP, or to load into a system that sends them.

Is my invoice data uploaded?

No. The CSV is read and converted in your browser, and the XML files and zip are built on your device. Nothing is sent to a server or stored.