Decades of spreadsheet records cleaned and moved into one searchable database
- The situation
The cemetery office kept burial records in a new spreadsheet for each era or clerk. Names, dates and plot numbers were written differently in each, and some burials were typed in twice. Families asking where someone is buried waited while staff searched file after file.
- What was built
All six files are read, names, dates and plots are standardized, and rows that describe the same burial are merged, with every row accounted for. The search finds close spellings, maiden names and nicknames, and shows each plot on a map of the section and the grounds. Every correction is listed by type.
- The result
4,608 spreadsheet rows became 4,327 burial records, with 220 duplicates merged.
- What the client received
The records search, the staff cleanup report, the migration script and its log, the cleaned records file and the six original spreadsheets.
Try it Type a last name such as Petersen and open a record.
Describe your project and we will send you a fixed-price quote.