Essentio Data Formats

Last updated: 2 November 2026

Essentio hands you your data in two downloads: a Business's full archive, and your own personal data. This page describes every file each one holds and, for a spreadsheet, each of its columns. Nothing in them is locked to Essentio: PDF, the EU e-invoice XML, CSV and JSON are open formats that other software reads.

The Business Archive

An Owner or an Admin asks for it in Settings → General, on every plan. Essentio builds it in the background and emails a link to it, valid for 7 days without signing in. It is one ZIP file holding:

<number> is the document's or the Receipt's number. A character other than a letter, a digit, a dot, a hyphen or an underscore, such as the slash a number pattern may hold, is written as an underscore. A Draft has no number yet, so its file is named by <id>, the number Essentio gives each document, which the Public API names it by too.

The CSV files are UTF-8, comma-separated, with a header row and double quotes around a cell that needs them. Amounts are decimals with a dot, never rounded by the export, and dates are written as YYYY-MM-DD. A cell whose text begins with =, +, -, @, a tab or a line break is written with an apostrophe (') in front, so a spreadsheet application shows it as text and does not run it as a formula, and so is a cell whose text already begins with apostrophes before one of those characters; a plain number such as -5 is written as it is. Essentio's Import Clients removes that one apostrophe. The JSON files are UTF-8; in them an amount or a rate is a string holding a decimal with a dot, never rounded, a date is YYYY-MM-DD, a time is ISO 8601 with its offset, and a value that was never given is null.

clients.csv

Every Client, and every deleted Client that an issued document still names, so that each PDF has its row. It is the same file as Clients → Export → Essentio file, and Clients → Import reads it back.

The import reads the columns from Account Code to Notes; it ignores the last three.

payments.csv

Every Payment recorded on a document, oldest first.

products.csv

Every Product, an archived one included, by its code. A deleted Product is not in it.

drafts/<id>.json

Every Draft, one file each: the document as the Public API gives it, its Document, which the developer site describes field by field, without the two fields that say what may be done with it now and where its Client opens it. A deleted Draft is not in the archive.

settings.json

What the Business set up in Essentio. It holds no password, login, key, token or secret: not the mail server's, not the connected mailbox's, not an API key, a Webhook's or a bank connection's.

Download my data

Profile → Download my data gives any User their own personal data at once, as one JSON file named essentio-my-data-<date>.json. It holds nothing a Business keeps, such as its documents, Clients or Payments: those are in the Business Archive. Times are ISO 8601 with their offset, and a time that never happened is null.

The file holds no password, key or secret, and nothing about another person, not even who invited you.