How to Keep Track of Characters, Places and Timelines Without a Spreadsheet
To keep track of characters in a novel, you need three registers linked to the manuscript: character sheets, location sheets and a timeline, each updated the moment a chapter fixes a fact, and each reread between two chapters to check that the text has not drifted. Spreadsheets and sticky notes fail for one reason only: they live somewhere other than the text, and what lives elsewhere does not get opened. Here is the three-register system, on an invented novel, and the routine that keeps it alive until the last chapter.
What a story bible does not do
The phrase "story bible" has moved. At Sudowrite (19 dollars a month, or 10 dollars a month billed yearly, as of September 23, 2026), the Story Bible is a set of fields that feed the generator: you describe your world so the tool can write inside it. That is consistent with what the tool does; it is not what a writer who writes their own book needs. What that writer needs is to find, in three seconds, the color of the door, the brother's age and the day of the week the scene happens on, and to be warned when a chapter contradicts any of the three.
Register 1: characters
The example novel is called "The Locks", a village crime story on the edge of a canal. Three sheets are enough to start: Helene Vasseur, the lock keeper; her son Bastien; and old Corbin, who runs the bar. A sheet is not filled in before writing; it is filled in when the text decides. The full template is described in the character profile template that actually talks back; here, only the column that matters for continuity:
| Fact fixed | Sheet | Source chapter |
|---|---|---|
| Helene is 52, scar on her left hand | Helene | 1 |
| Bastien left the village in 2019 | Bastien | 2 |
| Corbin has not driven since his accident | Corbin | 4 |
| Helene does not drink alcohol | Helene | 6 |
The "source chapter" column is what separates a sheet from a spreadsheet: every fact has an address in the manuscript. When you doubt, you go and look at the sentence, not the cell.
Register 2: places
A location sheet answers five questions: what do you see when you walk in, where do you enter from, where are the windows, what do you hear, and who has access. For the lock keeper's house:
Lock keeper's house. Entrance through the kitchen, canal side. Office door on the right as you come in. Two windows onto the canal, none onto the road. You hear the sluice gates at night. Key under the rosemary pot, known to Helene, Bastien and Corbin.
This sheet looks like an inventory. It becomes a tool in chapter 14, when Bastien hears someone knocking on the road-side door and the sheet says there is no window on that side: he cannot see who is knocking, and the scene changes. The full story of that kind of rescue is in how a location sheet caught a continuity error in chapter 14. For organizing many places at the scale of an invented world, the layered method is in how to organize your fictional world.
Register 3: the timeline
The timeline is not the outline. The outline says in what order the reader reads; the timeline says in what order things happen to the characters. As soon as a novel contains a flashback, an old secret or two narrators, the two come apart. Minimal format, one line per event:
| Story date | Event | Who knows | Chapter |
|---|---|---|---|
| March 12, 6 am | Body found in the lock chamber | Helene | 1 |
| March 12, 9 am | Police on site | Helene, Corbin | 1 |
| March 11, 11 pm | Bastien arrives in the village | Bastien | 5 (flashback) |
| March 12, 2 pm | Bastien learns of the death | Bastien, Helene | 7 |
The "who knows" column prevents the most common error in novels with several characters: someone mentions a fact they have not learned yet. In chapter 6, Bastien cannot mention the body; he only hears about it in chapter 7.
The routine between two chapters
The system is worth nothing if it is not reread, and nobody rereads a spreadsheet. The routine that holds is the one that takes five minutes after every finished chapter:
- Reread the chapter looking for what it fixed (an age, an object, a time, a confession).
- Put each fact into the relevant sheet, with the chapter number.
- Check that the chapter has not contradicted a fact already fixed.
Not everything gets noted. A detail that will never come back (the color of a taxi) clutters the sheet; a detail another chapter could contradict (an injury, a key, a train time) goes in the same day. If you hesitate, ask whether an attentive reader could catch you on it in chapter 20.
Step 3 is the one that gets skipped, because it requires remembering everything. In the Sagoræ workshop, the Archivist does it: when you mark a chapter as finished, it rereads it with the sheets and the timeline in view, and flags the gaps with their source. "Chapter 9: Helene orders a glass of white wine. Helene's sheet, chapter 6: does not drink alcohol." It does not correct, it rewrites nothing; it shows you the two sentences and you decide. Sometimes the sheet is the one that is wrong, because you changed your mind, and you update it.
A The Archivist · Continuity keeper Pre-recorded demo
The Archivist checks chapter 14 of "Bellécume"
The Archivist
I compared chapter 14 with the sheets and the timeline. Three things to check:
- Scar. Nils's sheet says the scar is on his right cheek (chapter 5, the fall on the rocks). Here it is on the left.
- Timeline. Chapter 12 ends "in the first week of May". Chapter 14 happens "in the March rain". A deliberate flashback, or a slip?
- Location. Elea left Bellécume in chapter 11 for the Isle of Sleepers. She cannot have written "from Bellécume" the day before, unless she came back off-page.
Nothing to report on Theodore: he has been the lighthouse keeper since chapter 3 and his sheet lists no travel.
The Archivist
Noted. I suggest you change "left" to "right" and "March" to "May" in your text; I will not edit it myself. For Elea, as soon as chapter 13 is in the novel I will update her location and the alert will disappear. Do you want me to add "back in Bellécume, chapter 13" to her sheet in the meantime?
Pre-recorded simulation. The Archivist reads the sheets, locations and timeline of the novel; it flags, the author decides.
A series bible is not a document
For a series, people imagine a big document you read before starting book 2. In practice that document never exists in a readable state, because it grows at the pace of book 1 and is never reread in full. A series bible is a habit, not a file: the three registers, kept chapter after chapter, and consulted at the moment of writing rather than before. When book 2 starts, you have nothing to reread; you open Corbin's sheet the moment Corbin comes back, and you discover he no longer drives. What to lock down from book 1 and what to leave open is covered in how to write a book series: keeping a series bible.
What the spreadsheet and the sticky notes cannot do
They can store everything. What they cannot do is be open at the right moment. A spreadsheet is another window; a sticky note is on another wall. The sheet that gets used is the one that opens from inside the chapter, next to the text, and closes without you losing the sentence you were on. And above all, neither of them rereads: the checking stays on you, chapter after chapter, with whatever memory you have that day.
Frequently asked questions
What is a story bible for a novel? The set of facts fixed by the text (characters, places, timeline), arranged so they can be found while writing and checked while rereading. Not an encyclopedia written before the novel.
Do you need a story bible for a standalone novel? As soon as there are more than five named characters, a recurring location or a flashback, yes. It can fit in three sheets and a twenty-line timeline.
What is the difference between a timeline and an outline? The outline follows reading order, the timeline follows the order of events for the characters. They coincide in a linear story and come apart at the first flashback.
How do you check continuity without rereading everything? By noting the source chapter of every fact, and by rereading each finished chapter with the sheets in view, or by handing that reread to a tool that flags the gaps without rewriting.
If you want to keep your sheets and your timeline next to the manuscript, with a reader that compares them to every finished chapter, Sagoræ offers a free trial, no card required.
✒️ Read next: How a Location Sheet Caught a Continuity Error in Chapter 14 · How to Write a Book Series: Keeping a Series Bible Across Three Volumes
Write your novel in a real workshop: a focused editor, characters, story structure and AI coaches that guide you without writing for you. Start for free, no commitment.