Skip to content
Water Intake Tracker cover: a sample sheet with ounces logged, drinks logged and average per drink (oz) and a column chart, beside the Dashboard and Intake tabs

Water Intake Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

This log works for anyone curious about how much they drink across an ordinary day. The Intake tab keeps one row per drink, with the date, the part of the day (morning, afternoon or evening), the drink type and the ounces. The Dashboard totals your ounces, counts your drinks, averages the size of each one and shows the share that is plain water. Two charts show ounces by time of day and by drink.

The sample rows cover three days, so the charts already show a pattern. Overwrite them with your own drinks as you go, and measure every container the same way so the totals stay comparable. Formulas and charts update when you add a row, so there is nothing to recalculate by hand.

Useful for

  • Checking whether most of your fluid comes in the morning
  • Comparing plain water with tea, milk and sparkling water
  • Bringing a week of drink logs to a doctor's visit

What's included

  • 3 tabs: Dashboard, Intake, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Intake: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Intake tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I log a bottle that is not measured in ounces?

Fill the bottle once with a measuring cup and note how many ounces it holds. Use that figure for every refill so the totals stay consistent. If you measure in milliliters, divide by 29.6 to get ounces before you enter the number.

Does this tell me how much water I should drink?

No. The template only adds up what you log. Daily needs vary with body size, activity, climate and health, so ask a doctor or dietitian for a target that suits you, then compare your totals against it.

Can several people share one water log?

The dashboard totals cover every row, so a shared file mixes everyone's intake together. Give each person a separate file if they want their own dashboard and charts.

  • #habit-tracker
  • #water-intake-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More habit tracker templates

See all 15

Also in Business operations

All business operations templates
Get this template

Preparing your template…