Smart Column Cleaner
Clean messy sheets in seconds: De‑duplicate, Trim whitespace, Change case, and remove Non‑ASCII/emoji. Everything runs inside Google—no external servers.
Features
- De‑Duplicate Cells (by column) — keep first, blank/highlight, or shift-left.
- Clear Duplicates within Row — remove duplicates across selected columns.
- Trim whitespace — removes leading/trailing spaces.
- Change case — lowercase / UPPERCASE / Proper Case.
- Remove Non‑ASCII — strip emojis and odd symbols.
How it works
- Open a Google Sheet → Extensions → Smart Column Cleaner → Open Cleaner.
- (Optional) Click (change) to choose your duplicate mode.
- Select a range/column and run a tool.
Privacy & pricing
Free plan: clean up to 300 cells/day. Pro plan removes limits. The add‑on processes data only within your Google account and stores lightweight settings in document properties. See Privacy and Terms.