Writer Wednesday – Excel at Organizing

Excel spreadsheet, that is. They will help improve your writing skills by keeping your thoughts organized and at your fingertips. I use them for several writing tasks:

Character biographies–  I use these faithfully–at least for my main characters–so I am consistent with their looks personalities. The title of the spreadsheet is “(book title) characters.”  Within the spreadsheet, I create a page for each main character. In the first column are questions about the character:  Name, hair color, favorite hobby, best friend, etc. The second column is the answer with as much detail as you want. As your character develops in the story, add additional info.  The third column is the page numbers on which the trait is mentioned. (Scroll down to see an example taken from my historical fiction character Simon Rochon in my work in progress.)  I also like to insert a photo of someone who resembles the character in my mind.   

Timeline – No matter your genre and no matter the time span of your book, you must keep track of the passage of time and keep events in the proper order. A story that takes place over a day or two can be broken down into hours and minutes. Historical fiction might span a century. I started the time line for my current work fifty years before the story actually starts, because those earlier events had a bearing on the story.

DateLocationHistorical Context / ImportancePoint of ViewPlot Action / EventCharacter Growth
4/5/1650, morningFrancestory begins on farmMarie-age 11father drunk; she hidestakes more responsibility.
4/9/50St. Cosmefeast day; rye crop coming inJulienBoys return/bailiff threatsfamily pride

Change the columns to suit your story and call it a story arc tracker. For my first novel (Rim to Rim), I tracked time but also the story’s development on three levels: the physical journey, action/conflict, and the personal growth of the main character. I made sure progress was made on each of the levels in each scene or chapter.  

Social Media Plan

DateFB GroupInstagramPinterestWord press BlogGCWA FBpersonal FBemails
7/14/25Mystery MondayjoinedWhat’s thisskill- Character zonecharacter zonewhat’s thisinvite
7/15/25Time travel TuesdayFrench shoesFrench shoesHist.fiction writers? French shoesinvite

I’ve been told to choose two main social media outlets, so you don’t get overwhelmed. Use the others for special notices and the occasional Hello. Use versions of the same content for the various sites, so you don’t have to reinvent the wheel with each post. Create content beforehand and schedule it on the proper day.

Sample Character bio:   After reading Simon’s characteristics, you (and I) will know how he’ll will act in the story. 

NameSimon Rochon
AgeBorn Feb, 1633, so 17 in 1650. 
General physical Description Avg. height, shoulders broad, plain looking, nice eyes, dark hair
HometownSt. Cosme
type of Home/neighborhoodrural farm outside village near hamlet of Mamers
Relationship statusSingle, will eventually marry Mathurine Buisson in about 1663
current Family Parents and siblings
Family backgroundOldest boy born to a habitant, expected to take over farm
Friendsother boys from church or when helping each other farm
Other close relationshipsespecially close to Gervais
Occupationhelps father farm; apprentice to mason
ResponsibilitiesChores, earning extra money to keep farm going
Dress stylePeasant: knee pants, clogs, wool stockings, leather vest, cap 
ReligionCatholic
Attitude toward ReligionAccepting
Favorite pastimesfishing without the bailiff catching him
Favorite foodsfresh vegetables, esp carrots and onions
Strongest positive personality traitresponsible, loyal, intelligent, logical , affectionate
Strongest neg personality traitafraid of father’s disapproval
Sense of humorstraight man to brother
Tempereven tempered
Consideration for othersvery considerate
How other people see himserious and dependable
Opinion of himselfresponsible for the family’s well-being, even if it means leaving
Traits brought out in storylearns to accept father’s shortcoming and respect him for his accomplishments
ambitionsto learn masonry and be the best farmer possible
Philosophy of lifeHard work will solve problems
Most important thing to know about this characterhe grows up fast when needed and will always stand by his family.
Will readers like or dislike this character? Why?He is likable and takes a backseat to Gervais’s more animated personality
when was he most happyWhen he and father worked side by side building stone walls.
Talker or quiet?quiet
Body language habitsclasps his hands and taps thumbs together when thinking
What are his fearsthat he’ll fail 
Most cherished possession?His father’s carving tools and smoking pipe

Leave a comment

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