Yearly word tracker spreadsheets

Word tracking spreadsheets for 2018! I make new ones every year and this page will be updated accordingly. Here’s some previews – download links are further down the page. If for some reason the image links don’t work, there’s a handy text list below them!

Arrow
Arrow
ArrowArrow
Slider

Instructions are included. 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, so please respect copyright and all that.

New for 2018: you can now set the form to adjust monthly goals based on how many words you’ve written, if that works better for you! It’s an option on the summary page, and you can turn it on or off at any point throughout the year.

Bug fix: The “March” sheet wasn’t tallying the total words correctly.You can download a fixed version of the file, or alternatively, to fix the one you have, just paste this exactly as-is into cell O11:

=IF(C11<=TODAY(),SUM(Summary!F11:F12)+I11,"")

They’re hosted on Gumroad, but you can just put in “0” in the price field if you don’t want to pay and you won’t be asked for any payment info! If you want to give back, please consider checking out my art shop or sharing the link to this page with others who might be interested. You can also make a donation using the buttons at the bottom of the page! Your support is what keeps this page going – thank you so much!

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

Click on the preview images to download each sheet!

Art

preview pr-batbpreview-fairy pr-hp pr-if Preview-Lament preview-lights-of-hope preview-mermaid preview-lights pr-pl pr-stardust preview-starlight preview-steampunk pr-w

Multiple Designs

2018-art

Supernatural

preview-a&d preview-spn

Tolkien

preview-aragorn Preview-Gandalf Preview-Kili preview thorin

Once Upon A Time / Fairytales

preview-eq preview-hook-1 preview-into-the-woods preview-rumple

Superheroes

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

Miscellaneous

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

I 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 give preference to folks who donate. Either way, though, request away!

Text links

Troubleshooting & FAQ

  • I’ve found a bug in the code.
    Please contact me and I’ll fix it!
  • 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.
    Here you go!
  • I edited stuff I shouldn’t have and now it’s broken, help!
    Re-download and start over.
  • 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?
    Yes.

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

If you’d like to help out with running costs of this site and enable me to keep making these, you can donate directly via PayPal or Ko-Fi, or pay whatever you like on Gumroad. Thanks a million for the support!