Year-round word trackers

Word tracking spreadsheets for 2020! I make new ones every year and this page will be updated accordingly.

Instructions are included and sample screenshots are further down the page. You’re welcome to edit and share these, but please don’t use the images for anything else. They’re all made with my own artwork.

If you’re looking for a spreadsheet to track individual projects or shorter time frames, I now have a project tracker available as well!

All the spreadsheets are available for free. If you don’t want to pay, you can just put in “0” in the price field and you won’t be asked for any payment info. If you want to give back, please check out my art shop or sharing the link to this page with others who might be interested, or donate directly via PayPal or Ko-Fi. Your support is what keeps this page going – thank you so much!

Click on the preview images or the links below to download each sheet!


preview pr-batb preview-fairy   pr-if  preview-lights-of-hope preview-mermaid preview-lights pr-pl  pr-stardust preview-starlight preview-steampunk  

Multiple Designs


preview-a&d preview-spn


preview-aragorn Preview-Gandalf preview thorin


preview-bucky Preview-Loki preview-groot preview-peggy Preview-Thor pr-ww 


preview-ben preview-endor preview-frasers pr-malec 

I do take requests for custom designs, but every hour I spend on these is an hour I should really be spending on my actual work, so I’m only doing custom requests for folks who donate. That said, if you have an idea for a feature or you’d like to see a specific artwork of mine featured, feel free to let me know!


previous arrow
next arrow
previous arrownext arrow

Troubleshooting & FAQ


  • I’m getting a “drawing conversion failed” error and the images aren’t showing up!
    There are two versions of each tracker; try the .xlsx file, that should work.
  • Can you make a version that’ll work on a Mac?
    I don’t own a Mac, so, no. I’m told by people with Macs that these work for them, but your mileage may vary.
  • I don’t know how to use Excel.
    Google “how to use Excel”, the internet is very helpful.
  • I edited stuff I shouldn’t have and now it’s broken, help!
    Your best bet is probably to re-download the file and start over.
  • I’ve found a bug in the code.
    Please contact me and I’ll fix it!
  • Can you make a version that people can view my blog?
    It’s an Excel file, so that won’t work. You can always upload it to Google Docs and link to it, or post screenshots.
  • Can you make a tracker for a few months, or a specific month?
    I did! It’s here if you want to check it out. Alternatively, you can set the custom word count for all the months you DON’T want to track to 0, and you’re set.
  • Will you make new ones for next year?

New in 2020: a spreadsheet specifically for developing characters & plot! If you’re struggling to figure out what your story is about or who your characters are, check it out!

Follow me on Twitter for updates about spreadsheets, other resources, and my art!

If you’d like to donate to help out with running costs of this site, here’s my tip jar, or use the button below. Every little helps, literally – thank you very much!

51 comments on “Year-round word trackers

  1. These are amazing! I’d love to see a Firefly one for 2019. :)

  2. Can your spreadsheets be used for tracking multiple projects? I’m currently outlining two new novels and then revising my first. Thank you!

  3. Hi.

    I downloaded this at the beginning of the month after using it at the end of last year, and I was/am super excited to use it for the entirety of 2018.

    I thought someone else would point out this issue, but I have not seen anything posted here and have re-downloaded a few times just in case you updated the files (to no avail).

    Both in the downloaded spreadsheets and your preview shots, the Yearly Word Tracker’s “Date” column shows 2017 instead of 2018. This is true in not only January, but in every other month, as well. Now this wouldn’t be such an issue if I knew how to change it myself, but I’m absolutely useless in Excel, so I’m posting here in hopes that I might be able to procure a fixed version.

    Thanks for your time!

    1. Hi!

      That’s odd – I just looked, and they show 2018 for me. (I’m using last year’s preview shots, because nothing really changed and I was lazy, that’s why those say 2017.) Which design are you using? Maybe I missed one.

      If you want to email it to me, I can fix it for you and send it back. You should be able to just reply to the confirmation email you got from Gumroad, and reach me that way :) You can also try fixing it yourself, if you go to the January sheet, select the very first date cell (C11) and just change it to say 1/1/2018. But yeah, if you could please let me know which design you’re using so I can fix it and upload the corrected version, that’d be great. Thanks!

    2. Hello! Thank you for your quick response.

      I did not realize it was such an easy fix. Sorry to have made a such a long comment about a trivial issue that can be fixed in one click. The design I am using is the default one, but I looked again, and you’re right. It is correct. I’m not sure exactly what happened, now. Maybe I changed it on my own somehow (as I said, I’m horrible at Excel and wouldn’t put it past me, haha).

      Thank you for all the hard work you do, and I’m seriously so pumped now that I’ve got a working version! Thank you so much for your help! :)

      P.S. I understand why you would use last year’s pictures; I wasn’t sure if it was intentional or not.

  4. Is there going to be a Beauty and the Beast version this year? Gumroad says it’s not currently on sale.

    1. I… actually have no idea why it wasn’t available. Sorry! It should work now! :)

    2. No problem. Glad I asked. There are so many options to choose from but that was my favorite. Thank you for the quick response and the beautiful art.

  5. Hey. Happy New Year to you and thanks for the amazing trackers I’ve been using for years. Do you think you could make a Thorin design? I like Kili, but I love Thorin (and Bard, but that’s pushing it, lol). Thanks.

    1. Hi! Happy New Year to you too. I can indeed make a Thorin design, yep! I’ll try to get it done today. I don’t have any Bard art I can use alas, but Thorin should be no problem! Thank you!

    2. THANK YOU! I downloaded and donated (the name is different). Just so you know, the link higher at the page, leads to Kili tracker. And thanks again.

    3. Thank you so much for the support, and for pointing out the link issue – I’ve fixed it now :) Cheers!

Comments are closed.