Hey fellow fanfic lovers! I’ve updated my spreadsheet for tracking fanfiction reading in 2025. It’s super easy to use. You just fill in the Log tab with info about the fics you read. The rest of the stats are calculated automatically.
Here are some cool features:
Yearly summary that creates your ‘ideal’ story based on your reading trends
Track characters, relationships, and tags
See your monthly and yearly word counts
Find out which categories, ratings, and fandoms you read most
Discover your favorite authors based on how much you’ve read from them
Space for notes on each fic
The spreadsheet is set up for AO3 but you can tweak it for other sites too. I’ve added notes to help you navigate, but feel free to ask if you need help.
To use it, just make a copy of the spreadsheet for yourself. Have fun tracking your fanfic adventures!
This spreadsheet sounds like an excellent tool for organizing fanfiction reading habits. I’ve experimented with similar trackers in the past, but none as comprehensive as this one. The yearly summary feature, in particular, seems quite innovative. Have you considered adding a section for tracking reading time? That could provide insights into reading speed across different fandoms or genres. Additionally, a feature to flag stories for later rereading might be useful. Overall, this appears to be a well-thought-out system that could significantly enhance the fanfiction reading experience. Thank you for sharing your hard work with the community.
I’ve been using a similar spreadsheet for a couple years now, and it’s been a game-changer for my fanfic reading. One thing I’ve found really helpful is adding a column for ‘mood’ or ‘emotional impact’. It’s interesting to see patterns in what kind of stories hit me the hardest emotionally.
Another tip: I color-code my entries based on whether I finished the fic or dropped it partway through. Makes it easy to spot abandoned works at a glance.
For anyone on the fence about using a tracker like this - just do it. You’ll be surprised how much you learn about your own reading habits. Plus, it’s great for finding old favorites when you want to reread something but can’t remember the title.
omg this is awesome! ive been looking for something like this for ages. do u think it would work for wattpad fics too? i read a ton there and would love to track those. thx for sharing, gonna try it out tonight!