An Internet Wizard Mapped Out How Often Each 'Harry Potter' Spell Was Used

Warner Bros.

Warning: This story is for extreme "Harry Potter" nerds only. I'm talking the Hermiones of the nerds. Nerds plus. Nerd turned up to 11.

If this is not you, you may be very bored. OK, proceed.

Oh hey, "Harry Potter" nerds. Boy do I have something cool to show you.

I know you guys like magical spells and I KNOW you guys like charted data because, duh, you're all huge fucking nerds.

So, without further ado, I present to you... A CHART OF EVERY SINGLE SPELL IN "HARRY POTTER"!


The chart was made by Skyler Johnson of Houston, Texas via Tableau Public, a free app that people can use to share their data.

Skyler, you definitely chose the right data to share.

This badass chart not only shows you every spell used in the books, it also tells you how often they were used, what book they were used in, what specific page they were used on and what specific quote from the books they can be found in.

There's so much magical data to process, I don't even know where to start.

You can sort either by "Order of Appearance" or by "Most Occurrences," and it excludes non-verbal and implied magic.

What shocked me most was how few spells were uttered in "Sorcerer's Stone" — only seven, and three of those were Wingardium Leviosa.

Like c'mon, is this a school for magical learning or what?

I guess it shouldn't be surprising the book that has the most spells is "Deathly Hallows," considering there is a giant wizard battle at the end of it.

Meanwhile, the top five most-used spells are Accio, Expecto Patronum, Stupefy, Expelliarmus and Lumos.

If this table also charted spells by how dramatically they were uttered, I think we all know what would get first place.

And just one more statistic, since I know you nerds will appreciate it.

The very first spell of "Harry Potter" was Alohomora, when Hermione unlocked the door on the third floor to help the trio escape Filch.

And the very last spell in "Deathly Hallows" was Duro, a spell which Hermione used to turn the two Death Eaters pursuing the trio into stone during the Battle of Hogwarts.

How fitting that both times were Hermione saving Harry's and Ron's ass, yet again.

Citations: This magical chart shows the most popular spells in 'Harry Potter' (Mashable)