CruxOne — the all-in-one AI platform for authors

Novel Word Count Tracker: Free Spreadsheet Template for a 30-Day Challenge (2026 Guide)

9 min read · Updated October 2026

If you are about to start a 30-day novel challenge, a simple tracker can do more for your finish line than any amount of willpower. Seeing your total climb each day, and seeing exactly how far behind or ahead you are, turns a vague ambition into a daily number you can hit. This guide shows you how to build a word count tracker spreadsheet from scratch in Google Sheets or Excel, which columns and formulas to use, how to set a realistic target, how to handle the days you miss, and how to keep the sheet useful instead of stressful. You can build it in about ten minutes, and nothing here needs paid software.

Why use a spreadsheet to track your novel word count?

A spreadsheet gives you three things a notebook or a writing app counter does not: a running total, a comparison against where you should be, and a record you can look back on. The comparison matters most. Knowing you wrote 1,200 words today is pleasant. Knowing you are 800 words ahead of schedule, or 2,000 behind, tells you what tomorrow needs to look like.

It also costs nothing and works anywhere. Google Sheets runs in a browser and syncs across devices, so you can update it from your phone after a session. Excel and LibreOffice Calc work just as well if you prefer to keep files on your own computer.

The trade-off is that a spreadsheet only records what you type into it. It will not count words for you, so you need a word count from your writing software at the end of each session. That is a thirty-second habit, and it is the only manual step.

What columns does a novel word count tracker need?

Keep the sheet small. Every extra column is one more thing to fill in on a tired evening. Seven columns cover everything most writers need:

  • Day number: 1 to 30, down the first column.
  • Date: the calendar date for each day, which helps if you want to plan around busy evenings or weekends.
  • Daily target: the number of words you plan to write that day.
  • Words written today: the only figure you type in every day.
  • Total so far: a running total of everything written to date.
  • Target total: where your running total should be by the end of that day.
  • Difference: your total minus the target total, so a positive number means ahead and a negative number means behind.

If you want one optional extra, add a notes column for a few words on what got in the way or what worked. Over a month, those notes show patterns you would otherwise forget.

Which formulas make the spreadsheet work?

Only a few formulas are needed, and they work the same way in Google Sheets and Excel. Assume your headers are in row 1 and Day 1 is in row 2, with columns A to G in the order listed above.

  • Total so far, in E2: =SUM(D$2:D2). Fill this down to row 31 and it adds up everything written to date.
  • Target total, in F2: =SUM(C$2:C2). This accumulates your planned targets in the same way.
  • Difference, in G2: =E2-F2. Fill down as well.

Add a small summary block above or beside the table. A cell for your final goal, a cell for words remaining (goal minus your latest total), and a cell for days remaining let you calculate what you need per day from now on. Words remaining divided by days remaining gives a fresh daily figure that adjusts as you fall behind or pull ahead.

Finally, apply conditional formatting to the Difference column. Color negative numbers a soft red and positive numbers a soft green. It is a small touch, but it lets you read the sheet at a glance.

How do you set a realistic daily target?

Start from your goal and divide. The widely used challenge goal is 50,000 words over 30 days, which works out at about 1,667 words a day, so many writers round up to 1,700 to leave a little slack. If your goal is different, because you are writing a novella or have less time, divide your own number by the days you can actually write. The Words Per Day Calculator will do that sum, including for goals that are not round numbers.

Be honest about your calendar before you commit. If you know you cannot write on certain days, set those targets to zero and raise the others. A flat target across all 30 days looks tidy but ignores real life, and a sheet that is red from day four is demoralising. Remember that 50,000 words is a draft target for a short novel, and that many genres run longer, so treat the month as a strong first draft rather than a finished book.

Also think about time, not just words. If you write around 500 to 1,000 words an hour, a figure that varies enormously between writers, you can estimate the hours you need and block them out. Use your own pace from the first few days rather than anyone else’s average.

What should you do when you fall behind?

Everyone does at some point. The sheet makes the problem visible early, which is its great advantage. When the Difference column goes negative, you have three honest options: spread the shortfall over the remaining days, add one or two bigger sessions on days when you have more time, or lower the final goal to something you can reach.

Spreading is usually best for small gaps. If you are 1,000 words behind with ten days left, that is 100 extra words a day, which is barely noticeable. Large gaps are better tackled with a weekend catch-up session, because small daily additions add up to a heavy load when the gap is big.

Do not rewrite the target total to hide a bad week, and do not abandon the sheet. The point is information, not judgment. If you hit a creative wall rather than a time problem, the guides on writer’s block and on building a writing habit have practical fixes, and a quick pep talk or writing prompt can get you moving again.

How can you keep the tracker motivating?

Update it at the same time every day, ideally straight after you finish writing, while the number is fresh. Count words from your manuscript total rather than adding session figures by hand, then subtract yesterday’s total to get today’s words. That avoids arithmetic slips.

Add a simple chart if you enjoy visuals. A line chart with your running total against the target total shows the gap clearly, and watching your line pull level with the target is a real boost. Keep it simple, with two lines and clear labels.

Resist the urge to measure quality with the same sheet. A fast first draft will be rough, and that is fine. Word count tracks progress, not polish, and the revising happens afterwards. Many writers also find it helpful to share their total with a writing friend or an online group, which adds light accountability without pressure.

What should you track after the 30 days end?

Keep the sheet. Once the month is over, you have a record of your real pace, your best and worst days and the times you wrote most easily. That is useful data for planning your next book and for estimating a realistic publication schedule.

Next, work out what the draft needs. Convert your total into approximate pages with the Word Count to Page Count Converter, compare it with typical lengths for your genre, and decide whether you are finished or still have scenes to write. Then plan your revision, which is a separate project with its own timetable.

If you want one place for the rest of the journey, CruxOne is a browser-based AI publishing platform for indie authors that covers writing, editing, formatting and publishing, with a free plan to try. Whatever tools you use, put your finished draft away for a short while before you revise it, and keep your tracker habit going for the next project.

Frequently asked questions

What is a good daily word count for a 50,000-word challenge?

About 1,667 words a day over 30 days. Many writers aim for roughly 1,700 to leave a small buffer for missed days.

Can I use Google Sheets instead of Excel?

Yes. The formulas in this guide work in both, and Google Sheets has the advantage of syncing across your phone and computer.

Does the spreadsheet count my words automatically?

No. You enter your total from your writing software or word processor each day, and the sheet calculates everything else.

What if I miss several days in a row?

Keep the original target visible, then spread the shortfall over the remaining days or add a longer catch-up session. If the gap is too big, adjust your final goal.

Is 50,000 words a full novel?

It is a short novel or a solid first draft. Many genres run longer, so you may need further drafting after the 30 days.

Related