D&D Maps using Spreadsheets

Ever since I first tried DM’ing, I have jumped from one method to another of creating maps for my D&D games. Recently I was using a Google Doc spreadsheet for something and it occured to me that I could use these to make maps.

What it is

I basically set the spreadsheet to be a small squared grid and apply conditional formatting to the entire grid along with a key of what means what. So once it’s set up, if I type a letter ‘T’ in a square, that square turns dark green and now represents ‘Trees’, same as ‘M’ means mountains and turns grey, ‘V’ means village, ‘C’ means city and shows as orange, and so on.

On top of the basic auto-colour coding mentioned above, you can right click any of the squares and ‘insert notes’ which gives you a text box to include any notes you have about that map-space(like a town name and who lives there)

Why it’s awesome

Super simple, hassle free
You can do it anywhere you like without needing any special software or apps (all browsers run google sheets i’m fairly sure). And it’s as easy as typing letters into a spreadsheet.

Can be shared easily
You can share it with friends thanks to the great sharing functions of google, you could even work on it at the same time as someone else(if you’re brave enough to try co-DMing).

You can use the same method for world maps, town maps and dungeon maps. You could even make multiple pages of the documents for different levels of a dungeon.


I know not everyone is as into making spreadsheets as me, so below is a link to an example world map and city map (tabs down the bottom for different pages)

Example spreadsheet mapping

You should be able to click ‘File >> Make a copy’ to copy it and edit it yourself.

Other things you could do

- Hyperlink the letter to a google doc or another page in the spreadsheet
- Use symbols instead of letters, works well for dungeons, you could have slashes for up/down stairs etc.

Let me know

If you use this method please let me know how it goes for you, if you find this article confusing i’d love to hear about it so I can fix it up to make it more useful.

Dungeon Crafting: Puzzle Dungeons

image source: Legend of Zelda: Oracle of Ages

Now, I don’t know if you people have seen Mark Brown’s miniseries on YouTube known as Boss Keys, but it’s pretty great. It picks apart and analyzes some of my favorite dungeons from the Legend of Zelda games and finds out what makes a dungeon a Zelda dungeon. I have always loved these dungeons because they have a lot of density and force you to explore the space slowly and think your way through its puzzles. Definitely check out Boss Keys. From what I learned from those videos plus my own experiences as a DM, I’m going to try and detail how to create a Zelda-like puzzle dungeon. There are a few hallmarks that you should hit on:

Dungeon Density

Each area in the dungeon should be complex. It should have several things to interact with in each room other than the monsters or guardians. Everything doesn’t have to be immediately useful or usable, but it should provide context for the dungeon. For ideas, think what the dungeon was used for and research what sorts of things might be in an ancient tomb, lost temple, or forgotten keep. Have certain puzzle elements stand out. A good example from the Legend of Zelda is the eyeball above a closed door. I would stray away from that type of “puzzle” as it’s very well-known, I assume, that you have to hit the eye to open the door. On the other hand, a well-known puzzle like that could signal to the players that this is going to be one of “those” dungeons.

Making a dungeon complex and dense will mean that you have less rooms to populate, and will make it feel robust and well-used. It will also give a feeling of slight confusion for the players as they try to organize all of the information you’re giving them, but as the dungeon progresses, they can pick and choose which parts of the dense dungeon are integral to solving the dungeon!

Hub Areas

With all of that dungeon density I’ve been talking about, it’s good to have some sort of hub area. It could be a large room, a safe sanctuary, or have some overbearing landmark for players to imprint on. This will be the main part of the dungeon that they remember and can rely on. They will pay the most attention to this hub. So if this hub is a main part of solving your dungeon puzzle, they will notice changes made to the room very easily. For instance, a hub room could be a gaping chasm with bridges that seem to be mechanical. When certain levers in other parts of the dungeon are pulled, some pathways in the hub open up and some close off as the bridges ascend, descend, or turn. Back in my post about dungeon tempo, this creates a nice rhythm for players to always come back to a room that they’ve cleared and notice progress.

Branching Paths

Branching paths are a key part of puzzle dungeons. Don’t have a dungeon that is all one path that railroads players to the end of the dungeon with a puzzle for each room. Players need to be able to explore and discover the available paths in the dungeon and find the path for themselves. In the Boss Keys miniseries I mentioned, Mark constantly differs Legend of Zelda dungeons by whether they make you find a path versus making you follow a path. I personally enjoy finding the path and I think most players do too. It is key in creating what are known as…

A-Ha Moments

