Check half-hourly electricity data for gaps, duplicate timestamps and suspect rows before using it for portfolio reporting.
Half-hourly meter data checker
Check half-hourly electricity data for gaps, duplicate timestamps and suspect rows before using it for portfolio reporting.
Use interval-start times with explicit UTC offsets. Gaps are reported in UTC, including across clock changes. Meters entirely absent from the file cannot be identified. Negative readings are flagged for review.
How to use the result
Give the checker a single reporting window shared by the meters in your file. It measures coverage against the expected half-hourly slots for each named meter and lists contiguous gaps with their start and end times. Resolve duplicated or conflicting records at source before summing consumption.
What to enter
- First expected interval (ISO timestamp with offset) — for example, 2026-10-01T00:00:00+01:00.
- End of period, exclusive (ISO timestamp with offset) — for example, 2026-10-01T02:00:00+01:00.
Prepare your CSV
Download the example from the tool and keep the header row. Replace the example entries with your own, then load the file. The sample rows are illustrative.
Assumptions
Use interval-start times with explicit UTC offsets. Gaps are reported in UTC, including across clock changes. Meters entirely absent from the file cannot be identified. Negative readings are flagged for review.
Download a report or results CSV to keep a copy. You can save the inputs separately and restore them when you return. Where email is available, the form explains who receives a copy and asks you to confirm before sending.