NaNoWriMo 2012 word trackers

This spreadsheet features a wordcount tracker, progress chart, pages for filling in novel info, characters, and chapters, as well as character and plot development sheets. It’s designed for NaNoWriMo (National Novel Writing Month) 2012, but with a little tweaking you can use it any time.

It’s an Excel spreadsheet; if you’re using a Mac, you might need to adapt/convert it. This is the basic design which is available in two versions, one which works by daily wordcount, and another which works by total wordcount.

The regular (daily count) tracker also comes in other colours and designs. These are last year’s, updated for 2012. Click on the thumbnails to see the full preview, and use the links below to download each.


This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 License. You’re free to change, edit, and share these, but please remember to give credit. All images used are my own, and they are copyrighted, not to be used for anything outside of these spreadsheets.

42 comments on “NaNoWriMo 2012 word trackers

  1. Is there a way to donate? I read your plot and character examples, and they were hilarious! Ring Wars I: Lord of the Stars, indeed! It’s also clear you’ve put a lot of work into these, not just the word counter, but also the artwork, the number of different pages, and so on. I never thought of a spreadsheet as a piece of art before.

    • Wow, thanks! This made me smile. :) If you want to donate, I’ve just put up a donation button in the sidebar! :) In any case, I’m really glad that you like the spreadsheet, and best of luck with NaNo!

  2. Wow, these are amazing! I really like when things are organized and pretty, it gives me more motivation for some reason! Thanks for these! :)

  3. Thanks so much. I’m attempting to write a novel this month and although the software I’m using covers your spreadsheet, I love it and may use it any way. I will be sharing your site with other writers if that’s okay. Thanks again, this is brilliant!

  4. Thank you so much for this! Was looking for a word tracker with custom word count. All of the extra features are an unexpected bonus.
    Now, I just have to figure out how to alter the dates for December…

    • No problem! Best of luck with NaNo. Altering the dates is pretty straightforward actually, you just have to change the date for day 1 and it’ll adjust the rest. But I’ll probably put a “Novel-finishing month” version of these trackers up at the end of November anyway, which will take what you’ve already written into account. :)

  5. This is amazing. I like to think I’m pretty good with Excel, but this is incredible.

    I was worrying because I couldn’t start NaNo this year right on time, so I wanted to give myself a different time frame (still 30 days) to finish. This is perfect because I still get to see the fancy bar graph and everything is there to keep me on track. Plus ALL the other information you’ve jammed into this. I can’t wait to start using it.

    • I’m glad you like it! If you want to change the time all you have to do is change the first date in that column. :) Good luck with your writing!

  6. I have been using your spreadsheet for NaNo this year and I’m totally in love with it! Do you have any advice on how to make one up for longer projects or for year-round writing? I tried saving your spreadsheet as a new document and adding a starting amount of 50k (for example) on Day 1 but it messes up all of the stats and estimated completion dates. Any suggestions or referrals are appreciated. Thanks for all the hard work creating these beautiful tools. :)

    • Well, first off, I’m glad you like this! And I actually have a year-round spreadsheet, too. I don’t have the link handy right now, but it’s posted on my blog. You can use it year-round or just for a few months. I’ll be posting an updated version for 2013 sometime in December so just keep an eye out for that. :)

  7. Ah, this is so awesome! I was searching the Internet forever for a good word count tracking system that shows where you need to be and since I have no idea how to format Excel, this is a lifesaver.

    You. Are. Awesome.

  8. Your spreadsheets are beautiful. I’m going to try the yearly wordcount one to keep me going now that Nano 2012 is over. Thanks so much for making them available.

  9. I downloaded the excel nanowrimo word tracker that has the capability to develop and record plot and character details. I read the first page with the instructions on how each section works, but I don’t have a clue how to get into them.

    I’ve never used excel before because I didn’t know how. If I click on the headings of the information list, nothing happens except the cursor is a little ‘cross’. How do I get into the different sections?

    Bonnie j. Eaton

    • If you look at the very bottom of the window, you should see coloured tabs with “Instructions”, “Word Tracker” etc written on them. If you look at the preview image in this post, they’re at the very bottom of the image. That’s what you need to click on, not the headings.

      Can you find those?

  10. Thank you! I am not doing NaNoWriMo but I working on my second book. I have set some goals for myself but I am having issues keeping track of them. I tried to make something like this myself, but honestly, I am not so talented at things like this. I am excited to try this out!

    • No problem! I hope it works for you. I made it for NaNo, but it’ll work for any 30-day period, just the dates will be wrong and the progress bar at the top probably won’t won’t work either. I do have a year-round spreadsheet as well, where you can pick out months or whatever. But anyway, I hope it’s helpful for you, and thanks for the feedback! :)

  11. Hi! I love this spreadsheet, but I can’t open it! It’s downloaded as .rar, but I don’t know what program opens it. It says Error everytime I try :( Is there any way you can send it to me by email?
    Thanks a lot, your work is wonderful!
    (Yeah, I know NaNo is in November, I just want to use it in December).

Leave a Reply

Your email address will not be published. Required fields are marked *


Comments are moderated, so it might take a few hours for your comment to appear.