How to Log Pool Chemical Readings Per Visit in a Spreadsheet

Customers ask “what did you add last week?” and regulators care that pools are documented. A free pool chemical log spreadsheet records readings, chemicals added, and notes per visit per pool.

Log at the pool, not at home

Each visit row:

1. Pool / customer
2. Date
3. Readings — chlorine, pH, alkalinity (your standard set)
4. Chemicals added — product and amount
5. Notes — algae brush, filter pressure, equipment issues

Thirty seconds poolside beats reconstructing from memory — and supports upsell conversations (“chlorine demand has been high three visits straight”).

Trend columns catch problems early

Sort or chart key readings over time — slow pH drift or rising chlorine demand predicts equipment or algae issues before the customer calls angry.

Link to route and billing

Only pools on today’s route schedule need rows — skipped pools get a skipped reason note instead of blank silence.

When sensor platforms win

Automated chemistry controllers and remote monitoring justify cost on commercial pools and large residential routes. Residential route techs often keep chemical logs in Sheets until liability or commercial accounts demand more.

These templates are service documentation tools. Follow product labels, local health codes, and certified operator requirements in your jurisdiction.