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. Donate today.

—————

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:

J. K. Rowling

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.

(h/t Open Culture)

More Like This

A Visit to Our Meanest Relative Can Only End in Tears

“Nuts” by Katie Schorr, recommended by Halimah Marcus for Electric Literature

Apr 13 - Katie Schorr

7 Innovative Collections From Poets Without MFAs

With no institution advising these writers where to go, they go everywhere

Apr 13 - Burnside Soleil

15 Must-Read Small Press Books of Spring 2026

Celebrate the warmer weather with these hot new indie titles

Apr 10 - Wendy J. Fox
Thank You!