Sponge
← Field Notes·Field Reports

Evaluating Batteries: How to acquire Smart‑Meter Load Data to Assess Battery Strategies

Utility-by-utility instructions for pulling Green Button and interval data across Canada, a client email you can send today, and how to load the file into Battery Proposal Studio.

Green ButtonInterval DataLoad ProfileStudio
Launch the Studio

Every client's battery savings depend on two things: their load profile and how much solar the property can carry. Two facilities on the same rate class can land on opposite battery strategies once you look at their interval data.

Analyzing existing load is how you pick the right storage strategy and the right battery size. This guide walks through getting a customer's meter data, with a focus on the Download My Data option that lets customers pull their own usage and billing history and share it with you.

01

How to get the data

  1. 01Ask the client to log into their utility's online account. Use the email template below.
  2. 02The client looks for the Download My Data or Green Button option.
  3. 03They select a date range (12 to 24 months), the interval granularity, and every relevant meter.
  4. 04They download the XML file and send it to you.
  5. 05You upload it to Battery Proposal Studio and model the battery.
Coverage

Not every utility offers smart-meter data. Ontario mandates Green Button Download My Data across its LDCs. Other provinces vary. Section 04 covers most major Canadian utilities. If your client's utility isn't listed, try the flow for a neighbouring utility or reach out to Sponge.

02

What you get, and why it matters

A typical smart-meter export contains:

  • →Interval usage. 15-, 30-, or 60-minute meter reads.
  • →Billing data. Bills, charges, and tariffs.
  • →Account and meter info. Account number, service address, meter identifiers.

Each piece feeds the simulation. Interval data shows where the peaks sit and how much of the load solar can cover. Billing data anchors the model to what the client pays today. Together they let you compare storage strategies against the proposed solar system and show the client their future bill under each one.

03

Client outreach template

Fast quote workflow

  1. 01Copy the email template below.
  2. 02Paste in steps 1 and 2 for your client's utility from section 04.
  3. 03Your client downloads the last 12 to 24 months of interval data, or the last 12+ bills, and sends it to you.
  4. 04Upload the file to Battery Proposal Studio to build the battery case.
Email Template: Download My Data
Subject: Quick step: share your smart-meter data for your solar and battery quote

Hi [Client Name],

To build an accurate solar and battery proposal, we need to see how your facility uses electricity hour by hour. Most utilities let you download this through a "Download My Data" or "Green Button" feature. It takes about 5 minutes, and you control the file the whole way.

Step 1. Log in: [Paste your client's utility login link]
Step 2. Find: [Paste the Green Button / Download My Data location]

Step 3. Select your data
  • Choose your service address or meter.
  • Pick a date range covering the last 12 to 24 months.
  • Choose interval usage data (15- or 30-minute) and billing data (12 months of bills) if available.

Step 4. Download the file
  Click Download. Your computer saves an XML file (for example, GreenButtonData.xml).

Step 5. Send it to us
  Reply to this email with the file attached.

Quick notes
  • The file is machine-readable XML. It will look confusing. That's normal.
  • It contains electricity usage and billing details only. No payment or password information.
  • We use it to build your quote and nothing else.
  • Some portals cap download size. If a full year of 15-minute data won't download in one go, download it a month at a time. Annoying, we know.

Thanks,
[Your Name]
[Your Company]
04

Utility by utility: finding smart-meter load data

Screens and labels differ by utility. The flow stays the same: log in to the online portal, then look for Download My Data or Green Button.

Ontario: Green Button

Every Ontario LDC offers Green Button Download My Data. Expect 15- or 60-minute interval data in XML.

Hydro One

Findthe Green Button or Download My Data option.

Alectra Utilities

Hamilton, Mississauga, Vaughan, Guelph and surrounding areas

Findthe Download My Data option. Download interval data and billing history for demand analysis.

Toronto Hydro

Findthe Green Button / Download My Data section.

Enova Power

Kitchener-Waterloo and Cambridge region

Findthe Green Button link in the dashboard.

London Hydro

Clickthe Green Button Platform link after logging in.

Enbridge Gas (natural gas)

Go tothe Share My Data or Download My Data section.

Gas data is monthly or bi-monthly. Useful for CHP and hybrid projects.

British Columbia: BC Hydro

Option 1: MyHydro portal (most common)

OpenView detailed consumption, or go to the Data download centre.

Option 2: Multi-unit or commercial properties

Providethe account number(s) and building address.
WaitBC Hydro processes most requests within 5 business days.
ShareForward the aggregated Excel file to your installer.

BC Hydro has no self-serve download for commercial facilities.

Québec: Hydro-Québec

Hydro-Québec

Openthe Consumption Profile tool in the account dashboard.

Nova Scotia: Nova Scotia Power

Residential and small commercial

OpenMyEnergy Insights for hourly, daily, monthly and annual usage.

Larger commercial or multi-unit

CallCustomer Care at 1-800-428-6230.
Requesthistorical interval or aggregated usage data for each meter.

Saskatchewan: SaskPower

Residential and small commercial

OpenMy Reports for hourly, daily, monthly and annual usage.

Larger commercial or multi-unit

CallCustomer Care at 1-888-757-6937.
Requesthistorical interval or aggregated usage data for each meter.

New Brunswick: NB Power

Residential and small commercial

OpenTrack and Manage Your Energy Use. Data is available down to 15-minute intervals.

Larger commercial or multi-unit

CallCustomer Care at 1-800-663-6272.
Requesthistorical interval or aggregated usage data for each meter.

Alberta

Much of Alberta does not have smart-meter data yet. The province targets full deployment by 2029. Identify the distribution utility, then log in with the account number from the bill.

EPCOR (Edmonton)

FortisAlberta

ENMAX Power

VisitENMAX

Manitoba: Manitoba Hydro

Manitoba has low smart-meter penetration. These steps download bills, which Studio can work from in place of interval data.

Residential and small commercial

OpenBilling → History → Statement of Account.
Selectthe date range and services (all, electric only, gas only).
ExportClick Filter, then choose PDF or Export to Excel.

P.E.I.: Maritime Electric

P.E.I. has low smart-meter penetration. Expect bills and monthly consumption summaries.

Residential and small commercial

OpenMy Account for monthly usage summaries.

Larger commercial or multi-unit

CallCustomer Care at 1-800-670-1012.
Requesthistorical or aggregated usage data for each meter.

Other Ontario LDCs, including Burlington Hydro and Entegrus, follow the same pattern. Look for Green Button or Download My Data in the customer portal.

05

Upload the data to Studio

Once you have the file, load it into Battery Proposal Studio. Studio reads Green Button XML and CSV exports and detects the interval length from the file.

Loading interval data

Battery Proposal Studio

01Go to Inputs.
02Click the Load Data tab.
03Choose the interval data file your client downloaded.
04In the Site Information tab, confirm the correct LDC and Rate Class. Studio needs both to build the annual cost baseline analysis.
Upload Problems

If the file won't load or the data looks wrong, reach out to Sponge. Send the original file and we'll get it working.

06

Troubleshooting

Gaps or Zeros
Normal around outages and meter swaps. Sponge cleans the data before simulation.
Multiple Meters
Ask the client to download data for every relevant meter on the account.
Privacy
The client controls the download and the file transfer. The file holds usage and billing data only.
Interval Length
Studio handles 15-, 30-, and 60-minute data. Keep the original raw files for audit.
No Baseline
Check the LDC and Rate Class in the Site Information tab. The annual cost baseline needs both.

Battery Proposal Studio

Got the file? Model the battery.

Load your client's interval data, set the LDC and rate class, and see the annual cost baseline before you size a single battery.