We are up to letter E on the A to Z Challenge. As an author, I thought I would write about how I use Microsoft Excel Spreadsheet software to help me organize and write my novels. Now I am talking about Excel since that is the software I have, but I assume any spreadsheet software would be able to work in a similar fashion.
When I was writing the second and third books in my fantasy trilogy, I had quite a few main characters that were in different locations. As they traveled or events happened, I used the spreadsheet to tell where everyone was at any given moment. This also helped me ensure that travel times were the same throughout the trilogy.
In addition to the main characters, I had a whole bunch of minor players with magical powers. I needed to keep track of their names, power and location.
Both these pages are “sheets” in one Excel file. It helps me to be able to open one file and see everything I need without scrolling through pages in a Word file.
I am currently using an Excel spreadsheet on my work in progress. The first sheet is location (though all characters are traveling together this time) and the second sheet is a list of characters (major and minor) with names, where they are from and if they have any magical ability. (This also lets me keep track of who has died in the story.)