Chronicle

Thank you for downloading...

Please check your email inbox from Chronicle to get your cemetery plot map templates.

Did not receive the email?

Download the files here…

How to Use the Cemetery Plot Map Templates

Please note the the Excel files contain Macro. Make sure that you have enabled the Macro on your Spreadsheet software. Otherwise, the file will not work properly. If you are using Microsoft Excel software, read this article to see how to activate the Macro on Excel. Then, you should unblock the Macros of the file templates by following this instruction.

The Simple Cemetery Plot Map Template

The simple cemetery plot map template contains two main parts:

  • Map sheet: Here, you need to create a grid layout of your cemetery in Excel and give every plot a unique identifier. A good way to do this is by using Google Earth to get a layout of your cemetery and then replicate it in Excel. Feel free to divide the plots by section, religious group, or roads.
  • Name Input Registry: This is where you will put all the information about the people buried in the cemetery and other related data. There is a field labeled ‘No’ in this sheet, which is a unique ID that links to the Map Sheet.

In the upper left corner, there is a box labeled “Information.” This box has a formula that pulls details from the Name Input Registry sheet. This means you do not have to switch between sheets all the time. If you click on boxes with numbers, the corresponding information will show up.*

Now, let us make your own Excel cemetery map:

  1. Once you have finished creating the Excel grid to resemble your cemetery, you can begin assigning unique IDs to the corresponding boxes so that every grave has a unique ID. See the picture in the right-hand section.
  2. Then, go to the Name Input Registry sheet and start filling in the details. Make sure to fill in the number, name, section, row (lot), and plot (grave) for each entry. If you come across a grave whose location is not known, you can leave the section, row (lot), and plot (grave) fields blank. Just remember to add a note to say that these details are not available.
  3. That is all! You can switch between adding numbers in the Map sheet and adding details in the Name Input Registry as you like. Changing the color coding can also help you visualise your cemetery better.

 *This is where the Excel macro is found. If you cannot turn on the macro, this feature will not work, but the rest of the Excel file will still be usable.

free cemetery plot map template

The Advanced Cemetery Plot Map Template​

The advanced cemetery plot map template contains three main parts:

  • Whole Map: This is a broad representation of your cemetery’s layout. You might find that the cemetery is divided into sections like A, B, or C, or perhaps by religious group. An easy way to do this is to use Google Earth to take a screenshot of your cemetery and annotate the sections. This will serve as your “Section Map.” If you are not sure about the exact boundaries, a rough sketch will work too.
google earth map

A screenshot from Google Earth

annotated map free cemetery plot map template

Annotated Section Map

  • Section Map. This is where you will attempt to recreate the section on your cemetery using an Excel grid. We have already provided you with a simple template that corresponds with part 3 of the Excel map (Input Entries), so you just need to copy and paste as many rows as you have in your section. We understand that having a straight row is rare and usually the rows are not straight. Please try your best to visualise the rows in a straight line. For example, we can use Section F. Section F has 8 rows, as stated below. That means you need to create 8 rows in your Section Map. You can simply copy and paste them into the Section F sheet.

PS: If you have a section – lot – grave numbering system, you can copy paste the Section Map accordingly, but it is going to be a lot of editing. We suggest you to use the Simple Template. 

row visual

A visualisation of the rows

A grid map that represents rows in Section F

  • Input Entries: These sheets are where you input all of the information, both interments and ROI (deeds). These sheets contain information for only one row, so you can duplicate them depending on how many rows you have in the section. We recommend color-coding the sheet per section to help you navigate them faster. We have created the Excel using formulas so that when you enter information on these sheets, the information will be reflected on the Section Map you just made in Part B.

    Let us try to input details for Section F Row – 1. There are 3 components in this sheet:

    1. Columns A-D contain plot information. Fill them sequentially for easier navigation.

      Column E (surname) also serves as plot status. When you fill in the name, it will appear in the Section Map. When it’s reserved, it will automatically change the color to yellow for easier color-coding on the Section Map.

    2. Columns E-P contain interment details. Fill them accordingly.

    3. Columns Q-X are for ROI (deeds) details. You can add the details of the person purchasing the plot here

 Important Note for Advanced Template:

  • Every time you copy paste additional rows in the Section Map, please check the formula and change the Sheet accordingly.
Code
  • It is important to have a unique row-plot no. This is your grave unique id so each graves can be correlated to the specific entries
  • If you have more than 2 interments in one grave – you can simply insert a new row. Don’t forget to also insert a new row in the Section Map

Congratulations on taking the first step to your digital cemetery!

Feel free to reach out to us when you need assistance in using the template or you are ready to move forward in digitising your cemetery maps and records with us. At Chronicle, we create a digital mirror of your cemetery maps and records—easy and simple!

Translate »