How to create a CSV with consumption data
This article will explain the steps necessary to transfer consumption data from any source into the CSV format supported by HelioScope.
Open a new empty Excel spreadsheet and go to the Data tab.
From the Get External Data option, select From Text.
Select the CSV example file you have downloaded from HelioScope's Help Article.
Select Delimited in the data type. Click Next.
Select Tab then Semicolon or Comma depending on your location, comma if you use a "." for decimal indicator, and semicolon if you use a "," for decimal indicator. Click Next.
Select Text in the Column Data Format. Click Finish.
Select to import the data into the Existing sheet. Click OK.
Insert the 8760 fields of hourly consumption data from your consumption file into the Energy column in kWh. Review the month of February to adjust for leap or non-leap years.
Save As CSV Comma Delimited and upload to HelioScope.
Microsoft Support Article on how to change Regional Format Setting in Excel: