To upload a usage data file as a comma separated values (CSVs) file, select the option CSV Upload for the 'Edit Usage By' dropdown.  

• Grace Subang (Unlicensed) to add image of selecting CSV Upload 

For CSV Upload, the data format is critical for the functionality to work.  Please review the instructions and example data provided on the page to ensure your data is formatted correctly.  For the Beta release, Sighten only supports the common format provided by UtilityAPI.  Here are the current instructions:

1. The following column headers are required: interval_start, interval_end and interval_kWh. Additional columns will be ignored.
2. Ensure all information is complete. There should not be rows or cells missing within the data. Otherwise, Sighten will extrapolate the missing data.

Grace Subang (Unlicensed) - Workflow / Screenshots / Steps: you will need to walk through the steps as Sightenadmin

• Process for Uploading
  • You can use the sample included in this description to walk through the steps
  • Steps:
    • Switch to CSV Upload
    • Click Upload
    • Select File
• Uploaded State - highlight that you can re-download the CSV
• Error State
  • If you delete a column from the downloaded sample CSV, and then upload, it will fail
• Site Documents (right side menu) - the CSV versions are automatically uploaded to the site documents as well
• Extrapolated Data (Notification)
  • If you delete a few rows (and not any of the columns), we will extrapolate the data and a notification confirming we extrapolated data - capture this in a screenshot

Example CSV Files

Example CSV files for PGE attached here (interval data & monthly data)

If you have an excel file for homeowner interval data, you can click Save As and select Comma Separated Values, and then use that version to upload to Sighten.  

Related articles

To learn about usage entry, defaulting, or how to access the monthly electricity usage modal, check out the following article:

• How do I enter utility usage information?