Writing Spreadsheets for 2017 (freebies for writers).

As many of my followers will know, I really like planning and tracking data. This year I’ve been using a very complicated spreadsheet to manage my writing projects. I’m not aware of one with similar scope out there, so I thought I’d offer up the 2017 version for others.

The sheet tracks ten projects across four aspects–wordcount, pages edited, research time and marketing time. There is a simple instruction page included, but once you’ve set up your first project, it’s fairly self-explanatory.

Screenshots of bits of last year’s below to give you an idea of what to expect. Links to download the excel sheets from Dropbox are at the bottom (sheets are saved as .xlsx, which should work in OpenOffice variants too. If you need another format, message me). Any questions or queries, drop me a comment. Hopefully, some of you will get some use out of these.


Projects Page (top row)


Yearly progress tracking (yes, I fail at marketing)


Example of a monthly tracking page

I’ve had a go at different colour schemes (they don’t look right in the Dropbox preview but what you see below is what you should get once they’re downloaded):






ETA: If you downloaded one of these before January 1st, monthly research and marketing targets will not be calculated correctly. The problem is now fixed.


This entry was posted in writing. Bookmark the permalink.

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