CSV File Formats for FTP Integration // Wattics Energy Management Software
Book a Demo

Wattics customersDiscover how we can help you drive savings & increase sustainability for your customers or organization

Wattics companyLearn more about who we are, our core values and why our customers choose to partner with us

CSV File Formats for FTP Integration

ftp

Download the CSV Template

Format 1Interval kWh or numeric value
e.g. Orsis/NavitronA – “Description”
B – “Name”
C – “Unique Identifier”
D – Date and Time (DD/MM/YY HH:MM:SS)
E – Interval kWh or numeric valueFile Name: CSV-Template-Interval-1column-option1.csv

 

 

 

Download the CSV Template

Format 2Interval kWh or numeric valueA – Unique Identifier
B – Date and Time (YYYY-MM-DD HH:MM:SS)
C – Interval kWh or numeric valueFile Name: CSV-Template-Interval-1column-option2.csv

 

 

 

Download the CSV Template

Format 3Interval kWh or numeric valueA – Unique Identifier
B – Date and Time (DD/MM/YY HH:MM:SS)
C – Interval kWh or numeric valueFile Name: CSV-Template-Interval-1column-option3.csv

 

 

 

Download the CSV Template

Format 4Tab separated
Interval kWh or numeric valueA – Unique Identifier
B – Date and Time (MM/DD/YYYY HH:MM)
C – Interval kWh or numeric valueFile Name: CSV-Template-Interval-1column-option4.csv

 

 

 

 

Download the CSV Template

Format 5kWh readings (interval)
e.g. Automated Meter Reading (AMR) – StarkA – Unique Identifier
B – Date (DD/MM/YY)
C – Description/Name
D – 00:00 to 00:30 – Interval kWh or numeric value
E – 00:30 to 01:00 – Interval kWh or numeric value
F – 01:00 to 01:30 – Interval kWh or numeric value
G – 01:30 to 02:00 – Interval kWh or numeric value
etc until 23:30 to 24:00 – Interval kWh or numeric valueFile Name: CSV-Template-Interval-48columns-30mn-option1.csv

 

 

 

Download the CSV Template

Format 6kWh readings (interval)
e.g. Automated Meter Reading (AMR) – STCEnergyA – Code
B – Location Name
C – Meter MPAN
D – Meter serial
E – Read Date
F – 00:00 to 00:30 – Interval kWh or numeric value
G – 00:30 to 01:00 – Interval kWh or numeric value
H – 01:00 to 01:30 – Interval kWh or numeric value
I – 01:30 to 02:00 – Interval kWh or numeric value
etc until 23:30 to 24:00 – Interval kWh or numeric valueFile Name: CSV-Template-Interval-48columns-30mn-option2.csv

 

 

 

Download the CSV Template

Format 7kWh readings (accumulated and interval)
e.g. Automated Meter Reading (AMR) – Total Gas & Power LtdA – Consumer Name
B – MPRN
C – MPRN Alias
D – Site
E – AMR Schedule
F – Read Date (DD-Month-YYYY)
G – Accumulated Reading
H – Consumption Profile Date (DD-Month-YYYY)
I – Profile Date Consumption
J – 00:00 to 00:30 – Interval kWh or numeric value
K – 00:30 to 01:00 – Interval kWh or numeric value
L – 01:00 to 01:30 – Interval kWh or numeric value
M – 01:30 to 02:00 – Interval kWh or numeric value
etc until 23:30 to 24:00 – Interval kWh or numeric value
Z – Reporting UnitFile Name: CSV-Template-AccumulatedandInterval-48columns-30mn.csv

 

 

 

Download the CSV Template

Format 8kWh readings (accumulated and interval)
e.g. Automated Meter Reading (AMR) – ASL HoldingsA – Description/Name
B – Unique Identifier
C – Time and Date (HH:MM:SS DD/MM/YY)
D – Accumulated total on Channel 1
E – Accumulated total on Channel 2
F – 00:00 to 00:30 – Channel 1 interval kWh or numeric value
G – 00:30 to 01:00 – Channel 2 interval kWh or numeric value
H – 01:00 to 01:30 – Channel 1 interval kWh or numeric value
I – 01:30 to 02:00 – Channel 2 interval kWh or numeric value
etc until 23:30 to 24:00 – Interval kWh or numeric valueFile Name: CSV-Template-2Channels-AccumulatedandInterval-48columns-30mn.csv

 

 

 

Sign up to our blog posts

Sign up to keep up-to-date with what’s happening within the industry

Technology Update

Check out our latest offering:

“WatticsAir – Air Quality Monitoring and Analytics”
Go to page