Toolvore

CSV Cell Cleaner

Clean whitespace and letter case in selected CSV columns, preserve text IDs and review exact change counts locally.

This tool processes its input contents in your browser instead of sending them to a processing service. Page, asset and fixed usage-measurement requests are described on the Privacy page.

Trim, collapse whitespace or change letter case in selected CSV columns, with exact change counts and text IDs retained.

How to use it

  1. 1Paste or open UTF-8 CSV, choose its delimiter and read columns.
  2. 2Select the columns and enable the cleaning operations you want.
  3. 3Review changed cells, then copy or download CSV and the count report.

Example

Input
id,name 001," Mira "
Output
id,name 001,Mira

Select the name column and keep the default trim operation. One cell changes; the leading-zero identifier and headers remain unchanged.

What happens to your data

Cell values and before/after previews stay in this tab. Optional usage records contain fixed outcomes and result actions, excluding your data.

Last updated November 2026

Clean CSV whitespace or letter case in the columns you choose. Paste a table or open a local file, read its headings and select the cells that should change. The CSV Cell Cleaner leaves headers, unselected columns, row order and text identifiers intact. A name such as two spaces followed by Mira can become Mira while the ID 001 stays 001.

How it works

Each selected cell is processed as text. Trimming removes JavaScript Unicode whitespace from the beginning and end. Optional whitespace collapsing replaces each run of whitespace, including tabs and line breaks inside quoted fields, with one ordinary space. Case conversion then applies locale-independent Unicode lowercase or uppercase. These operations run in that order. Case conversion can change text length, such as uppercase ß becoming SS. It does not infer a language or preserve every language-specific casing rule.

Only the enabled operations run. Internal spacing and multiline fields remain intact unless you deliberately enable collapsing. No column is converted to a number, date or boolean. The tool does not guess misspellings, resolve aliases or remove duplicate records. Use CSV Value Mapper for a reviewed dictionary of exact replacements, or CSV Deduplicator after you have reviewed cleaned data.

The result gives changed-cell and changed-row counts. An unchanged cell does not count as a change even when an operation was applied to it. The expandable before-and-after view shows the first eight changed cells, with long text abbreviated; it is a preview rather than a complete value-level audit. The full CSV contains every resulting cell. When no selected values change, an explicit unchanged result still provides a CSV download.

Use UTF-8 input up to 500 KiB, 10,000 records including the header, 128 columns and 200,000 cells. The output is limited to 2 MiB, 10,000 records including its header and 200,000 cells. Comma, semicolon and tab delimiters are supported; choose the correct delimiter explicitly. Each header must be nonempty and unique. Invalid quotes or unequal record widths stop processing instead of silently repairing the table.

CSV output uses UTF-8 without a byte order mark and CRLF record endings. Quoting may be rewritten while logical cell text is preserved. Formula-like text is not prefixed or removed automatically; spreadsheet applications can interpret such text as formulas, so review the file and import columns as text where appropriate. The downloadable JSON report records operations and counts rather than original cell values. Processing happens in this browser tab.

Worked example: Trim a name without converting its ID

Input
id,name 001," Mira "
Result
id,name 001,Mira

Select the name column and keep the default trim operation. One cell changes; the leading-zero identifier and headers remain unchanged.

Common use cases

  • Remove invisible boundary spaces before importing names or status codes.
  • Standardize chosen text columns without altering leading-zero IDs.
  • Deliberately collapse copied tabs or multiline spacing in selected cells.
  • Review how many records changed before comparing or deduplicating exports.

Frequently asked questions

Will cleaning CSV spaces remove leading zeros?+

Cells remain strings. Trimming the text 001 leaves 001 unchanged; it never becomes the number 1. Only whitespace and case operations you enable affect selected cells.

Can I clean only one CSV column?+

Yes. Read columns, select that column and uncheck the others. Header names and all unchecked cells remain unchanged.

Does trim remove spaces between words?+

Trim removes boundary whitespace. Enable the separate collapse option to replace internal whitespace runs with a single space. Collapsing also changes tabs and line breaks inside quoted cells.

Are formulas changed for safety?+

Formula-like text is retained unless a selected cleaning operation changes its whitespace or letter case. No apostrophe is added automatically. Review the formula-like count and import the file as text when necessary.

What does no change mean?+

None of the selected logical cell values changed. CSV quoting, the BOM and record endings may still be normalized on export, so this is not a byte-identical file claim.