Has anyone created a spell list grouping spells into categories?

[dreaded_beast]

I was wondering if anyone knows the location of or has created a spell lists that group the current spells (core rules and WotC) by category. For example:

A listing of all spells with the Evil descriptor
A listing of all spells with only Verbal and Somatic components
A listing of all spells with only Verbal components
A listing of all spells with only Somatic and Material components

Etc...

 

[gravyboat]

I was wondering if anyone knows the location of or has created a spell lists that group the current spells (core rules and WotC) by category. For example:

A listing of all spells with the Evil descriptor
A listing of all spells with only Verbal and Somatic components
A listing of all spells with only Verbal components
A listing of all spells with only Somatic and Material components

Etc...

I'm currently creating (don't know when it'll be done) a searchable HTML help file of all the SRD spells that will have numerous hyperlinks for any term that is significant with D&D spellcasting. You should be able to search, and get a listing, of all spells with the [Evil] descriptor, or all spells with a Verbal component, or only the spells with both, etc.

 

[jdfrenzel]

I have an Excel sheet that has most of this. (File is zipped and attached to the post.) The spells are v3.0, and include the 5 WoTC splatbooks, a few Green Ronin entries, a few stragglers. Not sure what's SRD and what's not. This is part of my homebrew character sheet, so please disregard anything that may not make sense.

Anyway, school, subschool, descriptors, components, etc. are set up as columns, so you can use the AutoFilter to find what you're looking for. gravyboat may find this useful after exporting to plain text.

Hope this helps, YMMV.


--- John

 

[dreaded_beast]

I have an Excel sheet that has most of this. (File is zipped and attached to the post.) The spells are v3.0, and include the 5 WoTC splatbooks, a few Green Ronin entries, a few stragglers. Not sure what's SRD and what's not. This is part of my homebrew character sheet, so please disregard anything that may not make sense.

Anyway, school, subschool, descriptors, components, etc. are set up as columns, so you can use the AutoFilter to find what you're looking for. gravyboat may find this useful after exporting to plain text.

Hope this helps, YMMV.


--- John

This is awesome! Good work!