I've compiled a list of all spells into schools, in level order to make it easier for anyone, player or DM to make a specialist wizard PC/NPC without having to try and rememeber what spell is in which school. I also have it in xl format on request.
Hope it's of some use to someone. If anyone wants any other lists making, I can do them.
I'll dig out my list of craftables (wands and potions) later too. I have it somewhere, used to use it for ticking off spells, writing prices and so on.
---Abjuration---
24 Spells0 Resistance
1 Endure Elements
1 Iron Guts
1 Protection from Alignment
1 Shield
2 Lesser Dispel
2 Resist Elements
3 Clarity
3 Dispel Magic
3 Magic Circle against Alignment
3 Protection from Elements
4 Lesser Spell Breach
4 Minor Globe of Invulnerability
4 Remove Curse
4 Stoneskin
5 Dismissal
5 Energy Buffer
5 Lesser Mind Blank
5 Lesser Spell Mantle
6 Globe of Invulnerability
7 Banishment
7 Spell Mantle
8 Mind Blank
9 Greater Spell Mantle
9 Mordenkainen's Disjunction
--Conjuration--
27 Spells0 Acid Splash
0 Ray of Frost
1 Grease
1 Mage Armour
1 Summon Creature 1
2 Melf's Acid Arrow
2 Summon Creature 2
2 Web
3 Flame Arrow
3 Mestil's Acid Breath
3 Stinking Cloud
3 Summon Creature 3
4 Evard's Black Tentacles
4 Summon Creature 4
5 Cloudkill
5 Lesser Planar Binding
5 Mestil's Acid Sheath
5 Summon Creature 5
6 Acid Fog
6 Planar Binding
6 Summon Creature 6
7 Summon Creature 7
8 Greater Planar Binding
8 Summon Creature 8
9 Black Blade of Disaster
9 Gate
9 Summon Creature 9
--Divination--
12 Spells1 Identify
1 True Strike
2 See Invisibility
3 Clairaudience/Clairvoyance
3 Find Traps
4 Remove Blindness/Deafness
5 Feeblemind
6 Legend Lore
6 True Seeing
7 Power Word Stun
8 Premonition
9 Power Word Kill
--Enchantment--
16 Spells0 Daze
1 Sleep
1 Charm Person
1 Horizikaul's Boom
2 Blindness Deafness
2 Tasha's Hideous Laughter
3 Hold Person
4 Charm Monster
4 Confusion
5 Dominate Person
5 Hold Monster
5 Mind Fog
6 Mass Haste
7 Protection from Spells
8 Mass Charm
9 Dominate Monster
--Evocation--
34 Spells0 Electric Jolt
0 Flare
0 Light
1 Magic Missile
1 Shelgarn's Persistent Blade
2 Cloud of Bewilderment
2 Combust
2 Darkness
2 Flame Weapon
2 Gedlee's Electric Loop
3 Fireball
3 Gust of Wind
3 Lightning Bolt
3 Scintilating Sphere
4 Elemental Shield
4 Ice Storm
4 Isaac's Lesser Missile Storm
4 Wall of Fire
5 Ball Lightning
5 Bigby's Interposing Hand
5 Cone of Cold
5 Firebrand
6 Bigby's Forceful Hand
6 Chain Lightning
6 Isaac's Greater Missile Storm
7 Bigby's Grasping Hand
7 Delayed Blast Fireball
7 Great Thunderclap
7 Prismatic Spray
8 Bigby's Clenched Fist
8 Incendary Cloud
8 Sunburst
9 Bigby's Crushing Hand
9 Meteor Swarm
--Illusion--
15 Spells1 Colour Spray
2 Continual Flame
2 Ghostly Visage
2 Invisibility
3 Displacement
3 Invisibility Sphere
4 Improved Invisibility
4 Phantasmal Killer
4 Shadow Conjuration
5 Greater Shadow Conjuration
6 Ethereal Visage
6 Shades
7 Shadow Shield
8 Mass Blindness/Deafness
9 Weird
--Necromancy--
20 Spells1 Negative Energy Ray
1 Ray of Enfeeblement
1 Scare
2 Death Armour
2 Ghoul Touch
3 Negative Energy Burst
3 Vampiric Touch
4 Contagion
4 Enervation
4 Fear
5 Animate Dead
6 Circle of Death
6 Undeath to Death
7 Control Undead
7 Finger of Death
8 Create Undead
8 Horrid Wilting
9 Energy Drain
9 Wail of the Banshee
--Transmutation--
27 Spells1 Burning Hands
1 Expedious Retreat
1 Magic Weapon
2 Balagarn's Iron Horn
2 Bull's Strenght
2 Cat's Grace
2 Eagle's Splendor
2 Endurance
2 Fox's Cunning
2 Knock
2 Owl's Wisdom
2 Stone Bones
2 Ultravision
3 Greater Magic Weapon
3 Haste
3 Keen Edge
3 Slow
4 Bestow Curse
4 Polymorph Self
6 Flesh to Stone
6 Stone to Flesh
6 Tenser's Transformation
7 Mordenkainen's Sword
8 Blackstaff
8 Greater Sanctuary
9 Shapechange
9 Timestop
Edit: Changed spelling mistake.
Note: Do not complain about English spelling, Armour has a U in it.