Bulk importing readings – file format for single meter
To import data it needs to be in a CSV file format.
You can upload data for:
- Date
- Reading/usage
- Actual cost (optional)
- Comments (optional)
Format requirements:
- 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.