D&D 5E Spell List for Easy reference

[Salthorae]

Hi there guys,

My group and I have jumped into 5e with gusto. I'm playing a bard, and given that I couldn't easily reference the spells vs. my Bard spell list when I was looking at the spell descriptions, I decided to make an excel spread sheet of the spells that I could slice and dice by class/school/component/ritual or not/component consumed or not

Thought there might be some interest here for that, so I'm posting it here for you guys to see and use. I dont' think there is anything copy protected in what I've put together. If there is, mods please feel free to let me know and block/remove this thread (and apologies if there is).

View attachment 5th Edition Spells.xlsx

 

[Redthistle]

Greatly appreciated, Silver Defender.

 

[ScuroNotte]

Warlocks get 19 spells: 15 level 5 spells, then through mystic arcanum learns 1 6th, 7th, 8th, and 9th level spell

 

[lethalprophet]

Hi there guys,

My group and I have jumped into 5e with gusto. I'm playing a bard, and given that I couldn't easily reference the spells vs. my Bard spell list when I was looking at the spell descriptions, I decided to make an excel spread sheet of the spells that I could slice and dice by class/school/component/ritual or not/component consumed or not

Thought there might be some interest here for that, so I'm posting it here for you guys to see and use. I dont' think there is anything copy protected in what I've put together. If there is, mods please feel free to let me know and block/remove this thread (and apologies if there is).

View attachment 64385

Any chance you have an updated version of this? I was going to build one, but was just going to use the basic sort functions of an excel table. The slicers are a great idea. I am going to add a sourcebook column to make it easier to look the spells up when needed, but otherwise, this is really awesome.

 

[Blue]

Any chance you have an updated version of this? I was going to build one, but was just going to use the basic sort functions of an excel table. The slicers are a great idea. I am going to add a sourcebook column to make it easier to look the spells up when needed, but otherwise, this is really awesome.

@MechaTarrasque does a wonderful one with not just spells but everything and it's up to date. The post you were responding to was from 2014.

D&D 5E - 5e Lists of Monsters, Spells, Races, Feats, Etc.

I haven't gone through Storm King's Thunder yet, but I think this is everything from WotC and Tome of Beasts. I will try to update this periodically. Disclaimers: Everything in the spreadsheet is owned by the various publishers (WotC and Kobold Press).

www.enworld.org