How to do it
- Drop your CSV file on CSVFix.
- Keep Trim spaces on. CSVFix turns non-breaking spaces into normal spaces and then trims the cells.
- Keep Collapse repeated spaces on to merge double spaces.
- Check the yellow cells in the preview, then download the result.
Why they cause problems
Excel’s TRIM function only removes the regular space character, so cells that contain non-breaking spaces still look different from clean ones. Two values that appear identical may not match because one has a hidden character.
Questions
Does it remove other invisible characters?
Not yet. Zero-width spaces and similar characters are not removed.
Why do two identical values not match?
One may contain a non-breaking space. Changed cells appear in yellow in the preview, and hovering shows the original.
Does it change spaces inside sentences?
Non-breaking spaces become normal spaces. Repeated spaces become one only if Collapse repeated spaces is on.
Ready to clean your file?
Clean your CSV now