Close
Close
Advanced Search

One DND & 5e Spell List with Filters and DescriptionsClick to magnify

One DND & 5e Spell List with Filters and Descriptions

ADD TO WISHLIST >
Suggested Price $0.51

ONE DND Spell list 0.6

Hey! One DND is on its way and I'm super excited for it. 

To help people who are playtesting I have created an additional document available for download that allows you to sort the 2014 Player Handbook spells by Arcane, Divine and Primal. To get the playtesting documents head over to https://www.dndbeyond.com/one-dnd

The doc allows you to sort by in Arcane, Divine and Primal and Class Specific spells. In either a Yes or No style drop down or listed filter. As well as all the other filters.

This list also includes the changes to some spell, and some spell schools, these have been highlighted in Yellow for easy identification.

Please be aware there may be some errors within this document, always check the source materials.

The List will be updated when new content is released. Happy playtesting!

Please consider a small donation as any sales of any amount even a few pennies count towards the products badge. 

5e Spell list 2.8.2

Excel format Spreadsheet containing spells from The Players Handbook, Xanathar Guide to Everything and Tasha's Cauldron of Everything. With 2020 Eratta changes. 

A simple tool to help when making characters, NPC's or checking spells descriptions quickly. Works best on PC's but also works on Phones and Tablets.

To use, simply click the dropdown menu at the top of each collum and select the filters you want to use.

The Spell descriptions are written in the notes on each description spell name which can been seen by hovering over them with your cursor, or clicking on the cell on a mobile device. (This is the same for Materials components) the size of the box may need to be edited in the note to see the full description.

The Spells can be filtered by:

  • School
  • Ritual tag
  • Level
  • Casting Time
  • Range
  • Components
  • Concentration
  • Duration
  • Source
  • Page Number in Source
  • If the source is published (in case you add your own spells)
  • First Letter
  • Class
  • Class Extended Spell List From Tasha's (Listed as 'Ex' in the yes and no column)

This is an Excel file I made to help filter out Spells 'AND MAY CONTAIN MISTAKES' so please double check the original sources. It was not intended to put on here but I'd like to share it. 

I understand that there may be better versions available for download. But you can pay what you want for it! And it may not be free forever! Please consider a small donation  as any sales of any amount even a few pennies count towards the products badge. So if you download this and find it useful please leave a review to let me know that it is being used, that would be highly appreciated. As well as pointing out any mistakes. 

There are two documents you can download a locked version you can't edit so avoid accidental changes and a unlocked version if you wish to add your own spells and changes. 


FIXES/Change Log

2.8.1 September 2022

The Spell 'Psychic Scream' was missing a Text Note (Thanks Ray)

The Column for 'Page Number' was Changed to 'Page No.'

2.8.1 August 2022

The wizard Spell 'Wall of sand' was listed as No (Thanks Chris)

The spell 'Fog cloud' had a typo in the Filter for duration.

2.7 Feb 2022

Uploaded newest offline verison adding in the Extended spell list from Tasha's Filter on the Class Filters as well as mutiple fixes for spelling and incorrect details

2.2 May 2021

Moved the Descriptions filter to the actual spell name, dont know how I didn't think of that before.

The uploaded version now has the No filter for the Artificer 


2.1 April 2021

A few well needed changes,  I'm surpised people still download this so I thought I'd update it.

Added Tasha's Cauldron of Everything Spells

Added Artificer Class Filter

