Cleaning should not invent meaning
Trimming cells or removing empty rows is mechanical. The tool does not assume Tokyo and 東京都 mean the same thing or rewrite business values based on guesses.
Free browser tool
Clean whitespace, blank rows, duplicates, and null markers, then remove, reorder, or rename columns with preview. Supports UTF-8 / Shift_JIS input.
Clean common structural mess—leading/trailing spaces, blank rows, and exact duplicate rows—before importing a CSV. The tool applies explicit cleanup choices rather than guessing what values “should” mean.
Trimming cells or removing empty rows is mechanical. The tool does not assume Tokyo and 東京都 mean the same thing or rewrite business values based on guesses.
Two rows are duplicates only when their full cell sequences match. Same ID with a different timestamp is still a different row; key-based deduplication is a separate job.
An empty cell, NULL, N/A, and - are distinct strings. Normalize them only when your data contract says they mean the same thing.
A UTF-8 BOM can help some Windows Excel workflows recognize UTF-8. It does not change the logical cell values. Follow the receiving system’s BOM rule when one exists.
Trim and deduplicate a catalog export before upload, then compare the row-count change with what you expected. A surprisingly large drop is a reason to inspect the preview before saving.