{"id":43,"date":"2014-07-29T18:30:45","date_gmt":"2014-07-29T18:30:45","guid":{"rendered":"http:\/\/www.longharecontent.com\/LonghareBlog\/?p=43"},"modified":"2015-03-29T17:17:38","modified_gmt":"2015-03-29T17:17:38","slug":"outlining-novel-spreadsheets","status":"publish","type":"post","link":"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/","title":{"rendered":"Outlining Your Novel: Spreadsheets"},"content":{"rendered":"<p>Outlining a novel helps to structure the plot and keep the time line straight. There are many methods and forms. The goal is not to freeze-dry the plot before it is even composed, but to prevent the writer from losing sight of the universe he or she is constructing.<\/p>\n<h2>Spreadsheets for Outlining<\/h2>\n<p>There are a variety of strategies for outlining aside from the I., A., 1., a., method. Spreadsheets are an excellent way of visualizing the structure and flow of a novel. Below is a spreadsheet created by J. K. Rowling, jotted down by hand, wobbly lines and all, on a sideways piece of ruled notebook paper.<\/p>\n<p><a href=\"http:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44 size-medium\" src=\"http:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling-300x214.png\" alt=\"J. K. Rowling spreadsheet outlining The Order of the Phoenix\" width=\"300\" height=\"214\" srcset=\"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling-300x214.png 300w, https:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling-1024x732.png 1024w, https:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling-624x446.png 624w, https:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling.png 1053w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>I lifted the image from the <a title=\"J. K. Rowling spreadsheet\" href=\"http:\/\/blog.paperblanks.com\/2013\/05\/j-k-rowling-book-outline\/\" target=\"_blank\">Paperblanks blog<\/a>.<\/p>\n<p>Rowling made columns for chapter number and title, with the corresponding month, a column for plot (overview), and columns for the different plot strands. At a glance, she could see when a character is introduced, at what point critical events take place, and importantly, what else is going on around the same time. She could see how the various subplots were flowing and how they were intersecting with each other and with the main plot. The chart is full of scribbles, arrows, scratches, and insertions. Rowling maintained it as a live document as the writing progressed.<\/p>\n<p>The spreadsheet is a very handy writer&#8217;s tool, even for novels with only two or three subplots. Rowling worked with a pen and notebook paper, but a writer working in Word or WordPerfect can use the table feature. Scrivener also has tables. And there is always Excel. The virtue of Excel, aside from the ability to build very wide documents, is that you can get pretty OCD with colors and formulas and subworksheets. Here is a link to <a href=\"http:\/\/www.awn.com\/blog\/how-get-god-s-eye-view-your-story-microsoft-excel\" target=\"_blank\">How to Get a God&#8217;s-Eye View of Your Story in Excel<\/a> from Jeffrey Scott&#8217;s blog post on Animation World Network. His example pertains to scriptwriting but is adaptable to novel writing.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Outlining a novel helps to structure the plot and keep the time line straight. There are many methods and forms. The goal is not to freeze-dry the plot before it is even composed, but to prevent the writer from losing sight of the universe he or she is constructing. Spreadsheets for Outlining There are a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,16,22],"tags":[5,23,24,25,4,44],"class_list":["post-43","post","type-post","status-publish","format-standard","hentry","category-advice-for-writers","category-story-development","category-writers-tools","tag-authors","tag-outlining-a-novel","tag-plotting-a-novel","tag-spreadsheet-of-novel","tag-writers","tag-writers-tools"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Outlining Your Novel: Spreadsheets - Editor to Writer<\/title>\n<meta name=\"description\" content=\"The spreadsheet is a very handy writer&#039;s tool for outlining a novel&#039;s plot and time line. Rowling has made columns for chapter, month, and plot strands.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Outlining Your Novel: Spreadsheets - Editor to Writer\" \/>\n<meta property=\"og:description\" content=\"The spreadsheet is a very handy writer&#039;s tool for outlining a novel&#039;s plot and time line. Rowling has made columns for chapter, month, and plot strands.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Editor to Writer\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-29T18:30:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-03-29T17:17:38+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling-300x214.png\" \/>\n<meta name=\"author\" content=\"janetlong\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"janetlong\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/\",\"url\":\"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/\",\"name\":\"Outlining Your Novel: Spreadsheets - Editor to Writer\",\"isPartOf\":{\"@id\":\"http:\/\/www.longharecontent.com\/LonghareBlog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling-300x214.png\",\"datePublished\":\"2014-07-29T18:30:45+00:00\",\"dateModified\":\"2015-03-29T17:17:38+00:00\",\"author\":{\"@id\":\"http:\/\/www.longharecontent.com\/LonghareBlog\/#\/schema\/person\/de1e3bcfb040a60cd40731a32175f81b\"},\"description\":\"The spreadsheet is a very handy writer's tool for outlining a novel's plot and time line. Rowling has made columns for chapter, month, and plot strands.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/#primaryimage\",\"url\":\"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling.png\",\"contentUrl\":\"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling.png\",\"width\":1053,\"height\":753,\"caption\":\"J. K. Rowling spreadsheet\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/www.longharecontent.com\/LonghareBlog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Outlining Your Novel: Spreadsheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.longharecontent.com\/LonghareBlog\/#website\",\"url\":\"http:\/\/www.longharecontent.com\/LonghareBlog\/\",\"name\":\"Editor to Writer\",\"description\":\"Helping Writers Figure Out What to Do Next\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.longharecontent.com\/LonghareBlog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/www.longharecontent.com\/LonghareBlog\/#\/schema\/person\/de1e3bcfb040a60cd40731a32175f81b\",\"name\":\"janetlong\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/www.longharecontent.com\/LonghareBlog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5d426197bd6e0435d7238beb24f6ccf7ce473ed6ebcd7000a1102d4d86850b50?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5d426197bd6e0435d7238beb24f6ccf7ce473ed6ebcd7000a1102d4d86850b50?s=96&d=blank&r=g\",\"caption\":\"janetlong\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Outlining Your Novel: Spreadsheets - Editor to Writer","description":"The spreadsheet is a very handy writer's tool for outlining a novel's plot and time line. Rowling has made columns for chapter, month, and plot strands.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/","og_locale":"en_US","og_type":"article","og_title":"Outlining Your Novel: Spreadsheets - Editor to Writer","og_description":"The spreadsheet is a very handy writer's tool for outlining a novel's plot and time line. Rowling has made columns for chapter, month, and plot strands.","og_url":"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/","og_site_name":"Editor to Writer","article_published_time":"2014-07-29T18:30:45+00:00","article_modified_time":"2015-03-29T17:17:38+00:00","og_image":[{"url":"http:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling-300x214.png","type":"","width":"","height":""}],"author":"janetlong","twitter_misc":{"Written by":"janetlong","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/","url":"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/","name":"Outlining Your Novel: Spreadsheets - Editor to Writer","isPartOf":{"@id":"http:\/\/www.longharecontent.com\/LonghareBlog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/#primaryimage"},"image":{"@id":"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/#primaryimage"},"thumbnailUrl":"http:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling-300x214.png","datePublished":"2014-07-29T18:30:45+00:00","dateModified":"2015-03-29T17:17:38+00:00","author":{"@id":"http:\/\/www.longharecontent.com\/LonghareBlog\/#\/schema\/person\/de1e3bcfb040a60cd40731a32175f81b"},"description":"The spreadsheet is a very handy writer's tool for outlining a novel's plot and time line. Rowling has made columns for chapter, month, and plot strands.","breadcrumb":{"@id":"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/#primaryimage","url":"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling.png","contentUrl":"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-content\/uploads\/2014\/07\/Rowling.png","width":1053,"height":753,"caption":"J. K. Rowling spreadsheet"},{"@type":"BreadcrumbList","@id":"https:\/\/www.longharecontent.com\/LonghareBlog\/outlining-novel-spreadsheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.longharecontent.com\/LonghareBlog\/"},{"@type":"ListItem","position":2,"name":"Outlining Your Novel: Spreadsheets"}]},{"@type":"WebSite","@id":"http:\/\/www.longharecontent.com\/LonghareBlog\/#website","url":"http:\/\/www.longharecontent.com\/LonghareBlog\/","name":"Editor to Writer","description":"Helping Writers Figure Out What to Do Next","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.longharecontent.com\/LonghareBlog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/www.longharecontent.com\/LonghareBlog\/#\/schema\/person\/de1e3bcfb040a60cd40731a32175f81b","name":"janetlong","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.longharecontent.com\/LonghareBlog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5d426197bd6e0435d7238beb24f6ccf7ce473ed6ebcd7000a1102d4d86850b50?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5d426197bd6e0435d7238beb24f6ccf7ce473ed6ebcd7000a1102d4d86850b50?s=96&d=blank&r=g","caption":"janetlong"}}]}},"_links":{"self":[{"href":"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-json\/wp\/v2\/posts\/43","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-json\/wp\/v2\/comments?post=43"}],"version-history":[{"count":10,"href":"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-json\/wp\/v2\/posts\/43\/revisions"}],"predecessor-version":[{"id":55,"href":"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-json\/wp\/v2\/posts\/43\/revisions\/55"}],"wp:attachment":[{"href":"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-json\/wp\/v2\/media?parent=43"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-json\/wp\/v2\/categories?post=43"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.longharecontent.com\/LonghareBlog\/wp-json\/wp\/v2\/tags?post=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}