2026 Word Tracking Spreadsheet

For those who have used it before, the 2026 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:

This year we are not going into or out of a leap year, so there should be no bugs. I also happened to discover a bug in the annual stats rollup page that slipped past everything last year, and fixed that. Yay for stomping bugs! Sorry it slipped through before...

Sharing this spreadsheet continues to be a bit bittersweet for me, as this was another year where I struggled to write new words, whether they were fic, original, or blogs. I had my ups and downs, and at times, seemed to disappear completely. However, I did do a lot of editing, and am excited to be incredibly close to being done with that major push soon.

Again, there are no changes other than the dates being updated to 2026, and the additional columns for 2026 added to stats, and the dynamic 2025 columns being moved to static information. All charts should be updated correctly.

I do want to add tracking for project rollups (what kind of work was done), better tracking for time, and figure out a way to get a better view of the time I do spend on not just writing, but writing related tasks. However, I haven't managed to figure out how to chart it, so those aren't yet in the publicly shared sheet. Someday, I hope.

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.