Spreadsheets as a Writer

Hi friends! Today I'm talking about being the meticulous writer that I am, and talking all about spreadsheets. I am someone who typically doesn't organize my writing in a strict formatted kind of way, but with the book I'm working on, I almost need to. I have my outline and my word counts in this excel spreadsheet as well.

The one I'm most interested in using is the playlist tab. I am someone who LOVES music when writing, and it's always playing an important role in the story. It helps me set the mood and really get to know the feel of each scene I'm writing. It really helps to enhance the scene. I'm also someone who enjoys breaking up the songs by chapter so I know the mood of each chapter and I can easily keep track of where to move certain bits to when I'm editing. That's one thing I didn't like about Sarah J. Maas' playlists

There's well over 100 songs on each playlist, but I'm someone who loves to break it up chapter by chapter. This allows me to get the mood of each chapter, and as a reader, I want to know what mood the author was feeling for each chapter as well and try to guess which song belonged to which scene in each chapter. It's more fun when you have a chunk to guess by. The way I do this to keep track (and to easily transfer to my spreadsheet) is I created a playlist on Spotify called "#amwriting" where I add a bunch of songs for the chapter I'm currently writing. This way, I can limit what I'm listening to by what's there. I have two playlists that have either only instrumentals or vocals. The instrumental one has over 1,000 songs to choose from. Yes, it's daunting, but it's so helpful when looking for new music for when I start writing a new chapter.

The tabs on my excel spreadsheet for word count and outline is pretty self-explanatory. I am someone who loves to keep track of everything. With the outline, I'm able to glance at what I've done in summary, and see if there is any plot holes. This also allows me to print the summaries out and rearrange if I need to. My word counts is something I've unintentionally keeping since I first started my book "Vigilant" and decided to keep it going. I love seeing the progress of work I've done. So every project I've started since, I always keep track of my word counts. Simple, but effective.

I have a very basic understanding of excel, so my spreadsheets always run basic:

I'm curious as to what you all do if you use spreadsheets. How do you break up and organize your writing? Let me know in the commnts down below!


Writer from Wisconsin who loves reading, writing, crocheting, and watching way too much of The 100. You can often find Amanda playing The Sims and procrastinating everything. 

  • Facebook
  • Twitter
  • Instagram