Excel is often the first tool municipalities use
For many small municipalities, Excel is the natural starting point for cemetery tracking. It is already installed, staff know how to use it and a table quickly lists burial rights, deceased persons or plots. It is flexible, accessible and inexpensive.
This works while volumes remain manageable and the same person maintains the file. Once several staff members edit it or the information becomes more varied, the spreadsheet starts to show its limits.
Limit 1: information quickly becomes scattered
Over time, a single Excel file is rarely enough. A “clean” copy appears, alongside a “working” copy and a version “for approval”. Cemetery plans remain on paper, burial-right deeds in PDF folders, some information in emails and other details in staff memory.
This creates uncertainty: which file version is authoritative, and is the information up to date? Differences between records become more likely, increasing the risk of error.
Limit 2: linking records to the cemetery plan remains difficult
A cemetery is organized spatially: sections, paths, rows and plots. An Excel table does not inherently provide that visual dimension. To locate a burial right, staff must mentally translate a spreadsheet row into a point on a paper plan.
Switching between a table and a plan slows staff down and makes enquiries from families harder to answer. Seeing plots that are available, occupied or reserved directly on a map fundamentally changes how the information can be used.
Limit 3: searches can become time-consuming
“Where is this person buried?”, “What is the term of this burial right?” or “Does this family have several plots in the cemetery?” These common questions require several pieces of information to be brought together.
In Excel, searches rely on filters, sorting or repeated Ctrl+F searches. This works, but becomes slow and tedious when searching by deceased person, burial right, family, plot, status or burial-right number. A dedicated tool combines these searches in one search bar with an immediate result.
Limit 4: administrative documents stay separate
Cemetery management produces many documents: burial-right deeds, orders, family correspondence and supporting records. With Excel, these are almost always stored elsewhere, in a network folder, on a local computer or in paper binders.
To reconstruct a burial-right file, staff must open the spreadsheet and find the documents in several places. There is no direct link between the data and its documents, creating repeated handling.
Limit 5: staff handovers become fragile
In smaller municipalities, one or two people often hold the cemetery knowledge. The Excel file depends on habits, naming conventions, colours and columns that make sense only to those who created them.
When the main contact leaves, changes role or is absent, some information becomes hard to use. A replacement must work out the file’s logic while doing their job. A shared tool that everyone can understand reduces this fragility.
Limit 6: status tracking needs greater discipline
Burial rights and plots have a lifecycle: available, occupied, reserved, expired, requiring verification or due for renewal. Tracking these statuses in a spreadsheet requires rigorous updates: changing the right cell, at the right time, with consistent wording.
In practice, this discipline is hard to sustain. Statuses stop reflecting reality, some expiry dates go unnoticed and the municipality loses visibility into actual cemetery occupancy.
What should an alternative to Excel offer?
Replacing Excel should not mean adding complexity. A useful alternative for a municipality should provide:
- a simple search by deceased person, burial right or plot;
- a digital map or plan of the cemetery;
- clear burial-right records with complete information;
- the ability to attach documents directly to the file;
- a history or record of changes;
- a shared access for the relevant staff;
- a simple interfacethat is clear and requires no extensive training;
- no overly complex system: a tool that helps rather than creates more work.
What OPUS Cimetière provides
OPUS Cimetière is an online tool designed to meet these needs. It centralizes burial-right and deceased information, displays the cemetery on an interactive map, quickly finds a burial right or person and attaches administrative documents directly to records.
The tool does not replace civil registration work or the municipality’s regulatory obligations. It helps organize, validate and improve access to information currently scattered across Excel files, paper plans and PDF folders.
It is used by municipalities in New Caledonia, in Mainland France and in French Polynesia.
To explore the topic further, also see: Cemetery management software: which features are useful for a municipality? and How can a small municipality manage its cemetery more effectively?