An a-ha moment is not that feeling you get when listening to Take On Me, but it’s pretty close. It’s that feeling a player gets when they figure out a puzzle by suddenly putting two and two together. There are a few aspects to create this in dungeon and level design:

  • Foreshadowing: implying that one part of the dungeon must be revisited later or implying something further in the dungeon exists. Laying this groundwork puts thoughts in players’ heads to help them markedly acknowledge that it’s okay to leave this area, because something lies ahead.
  • State Changes: the environment of the dungeon or its parts changes based on the actions of the players. This is the “puzzle” part of the a-ha moment. Pressing a button to change gravity, move a pylon, or change water levels can would count as a state change. Even acquiring a key item that can affect the dungeon or the players’ movement would count (see Link’s Pegasus Boots, Hover Boots, Silver Gauntlets, etc.)
  • Backtracking: After the state change, the dungeon has shifted. Some areas that were once inaccessible can now be accessed, and areas that were once open have closed off. This forces the players to backtrack. Where do they backtrack to? The place that foreshadowed the backtracking.

How does this look in practice? Let’s make an example:

The players enter a dungeon and quickly make it to a hub area with four doors. three of the doors have a bridge extending from it to a central platform. The platform and bridges are 100 ft. above a pit of spikes, which are very satisfying to kick the kobolds in this room onto. Once players tire themselves of punting kobolds, they notice that the central platform has a large plinth with a stationary mirror set into it. The mirror is facing one of the directions of the bridges. The mirror can’t be easily moved without tools, and it has no apparent use yet. The players move on to one of the doors connected by the bridge.

The players go through several chambers, fighting monsters and avoiding traps, when they find a room with a lever in it. When pulled, they hear a low rumbling and grinding of stone elsewhere in the dungeon. When they return to the hub room, the central platform and bridges have rotated, allowing passage to the door that didn’t have a bridge leading to it before.

Down this new route, the players find a stone button with an angel relief on it. After pushing a huge rock onto it, they hear another rumbling. On returning to the hub room, an angel relief is now visible on the wall as a stone slab has moved away to reveal it.

The yet unexplored room is still accessible by the bridge, and after exploring down that path, the players find a crank near a gilded relief of a sun. The crank opens up a sunroof in the hub area. The sun (if daytime) shines light onto the central mirror in that room, which then reflects it out in one direction. The only problem is, the beam of light from the mirror isn’t facing the way the PCs want (towards the revealed angel relief in the hub area).

Realizing that they need to point the mirror so the light shines on the angel relief, they must backtrack to the room with the lever that rotates the bridges and mirror until the mirror is oriented the way they want.

This example has density. It’s essentially four rooms with all the things they need to solve a puzzle in the hub area (the central room with the bridges). It could use more density though with more puzzle intertwined throughout some filler rooms or with more things to do in each room; I was light on description for the purpose of the example. It has three branching paths (four if you include where they entered from). The mirror foreshadows a light puzzle, and the sun icon foreshadows the opening of the sunroof. The bridges, angel relief, and sunroof all exist in the hub area and change states based on the players’ actions in the rest of the dungeon. Players have to backtrack to the room that changes the bridge orientation so they can rotate the mirror to face the right direction. This is a fairly simple puzzle, but in the context of a session of D&D where the story less shown and more told, it can prove more difficult. Keep all of these factors in mind when making a puzzle dungeon, and don’t forget to watch Boss Keys!


Accumulated scene setting sketches from my D&D story Necropolis, which my players finally finished today.

My favourite thing is that the last pic – the final boss battle – was absolutely not supposed to have a giant baobab tree growing through it. But instead of knocking on the door like normal people, my players made a more… creative entrance


My Etsy store is live!!

Check it out and to buy these cool patches (or to work with me to create a custom badge!) and to support me as I save up for the next semester of school. I’m running dangerously low on money, so anything will help!! Thank you!

🌵  | 💯  | 🎲  |  🏙️


when did we drift so far apart? (insp)

My thoughts on ‘Tales From The Yawning Portal’

I received my advance copy of @dndwizards​’s new book Tales from the Yawning Portal not quite a week ago. If you haven’t heard of this book here’s the gist of it:

TftYP is a collection of seven ‘classic’ dungeon adventures from D&D editions past, all updated with fifth edition rules. In this book you get…

  • Against the Giants (AD&D)
  • Dead in Thay (D&D Next)
  • Forge of Fury (D&D 3e)
  • Hidden Shrine of Tamoachan (AD&D)
  • The Sunless Citadel (D&D 3e)
  • Tomb of Horrors (AD&D)
  • White Plume Mountain (AD&D)

All of the maps and layout have been updated to make them easier on the eyes, while their traps, monsters, structure, and challenges remains largely unchanged. TftYP is a ‘best of’ book, rather than a remake or reboot of these adventures.

If you’re a millennial who got into D&D through things like Acquisitions Inc, The Adventure Zone, or Critical Role, my take on this book is gonna be of interest to you…because this book might be specifically FOR YOU.  

Originally posted by ewzzy

Keep reading