Movie and Show Tracking Spreadsheet, Google Sheets Template: walkthrough

Managing work using Google Sheets is one of the popular methods employed by many individuals and businesses to implement and track work progress. With its useful features, Google Sheets is a powerful tool that supports managers in smoothly overseeing work and enhances team productivity.

As a person who enjoys movies and TV shows like myself, having a program management template is essential. I’ve tried numerous templates, but they weren’t effective. However, when I was introduced to the Movie and Show Tracking Spreadsheet, Google Sheets Template, 2023 Movie Tracker, Movie Tracker Template, Show Tracker Template, it was different. It’s user-friendly and well-suited for individuals with an extensive list of programs to watch, just like me.

How to download

Regarding the Updates, this information will always be accessible through the link you receive via Etsy, officehabit, This means you will have perpetual access to the movie spreadsheet. In the accompanying instructions page, you’ll find valuable tips and tricks on how to perform various tasks and make selections. To begin, go to the “File” menu and select “Make a Copy,” which will provide you with an editable version.

You won’t be able to edit the template directly, as I need it to remain blank for everyone else. However, once you make a copy, it will appear in your Google Drive, and you can edit that version. It should open automatically. After you’ve finished, simply close it, and you’ll be all set.

Concerning the instructions, once you’ve read them or if you feel you no longer require them, you can click the small downward arrow and hide or delete this sheet. Rest assured, there are no critical dependencies on this sheet that you need to be concerned about.

This Templates: Movie and Show Tracking Spreadsheet, Google Sheets Template

How to fill out

This is where you will input all your information. The way you choose to input it is entirely up to you. For movies, you can obviously insert the movie title. However, when it comes to TV shows, it’s a bit different. You could potentially enter the title of the show, the season, and then the episode number. Alternatively, you could use the season name or the episode name. For instance, if the episode name is something like “Oh, Woe Is Me,” you can input that and mark it as a show.

Next, you’ll input the duration, which is currently set in hours and minutes. Sometimes this format resets, and to change it, select the entire column by clicking on the “D” at the top. Go to “Format” and then “Number.” You can adjust it to “Total minutes” if you prefer that format.

You’ll also note when you watched it, including the watch month (which is used for tracking statistics). But if you don’t need a specific date, feel free to skip this option. Rate the movie or show on a personal scale of one to five.

Indicate if you finished watching it or if it’s part of a series, and what number it is in the series. For TV shows, you could potentially include the episode number.

You can also specify whether you finished the series by clicking the respective button. Include the release date, audience age, genre, sub-genre, style (animated, live-action, etc.), and format (e.g., where you watched it). You can also track the director, studio, and language.

Mark whether it’s a remake or a re-watch, and if it’s a re-watch, enter how many times you’ve watched it this year. This will calculate the total hours spent. If you’re a meticulous tracker, you can mark an entry as a re-watch for each viewing to capture all the statistics.

That’s the basic structure of the sheet, and you can adjust it as needed to suit your preferences.

Hiding columns

Click the downward arrow. For example, if you don’t care about tracking the studio, you can hide or delete that column. I recommend hiding it, given the extensive tracking capabilities of this spreadsheet.

These arrows are here for customization, but you don’t necessarily need to be concerned with them. If there’s something you don’t want to track, simply hide it.

After you’ve completed this information, you’ll have access to your Yearly Stats page, which is user-friendly and straightforward to navigate.

Yearly stats page

This page provides you with a comprehensive overview of your movie and show statistics in one place. The only section you need to edit on this page is your movie goal, which I’ve set up as a yearly target. For instance, if you plan to watch 50 movies in a year, simply input that number, and it will automatically break down your progress.

The page categorizes your goals, marking them as you achieve them. It further breaks down the number of movies and shows you’ve watched and the time you’ve spent watching. Additionally, it includes statistics related to series, remakes, re-watches, and diversity.

Within this section, you can find a list of all the genres you’ve watched, places where you’ve watched, style, format, language, audience, and star ratings. If you decide you don’t want to track a particular category, you can delete or clear the formatting.

It’s advisable not to move or delete elements on this page, as it’s intricately connected, and making changes here could affect other parts of the spreadsheet. The Yearly Stats page is also divided into movie stats, show stats, and, if you scroll further, details about directors, studios, and the number of times you’ve watched their works.

Owned library

This section is dedicated to the items you own. Here, you’ll input details like the title, release year, series name, series number, genre, whether you’ve watched it, your personal rating, the format in which you own it, and the location where you own it.

Over on the sidebar, you’ll find a summary that shows the percentage of items you’ve watched from your own library, the various formats you own, and the genres represented in your collection.

To watch list

This section is your comprehensive “To Watch List,” where you can keep track of upcoming releases and any new additions. For example, let’s consider “Barbie,” which is scheduled to be released this year. The status is marked as “To Be Released” since it hasn’t hit theaters or digital platforms yet and isn’t categorized as a new release.

