Skip to content

Tech Speckles

Smart Column Cleaner — Help & FAQ

Tools

De-Duplicate Cells (by Column): select one column → removes/marks duplicates based on mode.
Clear Duplicates Within Each Row: select 2+ adjacent columns.
Trim Whitespace: removes leading/trailing spaces.
Change Case: lowercase / UPPERCASE / Proper Case.
Remove Non-ASCII: removes emojis and non-ASCII characters.

Duplicate modes

blank – set duplicate cells to empty.
highlight – keep values and mark duplicate cells pink.
remove rows – keep the first occurrence and move later duplicate rows to a new sheet (“Removed by SCC — …”).

Options:

Header row keep — when Row 1 is in your selection, it isn’t compared or changed.
Ignore blank keys — empty/whitespace-only keys are skipped (not treated as duplicates).
Case-insensitive + trim — values are compared after trimming spaces and lower-casing.

These apply to both De-Duplicate Cells (by column) and Clear Duplicates within Row.

Quota & Pro

Free tier allows cleaning up to 300 cells/day. Pro users have no daily limit.

Troubleshooting

“Select exactly one column” → your selection must be a single column.
“No duplicates found” → try removing extra spaces first using Trim.
Connection lost → close and reopen the sidebar.

Need more help? See Support.