The use of a story bible or manuscript style sheet template can prove invaluable for keeping track of important details in a book, and even more so when it comes to an entire series. Such forms can range from formal to informal. The key is finding a system that works for you. To hasten that process, I’ve included templates that can help kickstart this process. Passing one along to your editor is always appreciated, but not always practical for busy authors.
When I copy/line edit a manuscript, a basic style sheet formatted in Word is included in the project fee. However, a story bible formatted in Excel can be obtained for an additional charge.
Story Bible and Manuscript Style Sheet Templates
This post has been edited to acknowledge that I based my story bible on editor Rachel Daven Skinner’s manuscript style sheet. The evolution of my Excel story bible and Word style sheet was also informed by examples given by Beth Hill and Rachelle Gardner. I particularly liked how Ms. Skinner includes memorable quotes from the manuscript for the author to use for promotional purposes. Regardless of already existing examples, a lot of trial and error (and time!) went into devising the Excel story bible presented in this post.
I found Excel to be more practical in the creation of a story bible due to easier navigation between tabs as well as the ability to sort information in various ways. The form I’ve been using to create my manuscript style sheets utilizes five categories. I’ve created three tabs each on the story bible spreadsheet for the style sheet, timeline, people, and places. I left the quotes category at one tab since it’s best to choose a few enticing quotes judiciously for promotional purposes rather than a long list.
This system allows for information to be collected on three books in a series. However, additional tabs can easily be added. A link to download both the story bible template and manuscript style sheet template is included at the end of this post.
Each category of the story bible is fairly self-explanatory, and it’s important to remember this isn’t a one-size-fits-all endeavor. The spreadsheet can be adjusted to better fit fiction versus nonfiction, etc.. In any event, the following types of details will generally be included in each category.
Style Sheet: Essential alternate spellings, names, invented words, places, rarities, and unusual treatments (capitalizations, abbreviations, etc.).
Timeline: Day/date, chapter summary of main events, and chapter number or title, as well as any additional comments.
People: Any nicknames, important trait descriptions, unique habits, background info, etc. At times, the text may be directly copied from the manuscript.
Places: Layout and important details related to rooms, buildings, neighborhoods, towns, distances, etc.
Quotes: Memorable lines from the manuscript for sharing on social sites or other marketing materials.
The manuscript style sheet as it appears in Word is a simpler affair than the story bible spreadsheet, but it is still an invaluable tool for ensuring consistency within a manuscript. I also pepper the first quarter or so of each manuscript with more margin comments to inform and explain various rules. I believe an editor, like any good teacher, won’t just fix a mistake, but show the reason for the correction when a type of error appears multiple times.
DOWNLOADS!!! Feel free to download the Story Bible Template I’ve created in Exel and revise it to suit your purposes. The Style Sheet Template I’ve created in Word is available for download as well. If the action halts, you may need to ensure the popup blocker of your web browser is disabled. It would be lovely if you could share this post.
How do you keep track of pertinent details when working on large writing projects? Have you ever created a style sheet or received one from an editor?
If you enjoyed this post, you may also enjoy reading How to Self-Edit a Manuscript for Content or How to Self-Edit a Manuscript for Language
Please share responsibly. Jeri Walker, 2015. Post updated May 2019.
Dear Jeri!… This is such a valuable tool… I couldn’t avoid thinking of Chomsky´s transformational grammar as I read your post… So thorough and exhaustive… I like the fact that you even take it further by adding brief summaries of various editing rules and their respective resources. … I will download the manuscript style sheet, for sure…. I could {even } use it to improve my English!…Thanks for sharing!… All the best to you! Aquileana ★
Aqui, creating the style sheet in its current form really was quite exhausting, but it has paid off. When I first started editing, I found myself continually forwarding the same links and bits of advice to writers. Little by little, I’ve been able to collect all of those sources in one place.
Jeri,
each time I read your posts, I can’t help thinking,
“SHE should be paid BIG bucks for this!’
Where do I leave the tip?
xxx
Kim, you leave tips all the time… just not monetary ones. Every time you say thank you for a tweet and sign it xx always makes me smile. As for the big bucks, lets just say I’m at least striving to be competitive while still offering affordable rates. With posts like this, I know I’m making my case for the value I can add to any editing project.
Hi Jeri,
Thank you for another informative post. You are so good at sharing valuable info! I like your choice of stepping into unknown domains and give a unique experience to your readers.
I am still trying to understand how to switch from Word to Excel.
I agree..”Rules after all were meant to be broken, but only if done with purposeful intention and not out of ignorance!”
Thanks for sharing.
Balroop, it can take some getting used to using Excel for what typically would be a word processing related task, but it’s so handy because of the ability to organize information into cells and tabs and then sort through the information in various ways.
This is fabulous, Jeri! I’ve downloaded and am now going to send this page to someone I know who’s struggling with this stuff.
Glynis, glad to hear you’ve downloaded the style sheet template. Please share away 🙂
What a great post Jeri – as an author Ive never considered using a style sheet. But having read your post I can see how I might use it in some form or another. Scrivener can handle some of these issues, but certainly not all of them. Having a handy reference spreadsheet is a brilliant way of doing it. Thanks so much ft the download. Much appreciated:-)
A.K., for the author Scrivener offers so many planning tools for the author. I’m starting to take advantage of more and more of them, but as an editor I still prefer to work with Word and Excel for client work since Scrivener is such specialized software that really does entail a huge though ultimately rewarding learning curve. The data manipulation affording by spreadsheets really can’t be beat, though I readily admit to being far from an Excel expert.
What a fantastic tool Jeri! Thanks for your generosity in sharing this!!!! I have done something similar, although not as throough, in Word. But this is much more effective and easier to manage. Thank YOU!!
Jacquie, I’m glad you feel the style sheet I’ve come up with looks easier to manage. It took quite a few drafts to get to this point, but I really do think this version is a keeper and one I can add to and develop more over the years.
Jeri, this is an excellent resource. Thank you for sharing. I refer to the Chicago Manual of Style quite frequently, but it is so easy to lose consistency in areas where you can choose one format vs another. I love the idea of tracking possible quotes. And the timeline is great – I have tried various ways to track that. Seeing things laid on like that really helps point out issues in the sequence or timing of events.
Donna, exactly! I got frustrated when I found myself looking up the same ten or so guidelines in the CMOS over and over again to verify. That’s when I started to collect the most important points and put them on the style sheet spreadsheet that I came up with. I added the memorable quote section not too long ago, but saw another editor who was doing that and thought it would be great to start doing the same as well.
This is interesting to see Jeri. My editing experience has mostly been in news-related fields so I’ve usually worked with short-form non-fiction and not had to work out many of these details.
Ken, shorter pieces definitely have their perks!
You have such an in depth knowledge of the whole writing process. I am in the middle of writing my first book (not fiction) and realise I have so much to learn.
Phoenicia, there is always more to learn about writing books. Hence the horror and appeal of the process 😉
Wow! What a great tool. I can imagine how helpful it would be. My memory isn’t getting better either; it could be really important. Thanks for sharing it and I did share too.
Beth, style sheets are such great aides for writers and editors alike. It’s such a great way to convey a ton of information in a concise and navigable form.
Jeri, thank you so much for sharing this. I’m writing a series (currently working on book two), and this style sheet will be extremely useful for keeping tabs on everything. At the moment I have character profiles, timelines, etc on Word documents, and with this I can bring them together under the one banner, so to speak. I appreciate you sharing your hard work with an indie author trying his hardest to fight through the tsunami out there! Again, thank you!
Liam, best of luck on your series and it’s great to hear you will be able to use my Excel style sheet to organize all of your details in a more efficient manner. I do love efficiency 😉
This is pure awesome-sauce (I intentionally chose to hyphenate that). Thank you for sharing, and now I will!
Laura, why thank you for the intentionally hyphenated awesome-sauce shout out!
Hi Jeri, This is awesome! Can’t tell you how much I love this tool. What a great post. I have a hard time keeping track of what I wrote from one page to the next as far as being consistent, this will keep me on track. Cool!
Susan, in some ways the recipe spreadsheet system we developed helps us keep tabs on type of recipe, but perhaps it’s time we put one together for your stories as you get ready to release you second collection? Our system is always one in progress and a bit different from what a full-length manuscript would entail, but still worth exploring.
Fantastic ideas and example, Jeri. Thanks for sharing it. Very cool. Right now, I use yellow note cards for charcters, settings, timelines but as you can imagine it gets pretty confusing. 🙂 I love this idea for fiction writing and as a reference as we go along writing. Of course, as an editor yours is much more in depth.
Lisa, note cards are a great idea, but that must be quick the stack of cards to keep track of. I’ve moved most of my lists and brainstorming to online storage and have fallen in love with OneNote, but still will use scratch paper for my roughest lists and ideas.
OMG Jeri this is amazing! I am so impressed with the process and I can easily see how I can adapt this for the non-fiction that I write. Thanks so much for sharing the template – I downloaded it and can hardly wait to give it a try!
Marquita, that’s great that you have seen possibilities for adapting the template for non-fiction. If you know anyone else who might find it useful, I hope you’ll forward it along to them as well.
Thanks for sharing this document. I downloaded it. I’ve been using a Word document that has the plot, characters, and chapter synopsis. If I put anything important in the synopsis, such as description, age, I underline or bold it. My current manuscript is a crime mystery series, so I need to track as much information as possible.
Denise, let me know how using the template goes for you and if there are any tweaks you would recommend. An entire mystery series? I’m impressed 😉
I’ll admit, the first think I thought when I read CMOS was Complementary metal-oxide semiconductor, or that battery that powers the memory chip in computers. Heh.
I’m not sure I fully understand manuscript style sheets (as my brain is wired to think CSS, cascading style sheets, or how you style a webpage). Is it just so the editor knows that I did something on purpose and doesn’t try to correct it?
Loni, when an author starts a style sheet and passes it on to an editor, it can be an extremely useful tool in communicating their preferences to the editor and to also pass along character summaries and the like. On the other hand, when an editor either adds to or creates a style sheet to pass back to the writer along with the fully edited manuscript it provides a detailed account of the types of changes made that can be assessed much faster than the entire manuscript. In cases where multiple people work on getting a book ready, the style sheet might change hands many times. It could even be given to cover artists and other people who will be assisting with a book.
I’d never heard of a manuscript style sheet, but I definitely see how valuable it can be. Even in my little blog entries, I will catch myself, let’s say, putting a hyphen in a word the first time, and leaving it as 2 words the second, etc. I could see how you could get really lost in a book or a series. My husband is working on the first issue of his comic book. When proofing his artist’s work, he noticed that a character was wearing a half t-shirt in some of the pictures, and a full t-shirt in others. He spent some time working with continuity in the film business so he is pretty good at catching these types of things, but it is still difficult. Thank you for the great lesson.
Erica, interesting example you’ve given regarding your husband’s experience in catching continuity mistakes. In a way, using a style sheet reinforces the habits of mind needed to catch all those tiny little types of details.
As usual, a genius practical resource for writing. I’ve never even considered half the items you include on the template, but I can see how they’d be invaluable when creating a character, or for marketing purposes. I use Canadian Press style for most of my writing – covers spelling, caps, all kinds of different terms. But you’re right, Chicago Manual of Style is the king of them all! Thanks for this, I know I’ll use it : ))
Krystyna, why thank you 😉 I shall see if I can come up with another “genius practical resource for writing” again in the near future.
Share indeed Jeri! This is invaluable. I know I’ll have to modify it for non-fiction and that’s fine. It’s incredibly useful. You’re amazing.
Patricia, I’m always happy to share useful tools in in the name of efficiency.
I had never really thought about a tool for managing the style and consistency of a book but as usual you have brought something to the table for which I am grateful.
Tim, glad as always to have given you some food for thought 😉 Your writer’s wheels are always turning and I know you’ll put together a full-length travel memoir one of these days.
This is a great tool. I definitely will download it.
Jason, thanks!
I am in the process of writing my sequel to my novel. I really need something like this. I have so many characters, and things going on, it is starting to get confusing. I spend most of my time looking back trying to find out if I had used that name for a character before, and what time of year my current writing is happening. Thanks for sharing.
William, I have nothing but admiration for writers who work on series. A style sheet most definitely comes in handy in such cases. My own writing tends to focus on humanity on a small-scale humanity, but there’s still plenty to keep track of.
Remember that Guinness beer commercial from a few years back? A manuscript style sheet? Brilliant! And here I was thinking I’d bribe my sister to compile just such a list. I am currently trudging through the last chapters of my second novel (of a trilogy, no less). Keeping the details straight is a major chore and time-suck. I can’t even begin to calculate the hours I’ve spent tracking down if my character’s kitchen has granite or marble countertops, long-forgotten minor characters’ names, or what type of Scotch my hero drinks, etc. I’ve downloaded it and it will replace the spiral notebook full of chicken-scratch used for such purposes. Thank you, thank you, from the bottom of my unorganized heart I thank you.
Julie, thanks so much for leaving such a great comment. It totally boosts my outlook when people let me know they find various downloads and examples helpful.
This is just a note to inform readers I’ve added links to the style sheet post above to give credit to a few sources which enabled me to create my version in Excel. If you prefer working in Word, consider checking out Rachel Daven Skinner’s template as well. Have a great day and carry on!
I usually just write it down on a piece of paper. Maybe I should try something more.
Alex, at least you keep track of things on paper. That’s better than not doing so at all.
I’ve always wondered how authors keep track of all those tiny details, especially over a whole series! This is such a great resource!
Thanks, Meredith!
Thank you for sharing this, Jeri. I’ll be downloading it and trying it out for one of my WIPS. Invaluable tool!
Lisa, I hope the story bible comes in handy. It can be trying to keep track of so many details over the course of writing a series.
Thanks so much Jeri. I’ll include a link to this post in my next writer’s tips. 🙂 x
Thanks so much, DG!
I commented previously on my husband’s work with artists to create his comic book series. I now realize I should pass your free download offer along to him. I think it would be great to pass along something like this when he hands his manuscript to his artists. While he gives them some kind of “cheat sheet”, this seems more involved and a better way to help his artists keep the different characters straight.
Erica, this really is a great way to tracking important characters and events.
I really appreciate the style sheet you provided when editing my mystery. I refer to it frequently! Happy to tweet this along–especially to the #amwriting group. Such supportive people.
Rosemary, thanks for sharing 🙂