You’ll also have all the previous rows recalculate. Add a “6” to the cell A12, and you’ll randomly generate a new magic item. You may not be able to see any content below A11 where it says “5” in the spreadsheet cell, but there are formulas in place. This is good as it means you don’t need to type anything here, just pick what you want and the sheet will take your requirements into its calculations.

You’ll notice that your copy of the spreadsheet has some dropdown arrows in the boxes for Campaign Mage Setting and Source. Once you’ve completed the data entry of your party details, this is the tab that you use to operate the spreadsheet. This will help work out the average party level so the sheet and calculate an appropriate item for them to find. In the tab “Party Composition” summarise your brand of adventurers. You only need to use the first two tabs Party Composition and MIRG to make use of the spreadsheet. You may just need to know what the heroes find in the treasure room after swinging by to clear out an evil temple. You might be creating a whole party of NPCs. You might be starting off your D&D adventure with characters higher than level 1 and want to know what magic items they should start with. Generator like this are useful in all sorts of circumstances.

This means you can mess up your local copy, so it’s okay to experiment madly, and you’ll always be able to come back to the original to take a fresh update. Why? This master version needs to remain intact. You won’t be able to use the magic item generator until you go to “File -> Make a Copy”. The starting point is this spreadsheet which you copy for yourself. Redditor u/isitaspider2 has put their skills with Google Sheets (and its filter command), vlookups and knowledge of all the magic items in 5e together to produce a magic item reward generator.

Network magic key generator