Recently, I shared why Microsoft Excel and Google Docs are some of my favorite pieces of book writing software. Spreadsheets might seem like odd resources for a writer, but I’ve found them to be invaluable tools for planning my stories.

Best Book Writing Software: How to Make a Beat Sheet in Google Sheets

I use spreadsheets to plan my stories in several ways. Today, though, I’m going to focus on just one: creating a beat sheet to outline a story before I write.

I like the beat system Blake Snyder presents in Save the Cat. It’s a useful and straightforward way of breaking down the important pieces of a story. I won’t go into detail about his system here, but if you’re curious, you can go to SaveTheCat.com to read more about it.

That said, you don’t have to base your work on Save the Cat; you can use this process for any beat structure you like.

To build this sheet, I’ll be using Google Sheets, a great book writing software choice because it is free for anyone to access. You can create your own sheet here.

And if you want to take a look at the full sheet I created for this exercise, I’ve made it public. You can check it out here.

Organize the Beat Sheet

The first step in creating a beat sheet is to set up the important columns and rows.

Column A is going to be my headings for each row, so I put them in first. I usually I start with four rows to start:

  1. Story Section: This tells me what section of the story I’m in. For this beat sheet, I’m going to do a three act story structure. This row isn’t necessary. I like it because sometimes I switch it up and try to write in a five act structure (which I haven’t really mastered yet – my first novel was in five acts, and while I love it, it’s kind of a hot-mess).
  2. Beat: As I said above, I like using Blake Snyder’s Save the Cat structure. You can put in here any beat structure you like.
  3. Scene Description: This is where I will list with a sentence or two the scene of the narrative that fulfills the beat.
  4. Additional Scene Description: This is where I will list any additional scenes I need to write if the first one didn’t work.

And because I like to be fancy, I’ll go ahead and bold this column by highlighting it and pressing the B button.

Next, I’m going to fill in the rest of row 2 with the beat structure I plan to use. Again, to learn more about the Save the Cats beats, head over to their website. Be careful though. If you’re a story structure nerd like me, you can get lost there for hours.

And again, because I’m fancy, I like to bold and center the text.

The next step for me is to put my three act structure in. I’ll put that in row 1.

You’ll notice that when I had more to write than I had space, my spreadsheet cell expanded. That’s because I “wrapped the text” early. I’ll go into more detail about formatting the spreadsheet below.

Summarize the Scenes

Now I’m ready to start thinking through my scenes. I’ll write one or two sentences for each scene that will serve as reminders for me when I sit down to write.

For this spreadsheet, I quickly brainstormed a quick story about Jack and Jane. Each cell of the rows 3 and 4 will be a scene in the story (probably a chapter).

You’ll notice that when I got to the “Debate” beat, I felt that I needed two scenes to fulfill the beat. So I added an additional scene in row 4.

Write the Story

Now I’m ready to write my story. Using my sheet, I’ll work through the writing one scene at a time. What I love about this format is, if while I’m writing I come up with another scene I want to write, I can just insert it under the beat it corresponds too. I will often add six to seven scenes as I write.

Additionally, I like this system because it allows me to see the narrative as a whole. If I’m hitting one beat with too many scenes, I will know because that column will have way more rows filled in than the others.

Bonus: Format the Sheet

I skipped ahead to the contents of the beat sheet, but before I end, I want to give you some tips about formatting. When you open a Google Sheet, it will look like this.

You’ll notice that the cells are too small to write anything of substance in. There are three things we need to do to prepare the sheet.

First, give your sheet a name. You can do this by clicking at the top right of the sheet where it says “Untitled spreadsheet.”

Next, highlight columns A through Q by holding down the shift key while clicking each letter. Then hover over the line between A and B, click, and drag the line so it matches the line between B can C. This should double the size of all your columns.

While you have the columns highlighted, go head and “wrap the text.” You can do this by clicking the wrap text button and choosing the middle of the three options.

Now your sheet is ready to write in and easy to read.

What Structure Will You Use?

Personally, I’ve found that spreadsheets are vital pieces of book writing software and it’s essential that I outline if my stories are going to make any sense. You might enjoy planning your stories out with this kind of thoroughness, or you might like to discover the story as you write and create the beat sheet to describe it later.

Either way, I encourage you to try laying out your stories in a spreadsheet. It’s one of the easiest ways to see the story from a grand overhead view and find plot holes and inconsistencies to fill.

What book writing software helps you plan your stories? Do you use spreadsheets to outline before you write (or even after you finish)? Let us know in the comments.

PRACTICE

Now it’s your turn to plan a story. Open a new Google Sheet and take fifteen minutes to create a beat sheet to outline a story from start to finish. Here’s your prompt:

A character finds a mysterious object hidden in a bush.

When you’re done, tell us about your story in the comments below. How did the beat sheet help you plan it? If you’d like, you can even make your spreadsheet public and share it with us. And if you post, be sure to leave feedback for your fellow writers!

Jeff Elkins
Jeff Elkins
Jeff Elkins is a writer who lives Baltimore with his wife and five kids. If you enjoy his writing, he'd be honored if you would subscribe to his free monthly newsletter. All subscribers receive a free copy of Jeff's urban fantasy novella "The Window Washing Boy."