Trim Whitespace in CSV Cells

Remove leading and trailing whitespace from every cell (or selected columns) so values match, join, and sort correctly.

Why this matters

Stray spaces are invisible but destructive. " ada@example.com" and "ada@example.com" look identical yet fail to match in a VLOOKUP, a JOIN, or a de-dupe — so duplicates survive and lookups return blanks.

Spaces sneak in from copy-paste, PDF extraction, and form fields that don’t trim input. You only notice when a join half-works or a filter misses rows you know are there.

TidyCSV trims leading and trailing whitespace across the whole table, or just the columns you choose (handy when one column intentionally contains spaces), reporting how many cells it changed.

How to do it with TidyCSV

1. Load your CSV into TidyCSV.
2. Enable "Trim whitespace" — apply it globally, or pick the specific columns to trim.
3. See the count of cells that were trimmed in the change summary.
4. Export the normalised CSV; values will now match cleanly in lookups and joins.

Before & after

FAQ

Related