Should I clean my data before profiling it?

Yes. Trimming spaces and dropping blank rows changes how values are typed, so cleaning first means the Profiler's types, missing counts, and quality scores reflect the real data. Re-profile after cleaning to confirm the fix.

Does cleaning overwrite my original file?

No. The original stays untouched in memory — Revert to Raw restores it — and the export is a brand-new cleaned CSV in your downloads folder.

Documentation

Cleaning data

Use the CSV Cleaner to fix the most common mess in one pass.

Quick answer

Open the CSV Cleaner, load the file, enable Trim Whitespace (plus Remove Empty Rows and a casing option if needed), run, and export the cleaned CSV. Diagnostic counts show duplicates, blank rows, and trimmable cells before you apply anything.

Steps

Open Tools → CSV Cleaner and choose your CSV, TSV, or TXT file (max 5 MB).
Review the preview table to spot leading/trailing spaces, inconsistent casing, blank rows, and repeats.
Enable Trim Whitespace to strip padding from every cell.
Optionally enable Remove Empty Rows to drop fully blank lines.
Optionally enable Standardize Case (lowercase, UPPERCASE, or Title Case) for a text column or all text cells.
Run the clean, review the affected-cell and removed-row counts, then export the cleaned CSV.

Tips

Clean before profiling so type detection sees the real values.
Numbers are never case-transformed; only text cells change.

Common questions

Should I clean my data before profiling it?: Yes. Trimming spaces and dropping blank rows changes how values are typed, so cleaning first means the Profiler's types, missing counts, and quality scores reflect the real data. Re-profile after cleaning to confirm the fix.
Does cleaning overwrite my original file?: No. The original stays untouched in memory — Revert to Raw restores it — and the export is a brand-new cleaned CSV in your downloads folder.

Use it in

CSV Cleaner →

Back to documentation Removing duplicates Handling missing values Converting formats

Documentation

Cleaning data

Use the CSV Cleaner to fix the most common mess in one pass.

Quick answer

Steps

Open Tools → CSV Cleaner and choose your CSV, TSV, or TXT file (max 5 MB).
Review the preview table to spot leading/trailing spaces, inconsistent casing, blank rows, and repeats.
Enable Trim Whitespace to strip padding from every cell.
Optionally enable Remove Empty Rows to drop fully blank lines.
Optionally enable Standardize Case (lowercase, UPPERCASE, or Title Case) for a text column or all text cells.
Run the clean, review the affected-cell and removed-row counts, then export the cleaned CSV.

Tips

Clean before profiling so type detection sees the real values.
Numbers are never case-transformed; only text cells change.

Common questions

Should I clean my data before profiling it?: Yes. Trimming spaces and dropping blank rows changes how values are typed, so cleaning first means the Profiler's types, missing counts, and quality scores reflect the real data. Re-profile after cleaning to confirm the fix.
Does cleaning overwrite my original file?: No. The original stays untouched in memory — Revert to Raw restores it — and the export is a brand-new cleaned CSV in your downloads folder.

Use it in

CSV Cleaner →

Back to documentation Removing duplicates Handling missing values Converting formats

Cleaning data

Quick answer

Steps

Tips

Common questions

Use it in

Loading Datio workspace…

Cleaning data

Quick answer

Steps

Tips

Common questions

Use it in