Free Word Count Spreadsheet for Writers

Because I missed NaNoWriMo this year, I decided to set myself a goal of writing 1,000 words per day for January. Any words. Just to get back into the habit of writing. I was always encouraged by the NaNoWriMo Word Count graph, so I made one in Excel and made it available for you. [NOTE: This is a new, updated version using Excel’s conditional formatting to create a dynamic bar graph that changes with each day’s word count.]

• Download graph to your desktop. Open, Save As, rename.
• Add your first day’s word count to Orange Daily Word Count Row and Month To Date will update. [NEW: The new spreadsheet will show a bar graph to the right. Huzzah!]
• Place your daily word count in the previously filled in days 1-8 in the example.
• Next month, copy this sheet, and zero-out the days.
• Make your own goal. In this file, 1,000 words per day was my goal. Put whatever goal you are looking for in the final row’s Month to date.

If you like this free download, leave me a reply, below. Thanks, and write like the wind!

– – – – – – – – – – – – – – – – –

[Unfortunately, this graph’s functions do not translate over to Open Office.)