How to upload interval data

Summary:

Uploading interval data is the most accurate way to model a customer’s energy consumption and calculate potential solar savings. OpenSolar supports 15, 30, and 60-minute interval data in CSV format and accommodates both vertical and horizontal data structures. This guide walks you through how to upload, configure, and manage interval data within your project.

Table of contents:

• Uploading Interval Data
• Data Formats
• Preparing the Data Before You Upload
• Video Walkthrough

Uploading Interval Data:

• Open your desired Project in OpenSolar.
• Navigate to the Energy tab.
• In the Electricity Usage section, select “Interval Data” from the Data Source dropdown.
• Select the Upload CSV button

Data Formats:

OpenSolar accepts the following configurations:

• Data Structures: Vertical or Horizontal
• Interval Durations: 15-minute, 30-minute, or 60-minute intervals

The only files that can be added are our templates that can be downloaded from the Upload CSV window:

Preparing the Data Before You Upload:

When you download one of our templates, these can not be edited. The file uploaded must have the same headers as when you download it, or the information will be incorrect.

If your usage information starts on 06/12, find the row 06/12 on our template and place the usage information there. 

• Partial Datasets Are Accepted: You do not need a full calendar year (January–December). The system supports data that:
  • Spans across years (e.g., June 2024 to May 2025)
  • Covers less than 12 months
• Automatic Extrapolation: Missing data will be intelligently filled by OpenSolar’s algorithm to estimate full-year values.
• Flexible Units: After uploading, you’ll be prompted to confirm or adjust the unit of measurement used in the file.
• Processing Time: Large datasets, especially at 15-minute intervals, may take slightly longer to process—please be patient.

Video Walkthrough