In preparation for writing some new material for Seven Voyages of Zylarthen, I made an Excel spreadsheet of most of the canonical old school spells.
Others have put together similar lists, but I haven't found any that did it in this format.
If you like, you may download it from my public Dropbox here. I hope you find it useful.
The spreadsheet has a distinct line for each spell (including an additional line for its reversed version, if applicable) and lists which publication(s) it appeared in, including how it was named and numbered within that publication.
I did this fairly quickly so undoubtedly I made some mistakes. If anyone finds any, I would be grateful if you would point them out.
I count 482 distinct spells with an additional 55 reversed versions. They were introduced in this sequence:
Men & Magic (1974): 90
Greyhawk (1975): 65
Strategic Review - Illusionists (1975): 25
Eldritch Wizardry - Druids (1976): 36
Holmes Basic (1977): 9
Players Handbook (1978): 122
Moldvay Basic set (1981): 0
Cook Expert set (1981): 1
Unearthed Arcana (1985): 134
Total: 482
Additional Reversed: 55
General Notes:
- I included the Illusionist spells in Strategic Review #4 because they would later become part of the canon. I did not include any other spells from Strategic Review or Dragon Magazine, although some would of course turn up later in Players Handbook or Unearthed Arcana.
- The publication dates are rough and may be off by a month or two. Obviously some spells had their genesis before they were officially published.
- The Cook Expert set seemed to include one spell - Striking - which I could not find in any other source. That seems odd to me and it's possible I missed the fact that it has some other name in AD&D.
- I didn't include cantrips. I am not a masochist or insane.
- Each distinct spell also includes its lowest and highest level according to the different versions by class and publication. All but 17 spells varied by no more than one level. The three greatest variances were Maze - 9th level Magic-User spell in Greyhawk, 5th level Illusionist spell in Players Handbook - Confusion and Create Water - 1st level Cleric spell in Players Handbook, 4th level Cleric spell in Cook Expert. Obviously, the precise description of these spells varied accordingly.
- Each spell also points to its reversed version, if any.
- The spreadsheet also lists its Zylarthen counterpart, if any. As many of you know, for Zylarthen I ditched the Cleric as a player character, but gave non-player character High Priests, Evil High Priests and Witches their own somewhat distinct lists.
- In keeping with my methodology of including material only through mid-1975, most 1st to 6th level Magic-User spells from Men & Magic and Greyhawk were included as Zylarthen Magic-User spells, but the list was rounded out with some Cleric spells.
- High Priests and Evil High Priests were given many of the Cleric spells I didn't use, plus some 7th to 9th level spells from Greyhawk. Witches were given a mix of extra Cleric, high-level Greyhawk and Illusionist spells.