What it does
Upload a meter reading export (from a utility portal, building management system, or smart meter). Get back a clean CSV with normalized timestamps, reading values as plain numbers, consumption deltas calculated between consecutive readings, and obvious outliers flagged.
The problem it solves
Smart meter exports and manual reading logs are inconsistently formatted: timestamps in different timezone conventions, reading values with unit suffixes embedded, and missing readings that break consumption calculations. Preparing this data for analysis or billing reconciliation requires significant cleanup.
What it handles automatically
- Timestamp normalization — Converts all reading timestamps to ISO 8601 with UTC offset
- Unit stripping — Removes kWh, kW, m³, CCF, and similar unit suffixes from numeric reading columns
- Consumption calculation — Calculates usage between consecutive readings (current − previous) per meter
- Outlier flagging — Flags readings where consumption jumps more than 3× the average (potential meter error or data issue)
- Gap detection — Identifies missing reading periods (gaps in the expected schedule)
FAQ
Does it handle half-hourly or 15-minute interval data? Yes. The tool works with any interval — hourly, daily, monthly — as long as readings are sorted by timestamp.
What if readings span multiple meters or accounts? Group by meter ID: the tool processes each meter ID independently and calculates deltas per meter.
Does it store my data? No. All processing is in your browser.