Close
Close
Advanced Search

5e Excel Character SheetClick to magnify
Quick Preview
/gs_flipbook/flip.php?xml=/demo_xml/179753.xml&w=500&h=324
Full‑size Preview
https://watermark.dmsguild.com/pdf_previews/179753-sample.pdf

5e Excel Character Sheet

ADD TO WISHLIST >

This is a simple 5e character sheet for Excel. There are other 5e Excel character sheets available on the internet with higher levels of complexity. Some of them behave almost like character generators. This is not one of those character sheets. This sheet calculates ability modifiers, passive Perception, saving throws, skill bonuses, and that's about it. The rest is up to you to enter manually.

The download is in .zip format and contains one unpopulated character sheet and one of a 3rd level wood elf druid as an example of how the sheet can be used. Both sheets were created in Excel 2007, but they should work in other versions of Excel as well. There is no cell protection enabled in either spreadsheet.

I realize there is a lot more that could be done with formulas to increase automation, but I prefer to keep things simple. If you enjoy Excel and want to make additions or modifications, go for it. If you come up with something nice, make it available here so I can check it out!

Also by Dave Zajac

Adventures

Journey to the Buried Vale: A 1st-Level Adventure Journey to the Summer City: A 2nd-Level Adventure Journey on the Long Road: A 2nd-Level Adventure The Hoarfrost Journeys: An Adventure Bundle
1st-Level Adventure 2nd-Level Adventure 2nd-Level Adventure Adventure Bundle!

Hand of the Wychlaran: A 3rd-level Adventure Hand of the Wychlaran: A 3rd-level Fantasy Grounds Adventure Journey to the High Country: A Hand of the Wychlaran Adventure Supplement The Hoarfrost Journeys: A Fantasy Grounds Adventure Bundle
3rd-Level Adventure 3rd-Level Adventure for Fantasy Grounds Hand of the Wychlaran Supplement Fantasy Grounds Adventure Bundle!

Flight from Fallston Murder in Velen Murder in Velen Descent to Ascension
0-Level Adventure 10th-Level Adventure 10th-Level Fantasy Grounds Adventure 20th-Level Adventure

The Lost City of Tharn
13th-Level Adventure Fantasy Grounds Module Included

Adventurers League Adventures

260870-thumb140.jpg 299977-thumb140.jpg 240487-thumb140.jpg
1st-Level Adventure Fantasy Grounds Module Included 3rd-Level Adventure Fantasy Grounds Module Included 3rd-Level Adventure

240678-thumb140.jpg 240679-thumb140.jpg 240680-thumb140.jpg 240681-thumb140.jpg
3rd-Level Adventure Fantasy Grounds Module Included 3rd-Level Adventure 3rd-Level Adventure Fantasy Grounds Module Included 3rd-Level Adventure

298149-thumb140.jpg 298153-thumb140.jpg 228101-thumb140.jpg 189329-thumb140.jpg
8th-Level Adventure 8th-Level Adventure 8th-Level Adventure 8th-Level Adventure

299978-thumb140.jpg
13th-Level Adventure

Side Treks

Devil's Rest: A Free 3rd-Level Side Trek Roadside Robbery: A 2nd-Level Side Trek
Free 3rd-Level Side Trek 2nd-Level Side Trek

Maps

Cavern Map Pack: Digital maps for your adventures! City Map Pack: Digital maps for your adventures! Dungeon Map Pack: Digital maps for your adventures! Forest Map Pack: Digital maps for your adventures!
Cavern maps for your adventures! City maps for your adventures! Dungeon maps for your adventures! Forest maps for your adventures!

Maritime Map Pack: Digital maps for your adventures! HULB 1-1 Map Pack: Digital maps for Hulburg Rebuilding! Wilderness Tower Map: Digital map for your adventures!
Maritime maps for your adventures! Maps for HULB 1-1 Hulburg Rebuilding! A free map for your adventures!

Cover Packs

Cover Pack I: Covers for your DMs Guild Products Cover Pack II: Covers for your DMs Guild Products Cover Pack III: Covers for your DMs Guild Products Cover Pack IV: Covers for your DMs Guild Products
Covers for your products! Covers for your products! Covers for your products! Covers for your products!

Misc.

