Movie Tracker Spreadsheet, TV Show Tracker and Movie Log with Ratings, Watchlist and Yearly Film Goal, Google Sheets Excel

A movie tracker spreadsheet for every movie you watch: keep your watchlist honest, follow your shows, and see your year in movies.

🔗 TRY THE LIVE DEMO before you buy (view only, nothing to install): https://docs.google.com/spreadsheets/d/1ByxE7BvLE1oWYMvjYiGPUTFUanUHHdkTq0jQV_E3e-s/edit?gid=1128252995

📊 WHAT IT DOES

✓ Watched: one line per movie — date, title, genre, director, where you watched it, and your rating. Each movie is numbered toward your goal.
✓ Mark a rewatch and the check shows how your rating moved since the last time you saw it.
✓ Watchlist: everything you mean to watch, with where it streams and who suggested it. It crosses itself off when the title shows up on Watched.
✓ Shows: the season and episode you are on, how many episodes are left, and which shows went quiet.
✓ Stats: movies this year against your goal and pace, month by month, your top genres, and what each streaming service costs per watch, with two charts.

📂 WHAT'S INSIDE: 5 TABS AND 2 CHARTS

✓ Start here: your name, the year, your movie goal, the rewatch rule, and the streaming services you pay for
✓ Watched: four cards and your movie diary
✓ Watchlist: four cards and everything you mean to watch
✓ Shows: four cards and every series you follow
✓ Stats: four cards, month by month, genres, your services, and two charts

📝 HOW IT WORKS

1. Open the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.
2. On Start here, set your goal for the year and the services you pay for.
3. After each movie, add a line on Watched with the date, the title, and your rating.
4. Put what you mean to watch on Watchlist and follow series on Shows. Stats does the rest.

📥 WHAT YOU GET

✓ Google Sheets version (the link is in the PDF)
✓ Excel version (.xlsx) for desktop Excel 2016 or newer and Microsoft 365, on Windows or Mac
✓ A filled example to look around, and a blank copy for your own use
✓ A PDF guide with screenshots, the links and the first steps
✓ A video guide for this spreadsheet (the link is in the PDF)

💻 GOOD TO KNOW

✓ Works with a free Google account. No app, no ads, no subscription.
✓ Ratings go from half a star to five stars, halves allowed.
✓ A finished season of a show can go on Watched too. It is counted apart from your movie goal.
✓ Cost a watch divides what you paid a service this year by what you watched on it, so you can see which one to pause.
✓ Formulas are protected, so you can't break anything by accident.
✓ Set it up on a computer in a few minutes. After that, the Google Sheets app works for a quick check on your phone.
✓ The photos show Google Sheets. The Excel file has the same tabs and formulas (the jump links between tabs are a Google Sheets feature).
✓ On a Mac? Use free Google Sheets or Excel for Mac.
✓ Free updates for life.

This is a digital download, so nothing is shipped. If anything is unclear after you buy, message me and I'll help you set it up.