Updated

Habit Tracker for Google Sheets (Free Client Template)

Habit tracker for Google Sheets with weekly targets, a daily grid and a coach adherence view. Preview the examples and download free CSVs.

Free starter CSV downloads

Get every tab as a CSV by email, then import them into your own Google Sheet. The previews below are open to everyone and use fictional example data.

Get the free CSVs by email

We email you a private download link. No payment. The previews below stay open to everyone.

  • Habits
  • Daily Grid
  • Streak
  • Coach View

One access email, even if you leave the box empty. The link works for 24 hours. Privacy policy

CSV files carry the layout and example rows only, not formatting, charts, checkboxes or a shared Google Form. Formula cells arrive as text: check each one, then delete the leading apostrophe to switch it on.

Habits

Set targets together. Example frequencies are planning inputs, not health recommendations.

Habits fictional example rows
HabitTarget per week
Prepare tomorrow’s training kit3

Daily Grid

After importing, turn B:H into checkboxes. COUNTIF counts completed days; the consecutive streak uses the previous day, not the weekly count.

Daily Grid fictional example rows
HabitMonTueWedThuFriSatSunCompleted daysTargetWeekly %
Prepare tomorrow’s training kittruetruefalsefalsefalsefalsefalse2366.7%

Completed days formula (daily-grid):

=COUNTIF(B2:H2,TRUE)

Weekly % formula (daily-grid):

=IF(J2>0,MIN(I2/J2,1),"")

Streak

One row per habit per date, sorted by date. First row starts a new streak. Copy the third-row formula down.

Streak fictional example rows
HabitDateCompletedConsecutive days
Training kit2026-10-08true1
Training kit2026-10-09true2

Consecutive days formula (streak):

=IF(C3,IF(AND(A3=A2,B3=B2+1),D2+1,1),0)

Coach View

Review the pattern and barriers with the client, without using the score as a judgement.

Coach View fictional example rows
HabitWeekly adherenceNext review
Prepare tomorrow’s training kit66.7%Agree next week’s target

Weekly adherence formula (coach-view):

='Daily Grid'!K2

More free templates

Frequently asked questions

How do I add checkboxes?

Import the Daily Grid CSV, select the seven day columns and choose Insert → Checkbox in Google Sheets. Check the imported TRUE/FALSE values.

What does weekly adherence mean?

Completed days divided by the agreed weekly target, capped at 100%. It is different from a consecutive-day streak.

Can I change the habits?

Yes. Change labels and targets to match the client. Keep a separate file for each person and avoid collecting unnecessary health details.