writers resources / writing

How To Write Your Novel

Just like great people still put their pants on one leg at a time, all great novels start the same: with a nugget, an inspiration, an idea. Some unique or quirky character that must be shared, some plot that needs exploring. Something to get the brain started.

For me, often, it’s a topic I want to understand. This was  Michael Shaara’s inspiration for Killer Angels, one of the outstanding fiction accounts of the Civil war. He used Stephen Crane (author of The Red Badge of Courage) as his mentor–

“reading the cold history was not enough; he wanted to know what it was like to be there, what the weather was like, what men’s faces looked like. In order to live it he had to write it. This book was written for much the same reason.”

  • I create an Excel spreadsheet with columns for Section, Chapter, Purpose, Day, Time, Characters (major and minor), Setting (at the start and finish), character’s success or failure in each section, whether the section includes action or a reaction. Summary, Follow-up. These are the mechanics of a great novel. I know–sounds formulaic. It isn’t. I want to be sure I include all important parts of writing a story people want to read. I write for myself–yes–but I promise you, the writing is better–and more fun–if you follow conventions.
  • Why Excel? It’s easy to map out the action. the columns insure I’ve included all dramatic requirements of a good novel and followed up on all the details. I can also move blocks of text around easily, with a better reference for where they should fit.
  • I add my one-paragraph of skeletal details under Summary. This feels good. I’ve started.
  • And right there, I’m stuck. What comes next?
  • On a separate worksheet in the same Excel workbook, I define the plot, subplots, themes, goals, premise, idea, plot in excelmoral–not all of those, but enough I understand my purpose
  • On that same worksheet, I plot the story–how does it start (life is pretty good), what happens to change that, what does my protagonist do to fix things, how does that not work (its failure creates the required drama), what’s my protagonist’s next and next plan and how do they also fail, what is the climax–the final unsolvable problem that will destroy my protagonist, how do I solve it. This forces me to understand a whole lot more about my characters, plot, even the setting because that will play into how my characters interact.
  • The only way I can plot the story is to know my characters. As I’m working the timeline, I develop character biographies–what’s their background, their likes and dislikes, quirks, physical appearance, what drives them, how do they influence the story, what’s their ruling passion, what’s their purpose in the story (protagonist, antagonist, confidant, supporting actors), what are their emotional firestorms, what’s their psychological profile?
  • Knowing my characters clarifies the subplots. Though my protagonist may be focused on rescuing her kidnapped child, those around her will have their own agendas that will dictate their participation in her goal. Therein live my subplots.
  • Now I can return to my outline and fill it in. I create the Timeline portion (start/finish) early so I can be sure I’m including details of the day, time of day, month and year if required, in the Summary section. I want to know if it’s been a week or a day, if it’s winter or summer. These affect action.
  • I map out which characters are involved in which sections early. This insures that my protagonist is indeed the main character, and the protagonist shows up regularly to botch up the plot. I also insure the confidant appears every time I must share details which I couldn’t otherwise get out.
  • As I’m adding the pieces, I make notes for what must be researched, followed up later in the story, clarified, etc.
  • I check the columns about Action/Reaction. Most readers want to know what the POV (point of view) character is thinking, why s/he’s doing what s/he’s doing. I add as much introspection as action (almost–and this will vary depending upon whether you’re writing a thriller or literary fiction) and be sure the reader understands only what the POV character gets. This is a good way to develop drama–fear for the future
  • I add details of characters, settings to the outline. If this changes the plot, I work that change through
  • I clean up my ‘Follow up’ column. this is harder than it sounds. Too often, I find out that following up on some innocuous detail changes the plot. Be rigorous about having this logical progression. In fiction, a willing suspension of disbelief is our greatest ally. Lose that and your reader puts the book down.
  • I clean up transitions between all the parts.
  • I convert the Excel spreadsheet into text, in a Word doc (or Google Docs)
  • I clean it up.

Because I’m also a teacher, this takes me a year. By summer I get to the Word doc and spend my two months off–ten hours a day–working out my novel.

At least, that’s the plan. How about you?

