NEM12 CSV Spreadsheet Converter Tool
Last Updated: 2026-09-18
Features
- Load Interval Data from your Smart Meter in NEM12 CSV Format (How to get the Data ...)
- Reformat NEM12 CSV Data into Spreadsheet-Friendly Formats:
- Full Day of Intervals per Row
- Single Interval per Row
- Adjust the Length of Time in the Intervals from the Source NEM12 CSV Data into:
- 5 Minute Intervals
- 15 Minute Intervals
- 30 Minute Intervals
- Hourly Intervals
- Daily Intervals
- Open in Excel, Google Sheets, etc ... in a Structured Tabular Format (which unlike NEM12) is Specifically Design for Spreadsheets,
- Work directly with the Energy Data from NEM12 CSV (rather than negotiating the "100" "200" "300" "400" & "900" Row Labels).
- Displays on Desktops, Laptops, Tablets & Smart Phones
- Browser-Based (No Installation)
- Free for Personal and Commercial Use
- No Payment & No Signup
Note: NEM12 CSV typically comes with 30 Minute Intervals (and sometimes 5 or 15 Minute Intervals). NEM12 CSV Spreadsheet Converter will make available the Minutes per Interval Lengths that are Equal To and Greater Than the Source Data. This is because creating Shorter Intervals from Longer Intervals simply involves Summing the Totals; But creating Shorter Intervals from Longer Intervals involves Dividing the Totals into N Equal Parts - which is a Loss of Accuracy ... But we can make this Available if Users request it ...
Use Cases
Open NEM12 CSV in Spreadsheets in a Convenient Useable Format
- Unlike Raw NEM12 CSV which is a semi-structured, non-tabular data exchange format, NEM12 CSV Spreadsheet Converter produces structured tabular data that display consistently in Excel, Google Sheets, or LibreOffice Calc.
- The Meter Register appears on EVERY Row of Data clearly identify it
- The Date appears on EVERY Row of Data clearly showing when it was recorded
- The Time Intervals appears:
- On EVERY Row of Data in Interval per Row Format
- In the Heading of EVERY Column of Energy Data in Full Day per Row Format
Summarize & Analyze Data
- Create Charts in Excel, Google Sheets or LibreOffice Calc
- Create Tables in Excel, Google Sheets or LibreOffice Calc
- Create Pivot Tables in Excel, Google Sheets or LibreOffice Calc
- Sum or Average over different Time Intervals
- Find the Minimum or Maximum Value for different Time Intervals
Get Answers about Your Energy Use
- What is my Total Electricity Demand ?
- When am I using the Most Electricity ? - ie. What Months of the Year, what Days of the Week, what Hours of the Day, etc ...
- Is there Unexpected Electricity Demand ? - eg. Mysteriously large usage in the Middle of the Night ?
- How Much am I still importing from the Mains Grid despite my 5 kW Solar Power System ? (On Weekdays ? Overnight ? In Winter ? ...)
- Is my Existing Solar Export enough to fill a 10 kWh Battery in Winter ?
Launch NEM12 CSV Spreadsheet Converter
Note: If you only want summary charts and tables, our free NEM12 Smart Meter Data Analyzer Tool reads NEM12 directly in your browser — no spreadsheet required.
Free for Personal or Commercial Use.
Energy Assessors & Solar Sales Consultants
Please feel free to:
- Reformat NEM12 CSV for use preparing Your Own Reports, Quotations & Proposals
- Give Reformatted NEM12 CSV to your Customers who like to Crunch their Numbers
Easy and Secure
- Browser-Based (No Installation)
- No Payment & No Signup
- Private - Your Data is not shared with 3rd Parties
Getting 30 Minute Interval Data in CSV Format
This NEM12 CSV Series of Free Online Microtools currently supports 30 Minute Interval Data in AEMO NEM12 CSV Format.
The NEM12 Format can be obtained from Australian Electricity Distributors (or Electricity Retailers)
Getting NEM12 Data from Australian Electricity Distributors
Your Electricity Distributor (not your Electricity Retailer, but the company behind them who actually own the Poles & Wires ... often called a DNSP), typically have a Web Portal where you can access 30 Minute Interval Data from your Smart Meter in AEMO NEM12 Format (or similar) without a time-consuming email request to your Electricity Retailer.
Read a Guide about How to Download / Access Your Smart Meter Data ...