Ever wish you could track changes in a Google Sheet without digging through version history or installing clunky add-ons? The Change Tracker Tool logs edits to a selected range and shows you exactly what changed and when.
🚀 What This Tool Does
🔎 Monitor a selected range in any Google Sheet
🧾 Capture before/after values whenever edits are made
📋 Log each change with timestamp and cell location
✅ Track changes across collaborators or time periods
🧠 Use Cases
- 👨💼 Audit changes made by collaborators
- 🏫 Track student edits in shared assignments
- 💼 Monitor financial, HR, or project data logs
- 🧪 Detect accidental changes or overwrites
🔐 Secure and Private
- ✅ Your data stays in your account
- ✅ No add-ons or third-party apps
- ✅ 100% script-based inside Google Sheets
Set the watch range and the log sheet once; the script records edits automatically.