Jacqui Murray is the editor of a technology curriculum for K-fifth grade and creator of two technology training books for middle school. She is the author of Building a Midshipman, the story of her daughter’s journey from high school to United States Naval Academy midshipman.  She is webmaster for five blogs, an Amazon Vine Voicebook reviewer, a columnist for Examiner.coman Editorial Review Board member forSIGCT, an IMS tech expertand a weekly contributor to Write Anything andTechnology in Education. Currently, she’s working on a techno-thriller that should be ready this summer. Contact Jacqui at her writing office or her tech lab, Ask a Tech Teacher.

Follow me



25 thoughts on “How To Write Your Novel

  1. You are simply awesome. Do you create this type of great content yourself or are you a member of a team? I’m here for the second time today. I used to live out in Massachusetts so I know what you are talking about here.

    Liked by 1 person

  2. I really think this is a great idea and will help in sorting out my ideas. I am not at all familiar with Excel but perhaps it may be worth trying just to get things in order. Thanks for sharing this information

    Liked by 1 person

  3. Pingback: The Power of Positive Writing | WordDreams...

  4. Pingback: The Power of Positive Writing | Today's Author

  5. The excel document is a really good idea. I have loads of ideas but actually writing them out in a format that will make sense when I look back over it is difficult. Also, I hear you with the planning taking a year. I’m a doctor, fitting in my writing is a nightmare, but it keeps me sane so I have to force myself to do it on a regular basis!


    • That is a challenge. Being a doctor always sounds like 23 hours on, one off–can you write between appointments? I agree about writing being a sanity check. Done right, it forces you do concentrate on a different world, which gives a break from real life.


      • I carry a little book of ideas with me so I can jot down snippits when they come to me. They soon add up and then when I’ve got a substantial amount of free time then I can sit down and write them all together. You are right though, sometimes there are long gaps between writing sessions.

        Liked by 1 person

  6. Pingback: How to Write Your Novel Part II « Jacqui Murray's WordDreams…

    • I really discovered a lot because of you. Your article is absolutely on point! Listen to your gut then back that up with some data. I really liked your blogs. I take a look at your post about every hour or so. You have really hit the nail on the head.


  7. So far so good-Jacqui. I do know that it feels really good to put plot, actions of characters, sucessful or not into these ‘blocks’. I’m really not a type A person, per se-I have a writer friend who is also an accountant & she uses exel-made perfect sense. But me ? No way! All it took was to give it a try. In addition, I am not familiar with Excel at all-never before a reason to use it! Any tid-bits of info about Excel you can share that would help?


  8. I have been looking at all the different software available to help writers and was leaning towards scrivener – mostly because I use excel every day for work – but the reality is that I know excel really well and I’d have to learn any of the other options from scratch. Thanks for sharing your experience and method – this is a great help!


    • You and I are rare. I find putting my thoughts into excel to be relaxing, inspires my creativity. I tried several different writing software but nothing worked better than excel.

      Let me know how it works.


  9. Jacqui,

    I am so thrilled to find you! I have been searching for (I saw this at a writer’s conference) the excel spreadsheet for writer’s. I am not a systematic person-but I feel that at this point in my writing (I’ve been revising for a year now!) that this approach is much needed. There is too much to keep track of without it.
    Also-very interested to hear more about your daughters journey to a midshipman in the Navy. I have a son who just finished high school entering into Mass Maritime in 2-wks. Its been an emotional roller-coaster! Not sure if either one of us is going to make it until the 20th when he reports to Orientation where I will not hear from him for 2-wks.
    Any thoughts?


    • I’m glad you like the Excel spreadsheet approach. Some think it stifles creativitiy. Me–it tracks the details so I can be creative. It made a huge difference in my plotting.

      For the USNA journey, check out my blog USNA or Bust. I even wrote a book on it! I have lots of info not only on the process but the Navy lifestyle. USNA Plebes are in the middle of their Plebe Summer right now–6 weeks of physical prep (some mental) for the Ac Year. My daughter’s out now, serving her country on the USS San Diego. What’s your son’s goal?


  10. Pingback: Daily Dose of Excel » Blog Archive » Some Links

  11. Pingback: Plotting a Story–with a Spreadsheet « Word Dreams…

  12. Pingback: How to Write Your Novel Part III: Character Development « Word Dreams…

  13. Pingback: How to Write Your Novel Part II « Word Dreams…

What do you think? Leave a comment and I'll 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 )

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.