Plotting Made Simple: How a Spreadsheet Can Save Your Story

Is this you and your WIP?

When it comes to plotting your story, using a spreadsheet can be a game-changer. Instead of scrolling through pages of unorganized text, a spreadsheet offers a visually structured way to plan each element of your plot, keeping everything in one place. Plus, it’s easy to update and refer back to as you go.

The first step is setting up your spreadsheet in a way that works for you and what you want to have at a glance.

Start by heading your columns like this:

• Chapter/Scene Number

• Scene Summary

• Character(s) Involved

• Plot Points

• Character Arcs

• Notes/Revision Ideas

Then, fill in your rows with the corresponding information. Play around with the design and decide what feels most useful to you. Maybe you need a column for setting or a reminder of what’s happened in the previous chapter. It’s totally up to you!

You can also create separate spreadsheets for your characters and their traits, which will give you a handy reference when you need it.

Here’s an example breakdown for your characters:

• Name

• Age

• Place of Origin/Current Location

• Relationship Status

• Positive Traits/Habits

• Negative Traits/Habits

• Typically Found…

• Vices

• Guilty Pleasures

• Goals

Again, the options are endless!

Pro Tip: Color-code your plot spreadsheet to keep track of your progress and ensure that all of your characters’ arcs and plot points are being met.