Inspect spaces and split combined CSV fields safely

Step-by-step approach

First run Whitespace Report to identify mixed spaces in the source.
Decide whether a column consistently uses a literal separator.
Use CSV Split Text Column to split at the first matching separator.
Review rows without the separator; they keep an empty right-side value.
Check headers and quoted fields before importing the exported CSV.

Try the matching tool

Open CSV Split Text Column to work on a local copy. Review the result before importing it elsewhere.

What this does not solve

Browser tools can validate known structures and transform available data, but cannot restore deleted or corrupted bytes, infer unknown business facts, or guarantee that a target system will import every field as intended.