💧 Ottawa Water Export

Bookmarklet — exports hourly usage from the City of Ottawa water billing portal

How to install

Make sure your browser's Bookmarks bar is visible (Chrome: Ctrl+Shift+B / Mac: ⌘+Shift+B)

Drag the button below to your bookmarks bar (or right-click → Bookmark this link)

← Drag this to your bookmarks bar

What it does

Reads hourly consumption data directly from the same JSON API the portal chart uses
Fetches the date range you specify (default: last 90 days)
Downloads a .csv you can drag straight into the utility dashboard
Your login session is used — no passwords are stored or transmitted anywhere

After the download

Open your utility dashboard

Drag the downloaded ottawa-water-YYYY-MM-DD-to-YYYY-MM-DD.csv onto the drop zone

Water usage appears as a cyan 💧 line in the chart alongside electricity and gas

⚠ Troubleshooting

Must be run on water-billing.ottawa.ca while logged in
If "No data returned" appears, open DevTools (F12) → Console and inspect window.__ottawaWaterDebug to see the raw API response
If the meter number prompt is blank, check your portal URL for meterNumber=XXXXXXXX and paste it in

This tool only reads data you can already see in your own account. It does not store, transmit, or share any personal data.