DCFS Migration Tool

1

Select Excel File

Choose the exported legacy memorial spreadsheet

No file selected

Select MemorialEnquiryAndEstimate.xlsx

2

Review mapped data before pushing to Google Sheets

#	Ref	Customer	Deceased	Type	Status	Cemetery	Has Inscription	Notes

3

Send transformed records to your Apps Script endpoint

Test Google Sheet URL

Paste your test Apps Script URL here. See setup guide below.

Live Sheet URL

⚠️ This will write to your LIVE tracker. Only do this after testing.

Type CONFIRM to enable

⚙

Preparing…

📖 Setup Guide — How to create a Test Sheet ▼

Open your live Google Sheet:
https://docs.google.com/spreadsheets/d/1_pbyhKL1IElgneBZHFIWG76Cv6hNKdUw0fgSHQjMN6M
Click File → Make a copy and name it "DCFS Memorial Tracker — TEST"
In the copy, go to Extensions → Apps Script
Copy the script from your live deployment (or paste the same Code.gs contents)
Click Deploy → New deployment → Web app
Set Execute as: Me and Who has access: Anyone
Click Deploy and copy the URL that appears
Paste that URL into the Test URL field above