How to Add Historical Data

To upload historical data, you need to format your Excel sheet correctly. This guide explains the required columns and formats.

Required Columns

Your file must contain the following required columns:

1. ID

   • Indicates the installation or inverter ID for which a data point should be added.
   • Find the ID in the installation overview (hidden by default, but can be enabled).
   • IDs are unique to prevent confusion.

2. Time

   • Specifies the timestamp of the data point.
   • Accepted formats:
     • "YYYY-MM-DDTHH:MMZ" (e.g., "2022-02-01T08:00:00") – Includes time zone.
     • "YYYY-MM-DD" (e.g., "2022-02-01") – Assumes midnight (00:00:00).
   • If either the ID or Time column is missing, the file will not be processed.

Optional Columns