5e Excel Character Sheet Excel Adventure Logsheet Arena: A Tavern Game with Dice and Cards Swordfin Games Superbundle!
5e Excel Character Sheet Excel Adventurers League Logsheet Tavern Card/Dice Game Product Superbundle!
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 (5)
Discussions (8)
Customer avatar
Jens L December 04, 2022 10:08 pm UTC
PURCHASER
Hi. Great work and super sheet. Thanks for that. Unfortunately there are some skills where the checkbox does not work. There the Proficiency bonus will not be added to the skill. Is there a chance you can fix that and i can get the new version?
Reply
Customer avatar
Dave Z December 04, 2022 11:55 pm UTC
CREATOR
I'm not seeing the same issue. Which checkboxes are giving you problems, and what version of Excel are you using?
Reply
Customer avatar
Jens L December 05, 2022 7:44 am UTC
PURCHASER
Hi Dave. I am using LibreOffice 7.4.3.2 64bit. The Checkboxes from Medicine, Nature, Perception, Performance, Religion and Survival dont work properly.
Reply
Customer avatar
Dave Z December 05, 2022 5:30 pm UTC
CREATOR
I uploaded a new version that will hopefully work better with LibreOffice.

A note to folks not using Excel: I can't guarantee compatibility with non-Microsoft applications like OpenOffice and LibreOffice. While the sheet seems to be working with them now, there may come a time in the future when things change and compatibility is no longer possible.
Reply
Customer avatar
Jens L December 05, 2022 7:15 pm UTC
PURCHASER
Thanks a lot i realy apreciate it! Now it works.
Customer avatar
Noah E January 22, 2022 6:22 pm UTC
PURCHASER
Hey you may want to change the functions for determining the ability scores. Currently, you use ROUNDDOWN which makes it so that if you have an ability score below 10 it actually ends up rounding up. You may want to change it to FLOOR and change the second factor to 1, which is what I did to get it to work for me.

This is the thing that I saw that explained how to do it for me in case I didn't explain it clearly:
https://answers.microsoft.com/en-us/msoffice/forum/all/excel-round-down/ffbc080e-5b2a-4982-b1ca-4edf3319f427
Reply
Customer avatar
Dave Z January 25, 2022 2:30 am UTC
CREATOR
I thought I fixed this years ago using the INT function, but it looks like I only did it for the Wood_ElF_Druid.xls example file and not the 5E_Excel_Character_Sheet.xls file. Sorry about that. I've uploaded a corrected .zip file.
Customer avatar
Asa M September 25, 2020 2:04 am UTC
I like the AD&D look!
Customer avatar
Michael H April 05, 2020 3:10 pm UTC
PURCHASER
Excellent work! Very useful, easy to edit, plus does some of the work for me. A lot of character sheets online are overly complicated and fancy, but this is perfectly simple. Thanks!
Customer avatar
Tousif A December 11, 2019 2:19 am UTC
PURCHASER
Hey there! Love your character sheet but I just one question: how do you get the proficiency bonus to apply to skills and saving throws?

Thanks!
Reply
Customer avatar
Dave Z December 11, 2019 3:28 am UTC
CREATOR
All you should need to do is click the box next to the skill or saving throw. Once that is complete, it should add the bonus to the result.
Customer avatar
Michael H August 14, 2018 5:05 am UTC
PURCHASER
This is solid gold! Is there anyone out there that's converted the sheet to non-US (A4) size?
Thanks heaps
Mike
Customer avatar
Brandon T April 18, 2017 1:06 pm UTC
PURCHASER
I'd rate the product, but I purchased it off a different account so I'll put my "review" here. In my opinion this is a very nice excel sheet. I wanted to make this review since Alexander M. called it a joke. I'm actually glad it is not completely automated. It makes setting this up for a homebrew MUCH easier and I don't have to fight automated values when making characters that don't follow some of the core rules of D&D.

I'd give it a 5/5 stars, and compared to other excel sheets this sheet is very clean and pleasing to the eye.
Reply
Customer avatar
Dave Z April 18, 2017 2:08 pm UTC
CREATOR
Thanks, Brandon. I really appreciate the review!
Customer avatar
Dave Z October 27, 2016 5:38 pm UTC
CREATOR
In reply to the review by Alexander M.

Alexander,
I’m sorry the character sheet doesn’t fit your needs. The sheet actually does calculate ability modifiers, passive Perception, saving throws, and skill bonuses. It was not designed to calculate anything else. The product’s description is very clear about the level of automation it contains.

If the cells listed above are not calculating properly for you, please let me know what version of Excel you are using, and I will do my best to test it and correct any issues.
Narrow Results
$ to $
 Follow Your Favorites!
NotificationsSign in to get custom notifications of new products!
 Recent History















Product Information
Platinum 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:
December 05, 2022
This title was added to our catalog on April 01, 2016.