news
J. K. Rowling’s Spreadsheet Shows How She Wrote Harry Potter
This article is free to read. So is every article Electric Literature publishes. No limits, no paywalls—now or ever. But we rely on your support to keep it that way.
We need to raise $35,000 by April 15 to keep the lights on, and time is running out.
Help us reach the next milestone—$10,000 by Monday—by donating now.
—————
Every writer has their own process, and apparently J. K. Rowling is a meticulous plotter. This hand-written spreadsheet from Harry Potter and the Order of the Phoenix plots out everything from the month a chapter takes place to what is happening on or off screen in each subplot:

The first few columns are pretty simple: chapter number, month, chapter title, and plot outline
The next set of columns keep track of the different subplots, as Endpaper explains:
- “Prophecy”: A subplot about the prophecy Harry finds himself concerned about all through the book
- “Cho/Ginny”: The book’s romantic subplot
- “D.A.”: What’s happening with the resistance army, or “Dumbledore’s Army”
- “O of P”: What’s happening with the “Order of the Phoenix” group
- “Snape/Harry”: What’s happening with Snape and Harry
- “Hagrid and Grawp”: What’s happening with Hagrid and Grawp
If you are stuck in your own writing, perhaps following Rowling’s lead and mapping out your novel will help.

