Clean

Data Cleaning Tool

Tidy messy exports step by step. Tick only the transformations you want, choose which columns they apply to, and see before-and-after counts plus every changed cell before downloading. Nothing changes unless you ask. Everything is processed in your browser; your data is not uploaded.

Back

1. Data and transformations

Local only

Processed in your browser; your files and data are not uploaded or stored. Formulas, macros and scripts in your data are never run.

2. Cleaned result

Live preview

No transformation is applied unless you tick it. Steps run in the numbered order shown.

CSV downloads use safe export by default: cells starting with =, +, -, @, a tab or a carriage return get a leading apostrophe so spreadsheet apps treat them as text.

Data is processed in your browser's memory. Limits: 20 MB per file, 200,000 rows, 1,000 columns and 3,000,000 cells.

About this tool

About Data Cleaning Tool

Data Cleaning Tool applies the cleaning steps you choose to CSV or TSV data: trimming and collapsing spaces, normalising line endings and whitespace, blanking placeholder values, changing letter case, restyling header names and removing empty rows and columns.

Exports are often full of stray spaces, N/A placeholders and inconsistent headers that break imports and lookups. Fixing them by hand is slow. Here every step is opt-in, can be limited to selected columns, and its effect is shown cell by cell before you download.

How to use

Step by step

  1. Upload or paste the table.
  2. Tick the transformations you need, in the numbered order shown.
  3. Choose the columns each column-specific step applies to.
  4. Review the before/after counts and the list of changed cells.
  5. Choose the output format and line endings, then download.
Key features

What it offers

  • Trim, collapse spaces and normalise line endings
  • Whitespace normalisation in selected columns
  • Blank placeholder values such as N/A or null
  • UPPERCASE, lowercase or Title Case for selected columns
  • Header styles: Title Case, lowercase, snake_case, kebab-case
  • Remove fully empty rows and columns
  • Changed-cell preview and before/after counts
Best practices

Tips for best results

  • Apply only the steps you need and check the changed-cell list.
  • Blank placeholders before removing empty rows so those rows are detected.
  • Use snake_case headers for databases and code.
  • Keep a copy of the original export.
Benefits

Why people use it

Opt-in

Nothing changes unless you choose it.

Transparent

Every changed cell can be reviewed.

Private

Cleaning runs entirely in your browser.

FAQ

Common questions

No. Every transformation is off until you tick it. With nothing ticked, the output is identical to the input and the page says so.
In the numbered order on the page: line endings, trimming, collapsing spaces, whitespace normalisation, blanking values, letter case, header style, then removing empty rows and columns. Later steps see the results of earlier ones.
Step 3 turns runs of two or more spaces into one space in every cell, leaving tabs and line breaks alone. Step 4 works only on the columns you select and turns any whitespace — tabs, line breaks, repeated spaces — into single spaces, then trims the cell.
List placeholder values one per line, such as N/A, null or -. A cell whose entire value matches one of them is emptied, in the columns you select. Matching ignores case unless you tick "Match case exactly"; parts of longer values are never changed.
Title Case, lowercase, snake_case (first_name) and kebab-case (first-name), applied to the headers you select. If two headers end up the same, a _2 suffix keeps them unique.
A row is empty when every cell is empty after the earlier steps — whitespace counts as empty only if you also trim. A column is removed only if its header is blank and it has no data in any row.
Yes. The page shows rows and columns before and after, the number of changed cells, and a list of changed cells with their row, column, old and new value.
No. Cleaning happens in your browser and nothing is stored.
Private by design

This runs entirely in your browser

No file or text you enter here is uploaded. Encoding and decoding happen on your device using native browser APIs — close the tab and nothing remains on a server.

Install Toolisco Add it to your device for offline, one-tap access.