D&D 5e spell damage comparison

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	Q	R
1	NOTE: This version is obsolete
2	Find the improved version at https://docs.google.com/spreadsheets/d/1GvcTLXGHeSovGWFKTJRXMjThOfLUTxZRF9XJO3Yx-tI/edit?usp=sharing
3											Spell slot level
4	Spell	Target/area	Base damage	Scaling	Defense	Range	1	2	3	4	5	6	7	8	9

5	Cantrips						Lv1		Lv5			Lv11			Lv17
6	Vicious Mockery	Single	1d4	Per tier	Save null	60ft	1.25		2.50			3.75			5.00
7	Acid Splash	x2	1d6	Per tier	Save null	60ft	1.75		3.50			5.25			7.00	Bold	AoE or multiple targets
8	Thorn Whip	Single	1d6	Per tier	Attack roll	30ft	1.75		3.50			5.25			7.00	Blue	Damage is dealt multiple times
9	Chill Touch	Single	1d8	Per tier	Attack roll	120ft	2,25		4,50			6,75			9,00	Red	Doesn't scale any further
10	Create Bonfire	Single	1d8	Per tier	Save null	60ft	2,25		4,50			6,75			9,00
11	Lightning Lure	Single	1d8	Per tier	Save null	15ft	2,25		4,50			6,75			9,00
12	Produce Flame	Single	1d8	Per tier	Attack roll	30ft	2,25		4,50			6,75			9,00
13	Ray of Frost	Single	1d8	Per tier	Attack roll	60ft	2,25		4,50			6,75			9,00
14	Sacred Flame	Single	1d8	Per tier	Save null	60ft	2,25		4,50			6,75			9,00
15	Shocking Grasp	Single	1d8	Per tier	Attack roll	Touch	2,25		4,50			6,75			9,00
16	Eldritch Blast	Spread	1d10	Per tier	Attack roll	120ft	2.75		5.50			8.25			11.00
17	Fire Bolt	Single	1d10	Per tier	Attack roll	120ft	2.75		5.50			8.25			11.00
18	Poison Spray	Single	1d12	Per tier	Save null	10ft	3.25		6.50			9.75			13.00
19	1st-level
20	Arms of Hadar	AoE	2d6	1d6/lv	Save ½	0+10ft	5.25	7.88	10.51	13.14	15.77	18.40	21.03	23.66	26.29
21	Burning Hands	AoE	3d6	1d6/lv	Save ½	0+15ft	7.88	10.51	13.14	15.77	18.40	21.03	23.66	26.29	28.92
22	Catapult (EE)	Single	3d8	1d8/lv	Save null	150ft	6.75	9.00	11.25	13.50	15.75	18.00	20.25	22.50	24.75
23	Chromatic Orb	Single	3d8	1d8/lv	Attack roll	90ft	6.75	9.00	11.25	13.50	15.75	18.00	20.25	22.50	24.75
24	Dissonant Whispers	Single	3d6	1d6/lv	Save ½	60ft	7.88	10.51	13.14	15.77	18.40	21.03	23.66	26.29	28.92
25	Earth Tremor (EE)	AoE (small)	1d6	1d6/lv	Save null	0+10ft	1.75	3.50	5.25	7.00	8.75	10.50	12.25	14.00	15.75
26	Ensnaring Strike	Single	w+1d6/turn	1d6/lv	Save ends	Weapon	3.06	6.12	9.18	12.24	15.30	18.36	21.42	24.48	27.54
27	Guiding Bolt	Single	4d6	1d6/lv	Attack roll	120ft	7.00	8.75	10.50	12.25	14.00	15.75	17.50	19.25	21.00
28	Hail of Thorns	AoE (small)	w+1d10	1d10/lv	Save ½	Weapon	5.50	11.00	16.50	22.00	27.50	33.00	33.00	33.00	33.00
29	Hellish Rebuke	Single	2d10	1d10/lv	Save ½	60ft	8.25	12.38	16.51	20.64	24.77	28.90	33.03	37.16	41.29
30	Ice Knife (EE)	Single + AoE	1d10+2d6			60ft	6.25	8.00	9.75	11.50	13.25	15.00	16.75	18.50	20.25
31		-Single	1d10	─	Attack roll		2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75
32		-AoE (small)	2d6	1d6/lv	Save null		3.50	5.25	7.00	8.75	10.50	12.25	14.00	15.75	17.50
33	Inflict Wounds	Single	3d10	1d10/lv	Attack roll	Touch	8.25	10.50	12.75	15.00	17.25	19.50	21.75	24.00	26.25
34	Magic Missile	Spread	1d4+1 x3	x1/lv	─	120ft	10.50	14.00	17.50	21.00	24.50	28.00	31.50	35.00	38.50
35	Ray of Sickness	Single	2d8	1d8/lv	Attack roll	60ft	4.50	6.75	9.00	11.25	13.50	15.75	18.00	20.25	22.50
36	Searing Smite	Single	w+1d6/turn	1d6/lv	Save ends	Melee	6.12	9.62	13.12	16.62	20.12	23.62	27.12	30.62	34.12
37	Thunderous Smite	Single	w+2d6	─	─	Melee	7.00	7.00	7.00	7.00	7.00	7.00	7.00	7.00	7.00
38	Thunderwave	AoE	2d8	1d8/lv	Save ½	0+15ft	6.75	10.13	13.51	16.89	20.27	23.65	27.03	30.41	33.79
39	Witch Bolt	Single	1d12+1d12/turn	1d12/lv	Attack roll	30ft	3.25	6.50	9.75	13.00	16.25	19.50	22.75	26.00	29.25
40	Wrathful Smite	Single	w+1d6	─	─	Melee	3.50	3.50	3.50	3.50	3.50	3.50	3.50	3.50	3.50
41	2nd-level
42	Aganazzar's Scorcher (EE)	AoE (line)	3d8	1d8/lv	Save ½	0+30ft	─	10.13	13.51	16.89	20.27	23.65	27.03	30.41	33.79
43	Branding Smite	Single	w+2d6	1d6/lv	─	Weapon	─	7.00	10.50	14.00	17.50	21.00	24.50	28.00	31.50
44	Cloud of Daggers	Single	4d4	2d4/lv	─	60ft	─	10.00	15.00	20.00	25.00	30.00	35.00	40.00	45.00
45	Cordon of Arrows	Spread	1d6 x4	x2/lv	Save null	5+30ft	─	7.00	10.50	14.00	17.50	21.00	24.50	28.00	31.50
46	Dust Devil (EE)	AoE (small)	1d8/turn	1d8/lv	Save ½	60ft	─	3.38	6.76	10.14	13.52	16.90	20.28	23.66	27.04
47	Flame Blade	Spread	3d6/turn	1d6 /2lv	Attack roll	Melee	─	5.25	5.25	7.00	7.00	8.75	8.75	10.50	10.50
48	Flaming Sphere	AoE (small)	2d6/turn	1d6/lv	Save ½	60ft	─	5.25	7.88	10.51	13.14	15.77	18.40	21.03	23.66
49	Heat Metal	Single	2d8/turn	1d8/lv	─	60ft	─	9.00	13.50	18.00	22.50	27.00	31.50	36.00	40.50
50	Maximillian's Earthen Grasp (EE)	Single	2d6/turn	─	Save ends	30ft	─	3.50	3.50	3.50	3.50	3.50	3.50	3.50	3.50
51	Melf's Acid Arrow	Single	4d4+2d4	2d4/lv	Save third	90ft	─	10.00	13.13	16.26	19.39	22.52	25.65	28.78	31.91
52	Moonbeam	AoE (small)	2d10/turn	1d10/lv	Save ½	120ft	─	8.25	12.38	16.51	20.64	24.77	28.90	33.03	37.16
53	Scorching Ray	Spread	2d6 x3	x1/lv	Attack roll	120ft	─	10.50	14.00	17.50	21.00	24.50	28.00	31.50	35.00
54	Shatter	AoE	3d8	1d8/lv	Save ½	60ft	─	10.13	13.51	16.89	20.27	23.65	27.03	30.41	33.79
55	Snilloc's Snowball Swarm (EE)	AoE (small)	3d6	1d6/lv	Save ½	90ft	─	7.88	10.51	13.14	15.77	18.40	21.03	23.66	26.29
56	Spike Growth	AoE	2d4/square	─	─	150ft	─	5.00	5.00	5.00	5.00	5.00	5.00	5.00	5.00
57	Spiritual Weapon	Spread	1d8+WIS/turn	1d8 /2lv	Attack roll	60ft	─	2.25	2.25	4.50	4.50	6.75	6.75	9.00	9.00
58	3rd-level
59	Blinding Smite	Single	w+3d8	─	─	Melee	─	─	13.50	13.50	13.50	13.50	13.50	13.50	13.50
60	Call Lightning	AoE (small)	3d10/turn	1d10/lv	Save ½	120ft	─	─	12.38	16.51	20.64	24.77	28.90	33.03	37.16
61	Conjure Barrage	AoE (large)	3d8	─	Save ½	0+60ft	─	─	10.13	10.13	10.13	10.13	10.13	10.13	10.13
62	Erupting Earth (EE)	AoE (large)	3d12	1d12/lv	Save ½	120ft	─	─	14.63	19.51	24.39	29.27	34.15	39.03	43.91
63	Fireball	AoE (large)	8d6	1d6/lv	Save ½	150ft	─	─	21.00	23.63	26.26	28.89	31.52	34.15	36.78
64	Glyph of Warding (Explosive Runes)	AoE (large)	5d8	1d8/lv	Save ½	Touch	─	─	16.88	20.26	23.64	27.02	30.40	33.78	37.16
65	Hunger of Hadar	AoE (large)	2d6+2d6/turn	─	─/Save ½	150ft	─	─	10.50	10.50	10.50	10.50	10.50	10.50	10.50
66	Lightning Arrow	Single + AoE	4d8+2d8			Weapon	─	─	20.25	27.01	33.77	40.53	47.29	54.05	60.81
67		-Single	4d8	1d8/lv	Save ½		─	─	13.50	16.88	20.26	23.64	27.02	30.40	33.78
68		-AoE	2d8	1d8/lv	Save ½		─	─	6.75	10.13	13.51	16.89	20.27	23.65	27.03
69	Lightning Bolt	AoE (line)	8d6	1d6/lv	Save ½	0+100ft	─	─	21.00	23.63	26.26	28.89	31.52	34.15	36.78
70	Melf's Minute Meteors (EE)	AoE (small)	2d6 x2/turn	1 turn	Save ½	120ft	─	─	10.50	10.50	10.50	10.50	10.50	10.50	10.50
71	Spirit Guardians	AoE	3d8/turn	1d8/lv	Save ½	0+15ft	─	─	10.13	13.51	16.89	20.27	23.65	27.03	30.41
72	Tidal Wave	AoE	4d8	─	Save ½	120ft	─	─	13.50	13.50	13.50	13.50	13.50	13.50	13.50
73	Vampiric Touch	Single	3d6	1d6/lv	Attacks	Touch	─	─	10.50	14.00	17.50	21.00	24.50	28.00	31.50
74	4th-level
75	Blight	Single	8d8	1d8/lv	Save ½	30ft	─	─	─	27.00	30.38	33.76	37.14	40.52	43.90
76	Evard's Black Tentacles	AoE (large)	3d6/turn	─	Save ends	90ft	─	─	─	5.25	5.25	5.25	5.25	5.25	5.25
77	Fire Shield	Single	2d8/attack	─	─	Melee	─	─	─	9.00	9.00	9.00	9.00	9.00	9.00
78	Guardian of Faith	AoE	20 (total 60)	─	Save ½	30ft	─	─	─	15.00	15.00	15.00	15.00	15.00	15.00
79	Ice Storm	AoE (large)	2d8+4d6	1d8/lv	Save ½	300ft	─	─	─	17.75	21.13	24.51	27.89	31.27	34.65
80	Mordenkainen's Faithful Hound	Spread	4d8/turn	─	Attack roll	30ft	─	─	─	9.00	9.00	9.00	9.00	9.00	9.00
81	Phantasmal Killer	Single	4d10/turn	1d10/lv	Save ends	120ft	─	─	─	9.63	12.03	14.43	16.83	19.23	21.63
82	Staggering Smite	Single	w+4d6	─	─	Melee	─	─	─	14.00	14.00	14.00	14.00	14.00	14.00
83	Storm Sphere (EE)	AoE (large)	2d6/turn	1d6/lv	Save null	150ft	─	─	─	3.50	5.25	7.00	8.75	10.50	12.25
84		Single	4d6/turn	1d6/lv	Attack roll		─	─	─	7.00	8.75	10.50	12.25	14.00	15.75
85	Vitriolic Sphere (EE)	AoE (large)	10d4+5d4	2d4/lv	Save third	150ft	─	─	─	25.00	28.75	32.50	36.25	40.00	43.75
86	Wall of Fire	AoE (line)	5d8/turn	1d8/lv	Save ½	120ft	─	─	─	16.88	20.26	23.64	27.02	30.40	33.78
87	5th-level
88	Banishing Smite	Single	w+5d10	─	─	Weapon	─	─	─	─	27.50	27.50	27.50	27.50	27.50
89	Bigby's Hand (punch)	Spread	4d8/turn	2d8/lv	Attack roll	120ft	─	─	─	─	9.00	13.50	18.00	22.50	27.00
90	Bigby's Hand (crush)	Spread	2d6/turn	2d6/lv	Save ends	120ft	─	─	─	─	7.00	14.00	21.00	28.00	35.00
91	Cloudkill	AoE (large)	5d8/turn	1d8/lv	Save ½	120ft	─	─	─	─	16.88	20.26	23.64	27.02	30.40
92	Cone of Cold	AoE (large)	8d8	1d8/lv	Save ½	0+60ft	─	─	─	─	27.00	30.38	33.76	37.14	40.52
93	Conjure Volley	AoE (large)	8d8	─	Save ½	150ft	─	─	─	─	27.00	27.00	27.00	27.00	27.00
94	Destructive Wave	AoE (large)	10d6	─	Save ½	0+30ft	─	─	─	─	26.75	26.75	26.75	26.75	26.75
95	Flame Strike	AoE	8d6	1d6/lv	Save ½	60ft	─	─	─	─	21.00	23.63	26.26	28.89	31.52
96	Immolation (EE)	Single	7d6 + 3d6/turn	─	Save ends	90ft	─	─	─	─	22.31	22.31	22.31	22.31	22.31
97	Insect Plague	AoE (large)	4d10/turn	1d10/lv	Save ½	300ft	─	─	─	─	16.50	20.63	24.76	28.89	33.02
98	Maelstrom (EE)	AoE (large)	6d6/turn	─	Save null	120ft	─	─	─	─	10.50	10.50	10.50	10.50	10.50
99	Transmute Rock (EE) > Ceiling to mud	AoE (large)	4d8	─	Save ½	120ft	─	─	─	─	18.00	18.00	18.00	18.00	18.00
100	6th-level