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.
1. Data and transformations
Local onlyProcessed 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 previewNo 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 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.
Step by step
- Upload or paste the table.
- Tick the transformations you need, in the numbered order shown.
- Choose the columns each column-specific step applies to.
- Review the before/after counts and the list of changed cells.
- Choose the output format and line endings, then download.
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
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.
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.
Common questions
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.