The NaNoWriMo Tracking Spreadsheet – 2009 Edition

Returning with a colourful visual refresh this year is my much loved NaNoWriMo tracking spreadsheet!

Its features include:

  • Automatic calculation of your word count for the day, words per minute and total remaining word count.
  • Automatic formatting indicates your progress towards the daily 1667 words target. (And bonus colours if you reach 5000!)
  • Smart charts showing your word counts, typing speed and overall progress.
  • Sheets are protected to prevent accidental changes to automatic cells, but can be unlocked to customise the sheet and targets.

Spreadsheet View

Progress PieWord Count Typing Speed

I recommend that you download the version for Microsoft Office Excel 2007:Download Office Open XML Excel Workbook

If you have an older version of Office (XP or 2003) and can not open this file, please use this version instead:

Download legacy Excel Workbook

Tags: , ,


  1. Gab says:

    Very nice! Thank you so much, Nido. :)

  2. Leah Marie says:

    Just downloaded this and its freaking awesome. Thank you so much.

  3. Sean Hoade says:

    This is SOOOOO very awesome! Thank you for contributing this priceless widget, seriously.

  4. Stephanie Marie says:

    Very cool. Very helpful. You’re a lover.