Anime Tracker - Google Sheets

Most anime fans do not have a memory problem. They have a tracking problem. You watch dozens of series across Crunchyroll, Netflix, and Hulu, and the details blur together because nothing is written down. This Google Sheets anime tracker spreadsheet gives you one place to log everything, across 8 tabs, so you stop losing track of what you have watched and what you thought about it.

You forget which shows you finished and which ones you dropped. The Shows tab fixes that. Log up to 500 anime series with fields for country, genre, sub-genre, year, seasons, episode count, average episode duration, platform, and watch status. Each entry gets its own photo. Rate every title across five categories: overall, story, characters, animation, and music. A rewatch potential field lets you flag the ones worth coming back to.

You binge a great season but cannot remember standout episodes a month later. The Episodes tab solves that. Track up to 500 individual episodes with show name, episode number, title, photo, and your personal rating. The Characters tab pairs with it, linking characters back to their shows with fields for photo, interest level, gender, and notes. Every side character who stole a scene stays on record.

Your taste diverges from the critics, but you have no easy way to compare. The Critic Ratings tab handles it. Log ratings from IMDB, Crunchyroll, and Google alongside each show, with fields for rating, max rating, percentage score, rating type, and a direct site URL. See exactly where you agree with the consensus and where you do not.

You watch plenty but have no sense of how much. The Journal tab tracks daily viewing sessions by date, show, platform, and minutes watched. Set a weekly goal in minutes and a monthly goal in hours, then check whether you hit them. A line chart shows your progress over the past week.

Raw data only goes so far without a summary. The Dashboard tab pulls it all together visually. Bar charts cover your watch status breakdown, your top-rated shows, and critic top-rated shows. A pie chart shows which series have critic ratings. Stat cards display total shows tracked, shows completed, episodes tracked, total time spent watching, characters tracked, and shows currently watching. The Setup tab lets you customize the genre list to match what you actually watch.

This is a spreadsheet you own. No account, no subscription, no data on someone else’s server. The purchase includes Google Sheets, Excel, and Notion versions. The design is protected so you will not break a formula, but it is fully editable where it counts.