Close
Close
Advanced Search

Excel Statblock Monster TemplateClick to magnify

Excel Statblock Monster Template

ADD TO WISHLIST >
Suggested Price $0.00

Basic Information and Purpose

This is an Excel template for single-column monster stat-blocks.  I began this project for myself, but figured that I might as well also make it easier for other people to generate their own stat-blocks.

Fonts and IP

This template uses the Tex-Gyer-Bonum (TGB) free font mentioned in the official Adventure Template ( /product/170830/DMs-Guild-Creator-Resource--Adventure-Template?src=newest&filters=0_0_45476_0_0_0 ) .  Other fonts were mentioned in that template, but after testing, I found that plain old Arial worked just fine and ends up printing better.  The TGB font is used only in the creature name top line.  The sample creature is found in the Wizards of the Coast SRD.

Compatability

  • The Excel version used when creating this for template was 2016 (part of Office 365).  It would probably work fine with recent earlier versions, but I have not tested that.
  • Reddit user Shylocv has indicated that it did not work in Open Office, but does work in Google Docs.
  • I may or may not update for Open Office in the future.  Since Google Docs works, I'm less inclined to do so unless I see a large number of requests.

Usage

Note that there are 3 tabs in the workbook.  One is an example monster which appears in the SRD (Cloaker).  One is a plain scaffolding of a statblock along with comments. The last tab is simply the color palette used.

Personal

If you want to throw some bones my way via Pay-What-You-Want, that's cool, but if not, that's cool too.

Enjoy!

pixel_trans.gif
pixel_trans.gif
 
 Customers Who Bought this Title also Purchased
pixel_trans.gif
pixel_trans.gif
Reviews (7)
Discussions (10)
Customer avatar
John M August 22, 2019 1:13 pm UTC
PURCHASER
Thank you for posting this, I was able to use it with my own work.
Customer avatar
Brandon C January 10, 2019 12:01 am UTC
PURCHASER
Is it possible to have a Docs link? I don't use either Word or Excel and Docs makes it easier to share with friends
Customer avatar
Marshall R April 01, 2018 1:51 am UTC
PURCHASER
download went fine but for some reason after i extract the file it wont open. anyone else experience this?
Reply
Customer avatar
Marshall R April 01, 2018 1:56 am UTC
PURCHASER
tried a few different app options for opening and word said the file was corrupt?!?
Customer avatar
Justin J November 27, 2017 9:27 pm UTC
i'd pay 5 minimum for open office update.
Customer avatar
MARK S May 17, 2016 2:12 pm UTC
I really wish there was an OpenOffice Spreadsheet version of this template. I don't have Excel, and will never get it because it costs too much.
Customer avatar
Anthony T May 17, 2016 1:46 am UTC
PURCHASER
This template doesn't work, when trying to edit something I can't type anything in. Whatever is typed instantly disappears. I see what you're going for, but DMG creators need more than just an example block. If we wanted that, we could pull up a monster from the Monster Manual. Being able to edit it and copy past to a word doc would be super helpful. If that could be done, this is something I would gladly pay for.
Customer avatar
Lawrence S March 06, 2016 8:39 pm UTC
PURCHASER
HI, do you guys know a good template for making a campaign supplement?
Customer avatar
Mark J February 24, 2016 2:51 pm UTC
PURCHASER
I couldn't get this to work in Google Docs. :(
Reply
Customer avatar
Wiley L January 11, 2017 8:21 am UTC
PURCHASER
I was able to get it to work in Google Docs. It imported okay when opened in Google Sheets. However, when printing the upper half was blank. There are a bunch of tiny cells in the upper half e.g. the creature name is in cells C3 through AS3. I got these rows to show up during printing by merging cells. Merge C3 through AS3 (I think) to get the name to show up. The attributes are the trickiest. I merged chunks of 4 cells but I had to move things around to get them to line up. Worth the effort.
Customer avatar
Brian F January 26, 2016 5:15 am UTC
PURCHASER
I am having difficulties exporting the statblock into Word once I am done with it, additionally the formatting freaks out when you try to add rows for Saving Throws and Immunities and the like. D you have any advice for this?
Reply
Customer avatar
matt N January 26, 2016 6:50 pm UTC
CREATOR
Hi Brian - let me see what I can do about the Word portion (not sure about this). When I'm home I'll look at those other parts as well - Do you have a monster in mind from the monster manual that I can use to model those rows?
Reply
Customer avatar
Brian F January 26, 2016 7:43 pm UTC
PURCHASER
Yeah. First creature to come to mind is an undead. Shadow for example. If there was a way to format it to add the rows you need and remove the ones you don't that'd be grand. Thanks Matt!
Reply
Customer avatar
matt N January 26, 2016 11:57 pm UTC
CREATOR
OK, a couple things.

1) Pasting into MS Word - I see what you mean about it freaking out, and while I don't have a great solution, I do have *a* solution. Hopefully this helps: http://imgur.com/a/ycXXr

In short, select all the cells from the top left of the header line to the bottom left of the footer line. Copy that. Then, in MS Word, right click, and choose the 2nd-to-last option for "paste picture".

You'll have to make it look nice in Excel first, but at least then the resulting display in Word will be OK, as long as you're OK with it being a single image that cannot span pages.

2) Regarding adding/deleting info. I've tried a couple things, and didn't have trouble with this. Perhaps we're going about this different ways? In particular, when you delete a row, you shouldn't select the cells (e.g. B18 through AS18). Instead, select *all* of row 18. Then delete.

For adding rows, I recommend copying a full existing row (e.g. Row 18),...See more
Reply
Customer avatar
Brian F January 29, 2016 1:54 am UTC
PURCHASER
Those fixes are perfect! Thank you.
Customer avatar
MARK S January 25, 2016 4:49 am UTC
Would it be possible to have this converted to use with OpenOffice Spreadsheet?
Reply
Customer avatar
matt N January 25, 2016 2:34 pm UTC
CREATOR
Hi Mark - someone reported that, while it doesn't work in OpenOffice, it does work in Google Docs. So, I'm pushing off doing this for OpenOffice immediately, as Google Docs should interpret it for now.

That having been said, when I get a little free time I may see about doing that conversion.
Reply
Customer avatar
MARK S January 27, 2016 2:20 am UTC
That would be great. I don't use Google Docs because I have to be on the internet to use it. I prefer OpenOffice because I don't need to be on the internet, especially at the game store I DM at.
Reply
Customer avatar
matt N January 27, 2016 4:26 am UTC
CREATOR
> I prefer OpenOffice because I don't need to be on the internet, especially at the game store I DM at.

Hi Mark - that's a great point (plus, who doesn't like Free Open Source Software!?!). I think that because of that, it's a worthy cause. So, while I won't make promises in terms of timing, I'll see what I can do!
Reply
Customer avatar
Mark Z January 27, 2016 1:15 pm UTC
PURCHASER
Mark S, you can use Google Drive in offline mode, if you can connect to the internet and enable the feature. https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=use%20google%20drive%20offline
Browse Categories
$ to $
 Follow Your Favorites!
NotificationsSign in to get custom notifications of new products!















Product Information
Gold seller
Community Content
Author(s)
Rules Edition(s)
Pages
3
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:
January 24, 2016
This title was added to our catalog on January 24, 2016.