Setting and Tracking Writing Goals (with downloadable Excel sheet)

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. An hourly 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 plan instead.

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 be 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 am currently not teaching any classes, I have a lot of time on my hands, so my current daily goal is 1500 words, though sometimes I write 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. Right now, I’m writing a middle grade book, and I was able to draft almost 30,000 words in 4 weeks with an average of 1300 words a day.

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 looks after 4 weeks.

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 have reached my weekly goal of 7500 (or came 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!


Published by emilybrooks93

I write about anxiety, faith, and writing

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 )

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s

Create your website with WordPress.com
Get started
%d bloggers like this: