Setting and Tracking Writing Goals (with downloadable Excel sheet)

New Courageous Writing posts will be shared every other Wednesdaywhich include book reviews, writing inspiration, and writing tips.

Setting writing goals 

Setting daily word count goals has helped me tremendously over the years, particularly when writing my MFA thesis. These goals made my writing time more focused, and tracking those goals made the end of my writing time more satisfying.

Making writing goals can be tricky. You can focus on word count or time or both.

Time Goals for Writing

An time goal can help you focus more on the time you spend rather than on the word count. That way you can achieve your goal even if you haven’t written a word. At least you spent time thinking about, planning, or researching for your book. I like this method, especially because some days I really can’t write. For instance, the other day I stopped writing to outline instead. Other days, I may be editing or brainstorming.

Word Count Goals for Writing

Word count goals are more specific, which is often what I need. I like knowing that, at the end of the month, I’ll have written a certain number of words. It also pushes me to write faster and more often even when I don’t “feel like it” or can’t write a pretty sentence. I tend to be perfectionistic about the prose, so having the writing goal forces me to get the draft out no matter how bad it is that first time. It turns off my internal editor so that I can keep going. 

The important thing to me is that I work on my book everyday to keep up my momentum. If I plan too long without writing, I lose my momentum, and then I have to just start writing again, knowing I can always fix it in post.

That said, I like to set word-count goals but remain forgiving if I can’t write on a particular day. That’s why I also set weekly goals. If I miss a day, or I work on planning or revising instead, I can make up for the words later in the week and still reach my goal. 

Start with practical goals

I like to start simply, especially if I’ve taken a long writing break. 300 words a day is usually doable no matter how busy I am, but even 100 words will get me to sit down and focus on my book for a little while. 

Because I’m a teacher and don’t work in the summers, my daily goal last summer was 1500 words, though sometimes I wrote far more or far less. 

2000 words is a good goal if you have the time. Stephen King and Brandon Sanderson shoot for this, King noting in On Writing that he can draft a novel in three months at this pace, though this depends on the total word count you’re shooting for. Last summer, I was able to draft almost 30,000 of a middle-grade novel in 4 weeks with an average of 1300 words a day. Those words need a lot of revision, but, hey, you can’t fix what doesn’t exist yet.

Tracking Goals 

You can track your goals however you like. Most word processors, and even Scrivener (my preferred software), show word counts. 

I personally like tracking my words each day in an Excel sheet with automatic calculators. To me, this gamifies the tracking process, giving me a boost of serotonin when I input my words and see all the numbers go up on the page. 

Below is how my Excel sheet looked after 4 weeks of writing. 

Again, my goal was 1500 a week, and you can see where I failed to reach that on some days but exceeded it on others. Most weeks I had reached my weekly goal of 7500 (or come close to it–again, have some grace for yourself when you can’t reach the goal). All those numbers are calculated at the bottom to show my total since I started using the sheet added to what I started with for my grand total. 

It may sound silly, but this Excel sheet actually helps motivate me to plug in my numbers every day. 

Download Excel Word-Count Tracker

If you want a copy of the spreadsheet I’ve made for myself with all of the calculations already set up, you can download it below! It is currently set up for 1500 words per day for twenty weeks. You can adjust the word count goal, then simply type in your words each day. 

Let me know how it works for you!


One response to “Setting and Tracking Writing Goals (with downloadable Excel sheet)”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s