New Year, New Word Log

WWord Log screenshot
ith the coming of each new year, I start things off by creating a new Excel spreadsheet to serve as my daily and monthly word log (as seen by my screenshot taken a couple weeks ago.) It is a place for me to keep track of my progress on a daily and monthly basis. I am no expert on the program Excel by any means, but I found that using the SUM function to be very helpful. I have seen several word logs made by others, some which you can download to use. And while some are very impressive, I wanted a spreadsheet that was very basic in design yet allowed me to keep track of all of my month’s activities.

Keeping track of words is a somewhat grey topic. As David Hewson pointed out in his blog entry The dangers of the daily word count, progress on your novel is not necessarily just adding words every day. What of editing, omitting chunks of text that is ruining your story, or just rewriting a scene or entire chapter? Those are all very important, and sometimes I personally feel some writers get so deep into the task of writing that they don’t realize working on one’s novel can entail all the other things I just mentioned, and so much more.

Nonetheless, I do find word logs to be one of the easier means for me to keep track of my progress. Going back to the screenshot, this is roughly how I have things set up:

  • The days are split by month. Everything written in January will be summed up as the total amount written during that month, everything for February, and so on and so forth. Then at the bottom of the entry is the grand sum of everything I wrote for that year. In the cells I input the total amount I wrote for that day, so I have to keep track of my activities and have a calculator nearby. The monthly and yearly total is automatically recalculated every time I edit a cell.
  • I have a daily goal that I try to meet. If I don’t write that amount I don’t cry over it. Instead I look through the notes to see what I did each day. If I spent one day working out a nasty little plot hole and succeeded, then that is as much a victory as it is writing 10,000 words a day (have not achieved that yet. The most I ever wrote was roughly 8,000 words.)
  • The section in red next to each day is where I jot down notes on what I have done. This section is usually that part that takes up the bulk in other Excel word logs I’ve seen. Here I jot down notes of what I was writing and how much I wrote for each area. I may write in what I did that day if it was not taken up by just writing prose. This was especially helpful while attending professional school, where I could easily go for weeks without touching my works-in-progress. If I looked at the very low word count for that month and felt terrible, I can look at my notes and realize that I accomplished a lot by, say, honing the outline and character motivations. That’s something big to have accomplished.
  • The entire window is compressed so that it occupies just a small portion of my screen, allowing me to write and do other work while also having the word log in my eyesight. I do this as a means of motivating myself.

And so this is a small part of how I work. It is not perfect by any means, but I have found it helpful. Over the years the word log has changed as I figure out better ways to set the thing up.

I now turn this discussion to all who are reading this: how do you keep track of your writing progress? Do you even keep track or do you prefer just diving into the insane and blissful task of creating? Do you think a word count is the only possible way of keeping track of your progress or have you found other ways (and if so, please share!)


They say the journey is more beautiful than the destination, yet rarely do we celebrate that journey when we find a novel, the final product, on a shelf in a bookstore. What led us to this stage? What have we seen and learned along the way before the book was ever brought to a publisher?

Every writer’s journey is different. Some will have tales to inspire you, and others stories from which you can learn. The inspiration for creating this blog came from the many years of reading the lives of other writers, both published and budding writers like myself. What experiences have we gone through? What have we learned from this or that incidence? What were the struggles and the victories, from both our personal lives and from topics arising from our works? These things I wish to share, coming from my own personal experiences. I have been on a quest of creating a vast fictional universe with its own self-contained mythology, and as one can imagine, many things have come up that I’ve had to mull over till my brain leaked from my ears. This blog is by no means a teaching tool, because I don’t think people can be taught to write (other than the advice of “practice!”) But perhaps others can gain a little something from my journey, as I have done from countless of others.

Welcome to my Journey.

Lórien May