Focused purpose
What this tool does
Trim leading, trailing and non-breaking whitespace from selected CSV or TSV columns locally. Highlight changed cells and export without an account.
- ✓ Leading and trailing trim
- ✓ Non-breaking space detection
- ✓ Invisible tab warnings
- ✓ Changed-cell highlighting
Workflow
How to use it
- 01
Open the file and choose columns.
- 02
Select the whitespace rule and preview highlights.
- 03
Confirm the operation and export.
Available controls
Available options
- Choose affected columns.
- Trim edges only or collapse repeated whitespace.
- Remove invisible Unicode separators explicitly.
- Review each changed value.
Padded names and codes
Example before and after
Visible and non-breaking edge spaces prevent exact matching.
Before
name,code " Ada Lovelace ","FR "
After
name,code Ada Lovelace,FR
Expected result: Edge whitespace is removed while the space inside the name remains.
Practical scenarios
Common use cases
Fix failed key joins.
Normalize copied spreadsheet text.
Prepare categorical values for validation.
HONEST LIMITS
Important limitations
- iSpaces inside a meaningful phrase are preserved by edge trimming.
- iWhitespace cleanup does not normalize letter case.
FAQ
Questions about this tool
Will spaces inside names be removed?
No. Edge trimming preserves internal spaces such as the one in “Ada Lovelace”.
Can I trim only one column?
Yes. Column selection is explicit and shown in the operation summary.
Are non-breaking spaces detected?
Yes. They are reported separately and removed only by the matching option.