Before we get to this post on how to create an outline for your novel, let me first acknowledge the scientific law that all writers can be classified as planners or pantsers.
Some writers outline their novel in advance (ye olde planners), other writers work via the seat of their pants with no idea where things are headed (ye olde pantsers).
Over the course of my writing career my style has evolved from primarily pants-ing to primarily planning, so trust me when I tell the pantsers: don’t sweat it! You don’t have to do things this way.
But I possess the zeal of the convert. I now can’t imagine not outlining.
An outline is a crucial tool for making sure your novel’s plot works as well as it possibly can, even if you create one retrospectively after pantsing your way through a draft.
Here’s what I do.
Use a spreadsheet to outline a novel
Some of you have already had an allergic reaction to this blog post upon seeing the word “spreadsheet,” but trust me on this one.
My initial approach to spreadsheeting was inspired by no less than J.K. Rowling, who revealed one of her hand-written spreadsheets for Order of the Phoenix. Angie Thomas, author of The Hate U Give (check out our interview here), also recently cited Rowling’s spreadsheet as an influence on her own approach.
Here’s why a spreadsheet is helpful: it’s so, so tricky to keep all of your plotlines in your head and “get above it” to see how everything fits together. It’s also extremely difficult to make sure all of your characters have well-defined character arcs, and it’s shockingly easy to forget about some characters entirely.
A spreadsheet helps you see things from above. Not only can you organize your thoughts on the main plot arcs, it helps you visualize your subplots and minor characters’ plots too.
How to create your novel outline
I have a slightly modified approach to Rowling’s spreadsheet (aside from the fact that I use Google Docs rather than binder paper!).
First, along the top row, create these column headers, starting in column B:
- Chapter numbers (I just abbreviate “Ch” to keep the width small)
- Main plot
- One column each for your major characters, in decreasing order of importance
- Try to group your minor characters, like “School” or “Society” if they fulfill a more general role.
Pretty simple right?
Here’s the secret sauce.
Your characters’ fundamentals
There are some essential things you need to know about every character and it’s extremely helpful to have them in your outline.
Along the left side of your spreadsheet, from A2 to A7, add these rows:
- What they want (quest goal)
- Hopes and dreams
- Mysteries
- Good qualities
- Bad qualities
- First impression
What you are tracking here are the essential qualities of all of your characters.
Their external desires are the things they’re going after in the world of your novel, like trying to save the prince, eating their way through the cheese factory, or trying to become a millionaire. It doesn’t have to be a literal quest, it can also be conquering a personal demon or finding inner peace.
Hopes and dreams are what their life would look like if they had a magic wand (I recommend getting really specific these).
The mysteries are the Big Unanswered Questions that the reader is going to be wondering over the course of the novel, like “Can she really break free?” or “Did he really commit the crime?” This doesn’t just go for mystery novels, all novels should have at least some element of mystery. (Also see this post on crafting mysteries in a novel).
Good and bad qualities are self-explanatory. Someone might be determined, but they might also be stubborn. They might be caring but they might also be naive. We should see the entire range of qualities on display for all of your major characters.
And I like to track the first impression we have of the character, hopefully a very evocative image or catchy moment, because it’s so crucial to introduce characters in a memorable way.
Pretty helpful, right? But wait, there’s more!
Your plot framework
All along the left side of your spreadsheet under the fundamentals, block off your plot framework.
Here’s what I mean by that.
You might not know how many chapters your book is going to have yet, but as you begin to figure out your “tentpoles” (key moments in your novel) and begin organizing around sections or acts, you can block these off on the left side of the spreadsheet.
Color code these.
Even better, if you have a favorite plot framework, whether from screenwriting books like Save the Cat or a book on writing novels or some hybrid proprietary formula, you can add sections for those to help you visualize what should be happening.
This can really help if you’re stuck and trying figure out what “should” happen.
What it looks like
But wait, Nathan, you might be saying, why don’t you just show me what you mean by all this?
I’m glad you asked.
Here’s a novel outline template that you can download and modify to use as your own.
Mine is organized around a 50 chapter book, and my very rough proprietary framework is color-coded on the left, which I’ve modified from a variety of sources over the years. (Here’s more detail about the categories and how I developed this.)
To download it and start using it, go through the File menu within the doc:
Start filling it in
Now all that’s left is, well, using the darn thing!
Start filling in the different boxes, move things around as needed, and you will slowly begin to see your novel take shape.
Consider this a living document that you will keep tweaking over the course of writing the novel. Sometimes even the best outlines let us down when we actually write the chapters, so it might be necessary and go back to readjust as you go.
Anything I missed? Do you have any favorite tips or tricks? Let me know in the comments!
Need help with your book? I’m available for manuscript edits, query critiques, and coaching!
For my best advice, check out my online classes (NEW!), my guide to writing a novel and my guide to publishing a book.
And if you like this post: subscribe to my newsletter!
Art: The Alexander Column in Scaffolding by Grigory Gagarin
Thank you! Thank you for the template. Thank you, always, for the important reminders.
Great to see you back in full swing again. Well, you have been for awhile now. The novel I sometimes mentioned in your blog from ages ago I’m still working on. Perhaps if I was a planner it would have happened by now. However, I do like to surprise myself with where the story goes. It’s as if I’m hoping for inspiration to trickle down from above like gold dust from a brilliant sunset. (Like that one? 🙂
A mix of both can be helpful! Sometimes you just have to get it all out, but it can then be useful to go back and make sure things are piecing together the way you want them to.
Btw, appreciate all the work you’ve put into this. Def inspires me to have a go.
Thanks Nathan, Great spreadsheet. I’m doing mine on paper, but I appreciate the parts.
Nevermind, I’m using the spreadsheet (modified for Romance) and it’s working fabulously. Thanks for posting it just at the right time!
So glad you’re finding it helpful!
Thanks, Nathan, I’m using the spreadsheet and it’s a big help!
Awesome! Glad you’re finding it useful!
Thank you! Just what I needed to realize what the story was missing was more columns (i.e. some subplots). Your posts have been a huge help!
Thanks for this, Nathan. I’ve long used a rather elaborate system of plotting, acts, set-pieces, chapters, parts and so on, usually on my computer, though sometimes printed out and taped to my walls. Your system looks like it could be particularly useful for characterization in one of my WIPs.
I’m more of a colored-pencil on graph paper kind of gal, but this looks very organized. I think it’s really generous of you to provide this for writers to download, and I wanted to thank you for that.