Skip to main content
CSV First Aid

CSV whitespace trimmer — remove leading & trailing spaces

A single trailing space is why your VLOOKUP misses, why two rows look like duplicates but aren't, why the join silently loses half the records. One pass trims every cell — matches start working again.

Whitespace trimmed

Before

  John , 25 ,  NYC

After

John,25,NYC

Drop your CSV file here

or click to browse

The "whitespace" fix will be auto-detected.

What is this and why does it matter?

Extra spaces at the start or end of cell values are invisible but cause real problems. 'Alice' and ' Alice' look the same in your spreadsheet, but VLOOKUP won't match them, filters miss records, and duplicate checks fail. It's incredibly frustrating because everything looks correct.

These hidden spaces sneak in from copy-pasting, manual data entry, and exports from other systems. A single extra space in a key column can break all your lookups and formulas.

CSV First Aid checks every cell in your file and removes spaces from the beginning and end. Spaces between words (like 'New York') are kept exactly as they are.

How it works

  1. 1Drop your CSV. We scan every cell for hidden leading or trailing spaces.
  2. 2The diagnosis card shows how many cells have extra spaces.
  3. 3Apply → cells are trimmed. Download.

FAQ

Does this remove non-breaking spaces (NBSP)?

Non-breaking spaces (U+00A0) are handled by the invisible character cleaner. For best results, enable both 'Invisible characters' and 'Whitespace' fixes — the invisible char fix runs first and converts NBSP to regular spaces, then the trimmer cleans them up.

What about tabs and newlines inside cells?

Leading/trailing tabs are trimmed. Newlines within quoted multi-line cells are preserved since they're typically intentional.

Will this trim spaces from empty cells?

Yes. A cell containing only spaces becomes an empty string. If you also enable the empty-row remover, rows that become fully empty after trimming are cleaned up.