S+SG: the Story Grid Spreadsheet – Mac

This is the meat and potatoes of the Story Grid, the Spreadsheet, where everything is laid out before your eyes and you can start doing some internal analysis. Let’s get started!

Warning: these tips and techniques work best with Mac computer loaded with Scrivener 3.0 or higher; most of this can be done on a windows machine, but there are some advanced functions that are not currently available on the windows version

Over the last month, I’ve discussed how to inset all of the columns of the Story Grid Spreadsheet into Scrivener with the end result of being able to export all of this information into an excel spreadsheet. If you have not read those posts, you should probably begin there. Here are the last two posts on this process:

What is the Story Grid Spreadsheet

Shawn Coyne describes his Story Grid Spreadsheet as “invaluable in pinpointing places where you went off course, missed a crucial scene or beat and/or made minor continuity mistakes”.

In this post, we will export all of this data into an excel spreadsheet as described in the The Story Grid book.

Once you have all the data for your scenes in Scrivener, you can export.  So far, Scrivener exports cleanly to Numbers only, I’ve tried a number of times to get excel to cooperate, but no dice.  So, I export to numbers, then copy over to excel and it looks pretty clean. 

To do this, follow these steps:

1.Click on outliner, it’s an icon at the top middle that has blue lines on it next to the corkboard icon.  It should look like this:

Open Outliner

2.  Select the arrow at the right top of the outliner, it should look like this:

Outliner – Select Subjects to display

Now, select the subjects you want on the spreadsheet – I selected the title and synopsis – this will include the 5 commandments, the literal action, and the essential action – these items aren’t on the original spreadsheet that Shawn Coyne created, so if you don’t want them then don’t select them, but as I will show you they come up pretty clean on the spreadsheet and I think having them on the spreadsheet can add to your analysis. Also, I added word count and all the metadata that we created.

3.  Select file/export/Outliner contents as CSV.  Change your file name and where you want it saved then push export.  The window will look like this:

Export Outliner contents as CSV window

Once you select the location and then click Export, this will make a Mac Numbers spreadsheet that looks like this:

Very clean.  Then I copy this to an empty excel spreadsheet, this is what I ended up with:

And you have the Story Grid Spreadsheet from your Scrivener.  Pretty cool, huh?

Next time, we will add in the Editor’s 6 Core Questions into the Scrivener structure.

If anything in this post was not clear, or you need more detailed explanation, please write a comment below.

2 Comments on “S+SG: the Story Grid Spreadsheet – Mac

    • Your welcome, hope this helps. I use it for my editing clients all the time, and for my personal writing. I’ll post a scrivener template up soon.

      Like

Leave a Reply to Randy Cancel 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

%d bloggers like this: