Spreadsheets: Organizing Wisdom from Author Karen Whiting

I am one of those writers who sits among piles of stuff. That piece of information I need? I know I have it written on a piece of paper…somewhere. When it comes to writing, organizing one small devotion is not hard. Hook, Bible point, application. But now that I am writing devotional books, I’ve been wondering how to organize my writing. How can I be sure that my topics aren’t repetitive? How can I see my writing progress without having to scroll through a long Word document? Where can I jot ideas down so they don’t get lost?

With these questions simmering in the back of my mind, I attended Karen Whiting’s class at Montrose Christian Writer’s Conference in Montrose, PA. Karen Whiting is the award winning author of 26 books including The One Year My Princess Devotions, 52 Weekly Devotions for Families Called to Serve, and The Gift of Bread. Although the title of Karen’s class was Marketing Your Book, she generously shared additional ideas pertaining to organizing all aspects of being a writer. What is her secret?

Spreadsheets.

It sounds like a simple thing, but the idea has changed my writing life. Here’s how Karen uses spreadsheets:

Spreadsheets to Outline a Devotional Book

Rather than a traditional outline, Karen organizes her devotional book writing on a spreadsheet so she can see all the elements of the book at a glance. On her spreadsheet she includes a column for each element in the devotion including the title of each devotion, scripture passage, key verse, quote, and (most importantly) the need of the reader each particular devotion meets. For her upcoming devotional book for moms, she included needs like affirmation, love, and assurance. This way she can make sure that the book as a whole is meeting a range of the spiritual and emotional needs of the reader. She can also see that she does not write towards one need too often while ignoring others. She also uses spreadsheets to outline her parenting, craft, and Christian life books.

Spreadsheets to Organize the Marketing Plan

When I create a marketing plan for a book proposal, I use a bullet point list to brainstorm my marketing ideas. Karen uses a spreadsheet and groups similar marketing together. One section for radio interviews, one for television interviews, one for social media marketing, another for blog post and article ideas. She includes contact information for each radio station or magazine publisher. Then when she is ready to market, she has all the information she needs in one place. She can just go down the spreadsheet like a to-do list and make notes on her progress for each task. When an interview or article is complete, she adds the link on her spreadsheet.

Spreadsheets for the Launch Team

Leading up to the book release, the launch team will read advance copies of the book and generate excitement on social media and other places. Karen said it’s wise to have about 30-40 people on the launch team, but be prepared to see only 20-25% follow through. She uses a spreadsheet to keep track of members of her launch team, their addresses, and ideas for the gifts she will send to them. During the marketing class, Karen offered personalized suggestions to each author in the room by giving ideas for gifts for our launch team members. I was amazed at how creative Karen is on the spot! For my upcoming book Take It to Heart: 30 Days through Revelation, a Devotional Workbook, Karen gave ideas like squishy stress ball hearts and heart shaped candy. Yum! She also encouraged me to create speaking topics about truth since I encourage Christians to find simple truth in Scripture. Such helpful ideas!

I’m so grateful to Karen Whiting for sharing her wisdom with us at Montrose Christian Writer’s Conference. I came home energized and equipped to organize my devotional writing in an effective way.

Do you have any tips for organizing your writing life? Do you use spreadsheets? Comment below!

Rachel Schmoyer is a pastor’s wife who is loving her church life. She writes about the hard parts of Scripture at readthehardparts.com. She has had devotionals published in the past, but now she is looking forward to getting her first Christian Living book published. You can connect with Rachel on Facebook, Instagram, Twitter, or Pinterest.