Full spell list

[Arz]

Yajinden’s Soul Switch has no level.

[zook1shoe]

fixed for next time

...

added epic spells/psionics

added psionics

[Arz]

   Warning [Forgotten Realms: Player’s Guide to Faerûn 118; Oriental Adventures 118] - (Te subject still loses its Dexterity bonus to AC if immobilized.) = (The

Found another "te"s:
   Stone Walk [Forgotten Realms: Lords of Darkness 189; Forgotten Realms: Magic of Faerûn 124; Forgotten Realms: Player’s Guide to Faerûn 113]

[HazardousToast]

Hey all!
This is my first post, but I've been trying to create a web-based accessible app, and eventually make the app distributable as a docker container. Has anyone been successful in parsing the text file? Maybe into a .csv format or excel format? I'm about 80% of the way there, but there are some edge cases where some spells wind up in the descriptions of other spells. Spells like Abyssal Frenzy or Permanence with long bulleted or tabulated descriptions are throwing me for a loop!

Thanks! I'll keep an eye on here, but You can also reach me in the discord at hazardoustoast

EDIT: typo

[Selie]

Zook,

i fiddled around in excel and indexed all spells in your file
i also made it filterable by class (it's not the prettiest way, but it works as far as i can tell)

check your PM

-Selie

previous post edits:

(click to show/hide)

EDIT:
looking at the class filter right now and i'm seeing a lot of possible errors, will be working on the VBA a little and i'll get back to y'all on that.

EDIT EDIT:
i think it's complete, ran into a boat load of misinput in the previous file, but now i think i'm getting either close to done, or done entirely.
Excel file is now filterable by class/ level, components, school, etc.

EDIT EDIT EDIT:
i'm still cleaning the file up while i have some spare time left.
making things like "Close (25ft. + 5ft / 2 CL.)" uniform so it doesn't show up 25 times in the filter with an extra space or a missing '.'

Last EDIT: (probably)
So, i fixed the entries in the original document so all spells where parse-able to the excel sheet, and manually touched up the rest.

Currently every category you can filter the spell-list with is:

Name   School   Components   Casting Time   Range   Area   Targets   
Effect   Duration   Saving Throw   Spell Resistance   Description   Focus   Special   Class/level

to filter class level use the drop-down filter in the CL column and use a text -filter
i kept the classes combined in their cell because it was absolutely soul-crushingly difficult to write code to separate and parse all data in their own class-column. almost considered doing it all manually but had to finish this while the hyper-focus was still fresh.

pm me for the file.
-Selie

[zook1shoe]

thank you for making that! i've never been one for using much beyond Microsoft Word/Office for stuff. even making my charts and tables primarily in that, not Excel.

[zook1shoe]

added the Sorcerer/Wizard spell list pdf in a layout format similar to that in a bunch of the books, still filling in the brief spell blurbs. figured this was a good start for my fellow wizard mains

finished the Sor/Wiz spell list w the short blurbs