TV Show Tracker - Excel

Ever scrolled through Netflix for twenty minutes, picked a show, watched ten minutes, and then realized you already saw the first three episodes last month? You know that sinking feeling — dozens of shows scattered across streaming services, no idea which season you stopped on, and no record of what was actually worth your time. This TV show tracker spreadsheet for Excel turns that chaos into 8 organized tabs where every show, episode, rating, and review lives in one place.

The Shows tab is where your collection takes shape. You can track up to 500 shows with genre, season count, episode count, duration, streaming platform, and watch status all laid out in columns. Each show gets its own photo, so you are scanning images instead of reading through a wall of text. The real depth comes from the five rating categories — Overall, Story, Acting, Production, and Music — because a show can have a fantastic soundtrack and a terrible plot, and a single star rating never captures that.

The Episodes tab holds up to 500 of your favorites, logged by show name, episode number, and title, each with its own photo and rating. So when a friend asks which episode of The Bear they should watch first, you pull up the tab and give them a real answer. The Actors tab keeps a running record of performers you follow across different series, so you never lose track of who caught your eye in what.

The Critic Ratings tab is where your tracker starts doing double duty. You log reviews from sources like Rotten Tomatoes or IMDb, noting the reviewer, rating score, year, and a direct link to the review URL. Average ratings get calculated across shows, which means the next time you sit down with nothing to watch, you have actual data to guide the decision. The Journal tab captures your daily viewing sessions — date, show, genre, photo, and episode count — and lays them out alongside a weekly progress chart, monthly activity stats, and your longest binge streak.

The Dashboard is the payoff. You open it and see everything at a glance: total shows tracked, shows completed, total episodes tracked, time spent watching, actors tracked, and shows you are currently watching. Bar charts line up your top-rated shows next to the highest critic-rated ones, and a pie chart breaks down which of your shows have critic ratings attached. It turns months of scattered viewing into a single visual story.

This spreadsheet runs in Microsoft Excel, works offline, and lives on your own computer. No subscriptions, no accounts, no data stored on someone else’s server. It comes with free updates, so the tracker keeps improving after you download it. If your watch history currently exists as half-remembered conversations and a “Continue Watching” row that stretches into infinity, this is where it all finally comes together.