All the spells?

[captainjapan]

If there was an answer to this question on the forum, I couldn't find it. 

Is there a resource that compiled all the OD&D spells(incl. from Dragon Magazine). I would prefer not to have to bid on a full set of the 2nd Ed. Wizard's Compendium if there's even just a list on the web somewhere. Would just having the AD&D Players Handbook and Unearthed Arcana be enough? I'm interested, primarily, in the official TSR spells. Clerical spells, too.

If you had to compile your own complete od&d spell compendium, what would be the easiest way to go about it? And, would you make an exception, to include a particular source that was not a TSR publication?


Thanks for any help.  

[talysman]

Seems to me that somebody loaded all the OD&D spells (other than those in the Dragon and sources like that) into a spreadsheet, but I can't find it now.

The easiest way for me to compile a list of OD&D spells would be to find or make a plaintext conversion of Men & Magic, Greyhawk, and Eldritch Wizardry and create one or more text files from that using the spells table, then writing a Perl script to re-arrange that in whatever format I need (like CSV or whatever.) If you mean "including spell descriptions", the answer is the same, but the script would be a little more complicated. I don't think adding duration, range, etc. as separate fields would be all that easy to automate, however, so I'd probably have to do that by hand. Sometimes, you just have to do the gruntwork.

As for including non-TSR publications (or even The Dragon,) it depends on two factors:

(1) Can I find a plaintext version, or a PDF I could extract plaintext from?
(2) Does it look easy to automate extracting info into fields?

And, I suppose, (3) Do the spells from that source even look like something I want?

[Desparil]

I did a quick Google search and found this - unfortunately the DropBox link in the blog post is no longer valid, but you could try contacting the owner and see if he'd send you a copy
saveversusallwands.blogspot.com/2016/06/giant-spreadsheet-of-od-holmes-ad-and.html

[captainjapan]

May 19, 2021 13:57:59 GMT -6 Desparil said:

I did a quick Google search and found this - unfortunately the DropBox link in the blog post is no longer valid, but you could try contacting the owner and see if he'd send you a copy
saveversusallwands.blogspot.com/2016/06/giant-spreadsheet-of-od-holmes-ad-and.html

That would be oakesspalding . Even though his spreadsheet is more extensive in one respect, Oakes says it lists sources of each spell. That would be helpful. Thanks.

As for Dragon Magazine, it (according to DragonDex) stops including what can be considered OD&D material mid-1979, which makes sense. Many of the new spells in the Dragon are meant for npc classes, but some others look really promising. Here are the original Strategic Review and Dragon Magazine articles that contained new OD&D spells:


"Illusionists!" by Peter Aronson SR#4(pg.6) First appearance of the Illusionist class.
"Mighty Magic Miscellany" by Peter Aronson #1(pg.23) High level Illusionist spells added.
"New Look at Illusionists, A" by Rafael Ovalle #12(pg.7)

"Notes On Women & Magic" by Len Lakofka 3(9) Almost all charm and seduction type spells.
"Witchcraft Supplement for Dungeons & Dragons" Anonymous #5(pg.4) An npc class?
"Another Look at Witches and Witchcraft in D&D" by Ronald Pehr #20(pg.12) Now, explicitly an npc class.

"Healers" by C. Hettlestad #3(pg.22) New class of cleric.
"Jesters!, The" by Carner, Cannon & Simon #3(pg.29) Another new pc class with spells.

"Wizard With a Difference, A" by James Ward #17(pg.13) Schools of npc wizardry for OD&D.
"Dragon Magic" by Michael Benveniste #15(pg.3) Spells tailored to the kinds of activities that would interest a dragon e.g., hoarding and evaluating treasure.

"New Spells In D&D!" by Paul Sullin #18(pg.21) Genuinely new spells researched in-game and submitted to the Dragon. 

I'm only omitting Gary Jaquet's joke spells and magic items from issue four and "Psionics Revisited" from issue twenty. According to DragonDex, there are over three hundred new spells in just these articles. I don't have the original issues anymore, but if I can find the CD-ROM set (I know it's around here somewhere) maybe I can extract some of these.






note: The AD&D Players Handbook, with it's AD&D spell list, was released in June 1978. You might say that every issue of the Dragon containing new spells after issue #14, May 1978, intends for those contributions to be for Advanced Dungeons & Dragons.


 

[talysman]

Was going to say "Good luck on this." Because I wasn't going to help out. It's a lot of work.

But then I remembered: Didn't I do a little bit of this work already?

OD&D Spell Lists

This is a spreadsheet that, as far as I know, contains every spell in Men & Magic, Greyhawk, and Eldritch Wizardry. It does not contain any spells from Dragon or any fanzines.

It only lists spell name, spell level, source, and spell class, not duration, range, or other data. It's a modified copy of a spreadsheet I was working on for one of my own projects, which did have some of this info, but it was not in standard format, because I was modifying all those stats.

So, this isn't exactly what you need, but it's a start.

[captainjapan]

Thanks a lot, talysman. This sheet is going to be my starting point. I didn't respond, before, because I can't write a Perl script to save my life. But, spreadsheets, I can do!