Removed Sword Coast Adventurers Guide Spells (as they are now in Tasha's)

Added a Freeze so you can always see the top line and spell name when using the sheet.

Removed the Unearthed arcana Spells 

Removed the N/A filter on Paladin and Ranger replaced it with No

2.0 April 2020

Made changes to a number of spell descriptios to match the on the 2020 Eratta.

The Document lock was removed now everything can be edited by the user.


1.9.3 July 2019

Fixed error. Mass healing word had the description of Mass Heal

1.9 June 2018

Added Xanathar Spells

Added ritual and concentration filters 

Versions 1.5 to 1.8 were not uploaded  to the DMs Guild

1.4 June 2016

The spells in the Players Handbook that each class can learn have been double checked and any errors corrected.

The file has now only been partially unlocked so you can edit the notes and use the dropdown menus.

pixel_trans.gif
 
 More from this Title's Contributors
pixel_trans.gif
 
 Customers Who Bought this Title also Purchased
pixel_trans.gif
pixel_trans.gif
Reviews (1)
Discussions (5)
Customer avatar
Eric P September 27, 2022 11:03 pm UTC
PURCHASER
Fantastic list! Thanks for putting it together. It works great just as it is, but I'm using this as a data source and need Notes in their own column and still nicely formatted. I've found some scripts that do it, but it loses the formatting. If you happen to have those Notes captured somewhere else, that would be a big help!
Reply
Customer avatar
Lewis P September 28, 2022 12:21 pm UTC
CREATOR
Hi Eric, glad to hear you're making good use of the list! Unfortunately I don't have the notes anywhere else, all the data was copied or typed directly into the sheet.

I assumed you may have tried this and I'm not sure it'd work but the only thing I could think of that might help is: Clicking on the Page layout tab > Selecting Print Titles > Under the Print section on the 'Comments' drop down select 'At the end of Sheet' > On your print options choose print to PDF.

Then you'll have PDF with the comments for the spells listed at the end, not sure it'll help at all and the formatting still may be unusable, but you might able able to script something else to correct it from the PDF.

Good luck with your endeavour!
Customer avatar
Ray O September 14, 2022 8:13 pm UTC
PURCHASER
First off I love this and have been searching for something like this for a year now. Down to brass tax in Version 2.8.1 the 9th level spell Psychic Scream is missing its description Comment. on a side note do you plan to add the Explorer's Guide to Wildemount's Dunamancy spell list? thank you.
Reply
Customer avatar
Lewis P September 17, 2022 10:51 am UTC
CREATOR
Thanks Ray, Glad you're finding the document useful, and thank you for commenting the error, the file has been updated.
Unfortunately no, I currently don't have plans to add Dunamancy Spells from Explorer's Guide to Wildemount. At the moment this Document is just for the Core Rules, Xanathar's and Tasha's spells though in the future I may add in spells from the other source books.
I'm currently slowly working on adding more filters for Damage type, Saves and Attack Rolls and Spell uses. Without straight up copying from D&D Beyond's Spell Page.........
Customer avatar
Chris D August 20, 2022 1:33 am UTC
PURCHASER
In version 2.7, Wall of Sand seems to have "No" for each class's column.
Reply
Customer avatar
Lewis P August 21, 2022 2:33 pm UTC
CREATOR
Thanks Chris, the file has been updated.
Customer avatar
Daniel F February 09, 2022 4:43 pm UTC
PURCHASER
Greetings, I want to remark that there are a few discrepancies between the list and Tasha's Cauldron of Everything:
Artificer: missing cantrips {Dancing Lights, Spare the Dying}, missing LVL1 {Absorb Elements, Alarm}, LVL2 Tasha's Mind Whip is not on the TCE Artificer spell list, no issues found on Lvl 3 thru 5
Bard: missing LVL1 {Command, Color Spray}, LVL2 {Aid, Enlarge/Reduce, Mirror Image}, LVL3 {Mass Healing Word, Slow}, LVL4 {Phantasmal Killer}, LVL5 {Rary's Telepathic Bond}, LVL6 {Heroes Feast}, LVL7 {Prismatic Spray}, LVL8 {Antipathy/Sympathy}, LVL9 {Prismatic Wall}
It seems that anything that Tasha's adds to a list that wasn't a spell specifically in the TCE book is not represented in the spreadsheet. I only went thru the added spells to the Bard's list and skimmed the Cleric and Druid sections as well so it is a bit of conjecture, but the pattern seems to be there.
Reply
Customer avatar
Lewis P February 19, 2022 5:27 pm UTC
CREATOR
Greetings Daniel, thank you for bringing this to my attention, I have a newer version of the document to upload ASAP which should fix all these issues.

Thanks.
Customer avatar
Stephanie M June 23, 2018 2:48 pm UTC
PURCHASER
That sounds great thanks for responding its been an interesting year for me as well
Reply
Customer avatar
Lewis P June 24, 2018 11:42 am UTC
CREATOR
Message me on Twitter @LewisSPowell and I'll send you the Unlock code :)
Reply
Customer avatar
Dan C April 22, 2020 8:22 pm UTC
PURCHASER
I realize it's been two years since you made this comment but I, too, would love the unlock code. I do not have twitter though. Is there another way you could get that to me?

This thing is great, btw.

Thanks.
Reply
Customer avatar
Lewis P April 28, 2020 12:58 pm UTC
CREATOR
Haha, I didn't think people would still be interested in this document after all this time. I only originally locked it to avoid accidental edits and fear of people stealing the formatting. I will make an update to the files allowing you to download a unlocked version of the file for personal use. As well as any fixes and errors I can spot. Then everyone can use it as they wish. I'll try get it updated in the next couple days.
:)
Reply
Customer avatar
Dan C May 06, 2020 3:45 pm UTC
PURCHASER
It is most appreciated. Thanks again.
Narrow Results
$ to $
 Follow Your Favorites!
NotificationsSign in to get custom notifications of new products!















Product Information
Silver seller
Community Content
Author(s)
Rules Edition(s)
Format
Original electronic Click for more information
Scanned image
These products were created by scanning an original printed edition. Most older books are in scanned image format because original digital layout files never existed or were no longer available from the publisher.

For PDF download editions, each page has been run through Optical Character Recognition (OCR) software to attempt to decipher the printed text. The result of this OCR process is placed invisibly behind the picture of each scanned page, to allow for text searching. However, any text in a given book set on a graphical background or in handwritten fonts would most likely not be picked up by the OCR software, and is therefore not searchable. Also, a few larger books may be resampled to fit into the system, and may not have this searchable text background.

For printed books, we have performed high-resolution scans of an original hardcopy of the book. We essentially digitally re-master the book. Unfortunately, the resulting quality of these books is not as high. It's the problem of making a copy of a copy. The text is fine for reading, but illustration work starts to run dark, pixellating and/or losing shades of grey. Moiré patterns may develop in photos. We mark clearly which print titles come from scanned image books so that you can make an informed purchase decision about the quality of what you will receive.
pixel_trans.gif
Original electronic format
These ebooks were created from the original electronic layout files, and therefore are fully text searchable. Also, their file size tends to be smaller than scanned image books. Most newer books are in the original electronic format. Both download and print editions of such books should be high quality.
File Last Updated:
July 22, 2023
This title was added to our catalog on June 20, 2016.