Bulk importing readings – file format for Multiple Meters

To import data for multiple meters it needs to be in a CSV file format.



You can upload data for:


- Meter ID

- Date

- Reading/usage

- Actual cost (optional)

- Comments (optional)


Format requirements:


- 'Meter ID' must match your meter's 'Pilio meter name'.

- Date values must have the following format: DD/MM/YYYY. The order is not important.

- Reading/usage and Actual cost values must be number formatted with no thousands separators.

- Both point (".") and comma (",") can be used as a decimal separator. This is set up in the user account settings.

- There must only be one line of column headers and they must be valid CSV files (i.e. only comma/semicolumn delimited files for each column).


You can create your meter readings file in Excel just making sure that when you save the file it is as a CSV file.