CTS Guard for Google Sheets™
Check rosters and class lists before they are shared
Class lists, contact sheets, and activity rosters are edited by many staff members. CTS Guard reviews the tab in Google Sheets™ and reports what looks off.
Installs from the Google Workspace Marketplace™. Runs inside Google Sheets™, nothing to upload.
Rosters change all year
Students move sections, contacts get updated, and exports get pasted into working tabs. The formatting drift shows up when a list needs to be shared or imported.
- The same student listed twice after a section change
- Contact emails with stray spaces
- Dates entered as text
- Exports pasted in with extra header rows
What CTS Guard checks
- Duplicate rows, exact and near matches
- Email and name formatting inconsistencies
- Dates stored as text or mixed formats
- Whitespace inside cells
- Empty rows and columns
- Header structure that blocks an import
How it works inside Google Sheets™
- 1Open your sheet in Google Sheets™ and launch CTS Guard from the Extensions menu.
- 2Run a check. Guard scans the tab and shows what looks off, before anything changes.
- 3Apply the fixes you want. Your original values stay in the sheet until you approve a change.
Sheets schools teams already have
Class and section lists
Duplicates created by mid year moves.
Contact sheets
Inconsistent phone and email formatting.
Activity and club rosters
Pasted exports with spacer rows.
Attendance trackers
Dates stored as text so sorting fails.
Safe to send
Share a list internally without duplicate rows and formatting noise.
Import ready
Check the sheet before importing into another school system template.
Available on the Google Workspace Marketplace™
Clean That Sheet Guard™ is published as a Google Workspace Marketplace™ add-on and installs directly into Google Sheets™. It reports what it finds before anything changes, and your original values stay in the sheet until you approve a fix.
- Installed from the Google Workspace Marketplace™
- Runs in a side panel inside Google Sheets™
- Nothing to upload to use Guard
- Operated by Almeyda Holdings LLC
Check the roster in the sheet you already use
Install CTS Guard from the Google Workspace Marketplace™ and run a check on a roster tab.
Installs from the Google Workspace Marketplace™. Runs inside Google Sheets™, nothing to upload.
The FAQ
CTS Guard for other teams
“We've found this tool to be a great fit for the kind of spreadsheet work we do at Lombard Toyota. It helps turn large, messy data exports into something much easier to read and work with, without requiring a lot of manual cleanup.
What we especially like is that it seems to understand the structure of dealership data instead of treating every column the same. That saves time and makes the finished spreadsheets much more useful for our day-to-day work.
Definitely a helpful tool for an automotive dealership working with a lot of data.”
Lombard Toyota
Google Workspace Marketplace™ Review, August 13, 2026