KY24

Export readings in your own format

Readings now export as CSV for spreadsheets, or in formats of your own, e.g. for accounting software.

The new Export page downloads the meters' readings of the months you choose, for one building or for all of them at once.

Built-in formats

Two CSV files, with a column for each meter, like the readings page:

FormatFor
CSV with commasMost spreadsheets in English
CSV with semicolonsSpreadsheets in most other European languages, e.g. Excel in Estonian or Russian

Your building's own formats

For software that wants a layout of its own, set up a format with placeholders, in Liquid. Each row of the export is written with it, e.g.:

{{ apartment }};{{ month | date: "MM.YYYY" }};{{ cw }};{{ hw }}

Here cw and hw are the meters' aliases, which you set on each meter (see how to create meters). Each building has its own formats, which its members set up in its Export formats section: everyone who can export the building's readings uses them.

Exporting takes the Export the data they can view permission. Ask an administrator if you need it.