You can also input details such as the release date, series name, series number, genre, format availability, and the potential location where you might watch it. Additionally, you can specify the item’s ownership status. For instance, you could pre-order it, or perhaps you’ve watched it and no longer want to keep it in your collection. At present, it remains under “Unreleased.” Once you’ve watched something from this list, it will automatically be grayed out for clarity.

Movie series tracker

In the “Movies and Series Tracker,” you can organize your movie and series information. This includes fields for the movie title, series title, the total number of entries in the series, whether or not you’ve watched it, the series status, the location where you watched it or where it’s stored, and the watch date.

Regarding the “Series Status,” it’s important to note that you don’t need to duplicate entries if, for example, you’ve watched all three Iron Man movies and marked them as “Completed” in the series status. The tracker will only count the series once in your “Total Series Completed” count, ensuring you don’t end up with any unusual numbers.

“Unfinished” signifies that you personally haven’t completed the series.
“Caught Up” indicates that you’ve watched everything currently available and are awaiting new releases.
“In Progress” means you’re actively working your way through the series.
“Not Started” is self-explanatory; you haven’t started watching the series.

Show series tracker

In the “Series Tracker” section, the setup is similar to the Series Tracker. You would input the series title on the side and, in a similar fashion, enter the season number and the total number of episodes for that season. As you mark off episodes as watched, the progression bar will automatically fill, and the percentage completion will also update accordingly.

It’s worth noting that the series tracker currently accommodates up to 25 episodes per season. If you’re dealing with a series that has more episodes in a season, you can consider a few options:

Divide It: For example, if you’re watching Season 5 but only half of it, you can label it as “Season 5 (Part 1)” or something similar.

Expand the Tracker: You can insert additional columns to the right to include more episode slots. However, please be aware that this tracker is set up for a specific number of episodes (up to 25), so you’ll need to adjust the labels accordingly.

Spending tracker

This section allows you to keep track of your expenditures. For example, you would input your spending details for each month. For instance, in January, you purchased Toy Story 3 digitally on Amazon for three dollars. You can also record your subscription costs. For instance, if you have a monthly Netflix subscription, you can mark it here. The digital purchase category accounts for individual digital movie or show purchases, while the subscription category is used for tracking ongoing subscription fees. Subscriptions will be totaled separately for the year. However, please note that subscriptions won’t be counted in the “Formats” section, as they are considered recurring expenses.

23 in 23

You can use this section to list the 23 movies or shows you intend to watch in 2023. You have the option to mark them as you go along. You can also specify where you plan to watch them and, once you’ve watched them, update the status.

If you need to make edits, you can click the “Edit” button. This is one of the few places in the spreadsheet where you’ll use the “Edit” button for selections. It opens a menu on the side where you can make changes.

To add an image, select the cell, go to “Insert,” and then choose “Image” and “Insert image in cell.” You can paste the image URL from Google to include it in the cell.

The spreadsheet keeps track of the total number of items you’ve watched as you mark them as “Watched.”

Selection edits

All these selections can be managed through drop-down menus. When you make changes here, they will automatically update across all other spreadsheets.

  • “Type” can be either “Movie” or “Show.” If you want to add more types, please note that it won’t affect the Yearly Stats, which tracks only these two categories.
  • The months are typically static, but if you have specific needs, you can adjust them.
  • The rating system is entirely customizable. You can modify the ratings to your preference, whether adding TV ratings or changing it to different age groups.
  • Genres can be customized by deleting those you don’t use, and you can rearrange them to your liking. Sub-genres, style, location, format, and language can all be adjusted as well.
  • The “Acquired From” category can be used for tracking spending and acquisitions. For example, you can add “Netflix” here.
  • If you wish to alphabetize these options for ease of use, highlight the column, go to “Data,” select “Sort Range,” and ensure you sort by the column, not the whole sheet. This will sort your selections alphabetically.
  • If you add more entries and the graphs aren’t updating, you might need to copy the format and paste it to the new entries. To copy a format, select the format you want to copy, then right-click and choose “Paste Special” and select “Format only.”
  • If you add more entries than originally existed and notice something isn’t being tracked, check the graphs. You can edit the graphs to adjust the range it’s tracking.
  • Customizing colors and themes for graphs can be done through the “Customize” option for pie charts, allowing you to choose the colors that suit your preference.

Changing color

You can customize all the colors on the entire spreadsheet by adjusting them here. If you’re not satisfied with the default colors, you have the freedom to change them to your liking.

In summary, that covers the Movie Tracker. It may not be as detailed as the Reading Tracker, but it’s meant to serve as a starting point. I searched for similar tools, and there didn’t seem to be many available. I’m glad to provide something that might be useful, and I’m open to suggestions for future improvements. This version is for this year, but I typically release an updated spreadsheet at the start of each year, and I’ll incorporate this one into the rotation. If you have any ideas or suggestions, please feel free to share them.

You can find the link to the Etsy store below. Be sure to explore the Movie and Show Spreadsheet Tracker, which is distinct from the Reading Tracker. Thank you very much for your support, and I hope this resource proves helpful.

Leave a Comment

Your email address will not be published. Required fields are marked *

Shopping Basket
Scroll to Top