Skip to content
Screen Time Tracker cover: a sample sheet with hours logged, entries and average minutes per entry and a doughnut chart, beside the Dashboard and Log tabs

Screen Time Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

This screen time log helps you see which kinds of apps take up your day. The Log tab takes one row per block of use, with the date, an app group (social media, video, messaging, work, games or reading), the device and the minutes. The Dashboard totals your hours, counts entries and entries over an hour, shows each group's share of time in a doughnut chart and charts minutes by device.

Copy the minutes from your phone's usage report or your computer's activity screen rather than estimating them. Keep work tools in the Work group so the leisure groups show what you actually choose to do. Log one week before you set any targets, so the first figures show your normal habits instead of an ideal week.

Useful for

  • Finding which app group takes most of your evening
  • Comparing a workweek with a weekend
  • Checking whether a new phone limit changes your habits

What's included

  • 3 tabs: Dashboard, Log, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Log: 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 Log 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

Where do I find the minutes for each app?

iPhones show daily use under Screen Time, and Android phones show it under Digital Wellbeing. Windows and Mac computers also list app time in their activity settings. Group the apps yourself, then enter the total minutes for each group.

Why does the average look high?

The average is per entry, not per day. A day can have several entries, and one long work block pulls the number up. Divide the total hours by the number of days you logged to get a daily figure.

Can I log a whole week in one row?

Each row is meant to be one block, so a single weekly row would hide the pattern. Log each day's total for each group instead. You can still add up a week by sorting or filtering the Date column.

  • #habit-tracker
  • #screen-time-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…