Movie & TV Show Tracker | Google Sheets Template

Remember every movie and show you watch, what you thought of it and what to watch next. Log a title in seconds, rate it from 1 to 10 and this Google Sheet does the rest: hours watched, favourite genre, series progress, yearly stats and a colourful dashboard.

WHAT'S INSIDE (7 tabs)

- START HERE: quick setup steps and tips

- Dashboard: titles watched this year, hours watched, average rating, favourite genre, movies, series and episodes, watchlist count, yearly goal bar, 5 charts (watched per month, genres, movies vs series, how you rated them, where you watch), your top 10 rated titles and what is up next from your watchlist

- Watched: date, title, movie or series, genre, where you watched, who with, episodes, minutes, rating, rewatch and notes, with automatic stars and hours

- Watchlist: everything you want to see with type, genre, where to watch, priority, date added and who recommended it. Titles are marked watched automatically

- Series: seasons, current season, episodes watched, status and rating, with the next episode to watch and progress bars for the season and the whole show

- Yearly Stats: month by month titles, movies, series, hours, average rating, top genre, rewatches and goal progress, plus breakdowns by genre and by where you watch

- Setup: your name, year, yearly goal, average movie and episode length, and your own genres, places you watch and people you watch with

HOW IT WORKS

1. After purchase, download the PDF from the link in your confirmation email.

2. Click the link. Google asks you to make a copy, which is saved to your own Google Drive.

3. Set your year and goal, then add what you watch and what you want to watch. Everything else updates automatically.

GOOD TO KNOW

- Two versions included: one with sample data to explore and a blank one ready for your own list

- Works for movies, TV series, documentaries and animation, wherever you watch: streaming, TV, cinema or rental

- Hours are worked out from the minutes, or from the average lengths you set if you leave them blank

- A fun digital gift for movie lovers and TV fans

- Works in Google Sheets on computer, tablet and phone. A free Google account is needed. Not made for Excel or Numbers

- Cells that calculate show a gentle warning if you try to edit them, so formulas are not deleted by accident

- This is a digital product. No physical item will be shipped

- For personal use only. Please do not share or resell

- Because this is a digital download, returns are not accepted. If you have any problem, reply to your download email and I will be happy to help