2025 Word Tracking Spreadsheet
For those who have used it before, the 2025 Word Tracking Spreadsheet is now available!
For those who have no idea what I’m talking about, the annual word tracking spreadsheet is a robust Excel sheet (it can be used in Google Sheets or other programs that are able to read .xlsx files) which allows you to track your wordcount goals and actual achieved wordcount across several projects. There are graphs, time tracking, and many little bells and whistles.
This is a spreadsheet I created for myself back in 2012 and I’ve been changing it bit by bit as I discover new things I want to track, or ways to motivate myself. I can’t remember exactly when I started sharing it publicly, but I’m happy to share the blank spreadsheet each year.
Both the spreadsheet and an instruction document are available via Google Drive:
Fingers crossed that I haven’t missed any bugs this time around! (Long time users know that going into and out of a leap year has traditionally been a time for me to make mistakes as adding/removing a day changes so many formulas!)
Sharing it is a little bittersweet for me this year. I barely used my own; I haven’t even looked to see how many words I officially made as of when I am typing this up. My relationship with writing is a tad bit complicated at the moment, and while I hope to uncomplicate it somewhat by the end of the year, that hasn’t happened yet.
There haven’t been any changes since last year other than the dates. I was playing with some new changes in my own file, but they aren’t ready for prime time, so if I can actually WRITE in 2025, maybe I can get those sorted out (ways to group projects to track them at a higher level, like blogging vs novels vs fics, etc.).
Please feel free to signal boost this post and share the file. If you make changes to the file and share it, please credit mine as the inspiration.
As happens every time we go into and out of a leap year, I managed to mess up a formula. It didn't show up in testing, but was spotted in the wild. The sheet has been re-saved and is corrected.
(For Excel nerds who are curious: In order to avoid screwing up formulas, I copied information from the 2023 sheet which was prior to leap year. Smart, right? I told it not to link the sheets. It still... tried to link the sheets. I broke the links now.)
It is the season! the AMAZING word tracking spreadsheet by @tryslora
2024 was a disaster for me, writing wise. Here is hoping that 2025 is better!
Happy New Year everyone!