Create readings with a spreadsheet

This spreadsheet is a quick way to enter readings for a meter. The Readings spreadsheet doesn't replace the Interval Data Import functionality, but is helpful to enter data without requiring an interval data import format.

Setup Spreadsheets Overview

Setup spreadsheets help you save time by creating multiple items at once.

  • The menu shows only spreadsheets you have permission to use.
  • Always download a new spreadsheet before adding data—it’s populated with information from your database.
  • Follow the required upload order when creating related objects to avoid errors.
  • To save time, select a value from the drop-down and copy it into other rows as needed.

Formatting Rules

  • Enter all information as text or dates.
  • Only the sheet named DataEntry is processed—you can add other sheets, but they are ignored.
  • Do not rename, delete, or rearrange columns.

Download the create spreadsheet

In the Create dialog, click Setup Spreadsheets.

  1. From the Setup Spreadsheets Log, click Download.
  2. Under the Create Spreadsheet section, choose Readings.
  3. Download the spreadsheet.
  4. The name format is yyyymmdd-CREATE_Readings.xlsx.
  5. Add your information and save.
  6. Use Import to upload your spreadsheet.
  7. The Setup Spreadsheets Log reports the results and any errors. You can download the error (kickout) spreadsheet from the hyperlink, fix any errors, and upload the error sheet.

Permissions

The ability to create objects is determined by user role and any limits placed on the user's topmost place or topmost cost center.

Create readings spreadsheet details

Column Rule
Channel Import ID Enter either the Channel Import ID or the Meter Import ID to identify the meter and channel for the readings you want to import with this spreadsheet.
Meter Import ID
Channel Type
Interval
Reading Date Timestamp Enter the timestamp for the reading, use the meter timezone.
Value Enter the value for this timestamp. If a value is entered for an existing timestamp the existing value is replaced with the new value.
Estimated Value Choose Estimated Value from the drop-down if the value is estimated.
Note This note is shown in the interval data chart.