Log inGet started
Fixes
4 operations
History
Last 20 steps
Export
UTF-8 CSV

A focused toolkit for tidy CSVs

CleanYourDataset handles the fixes almost every export needs, shows you the impact of each one, and keeps every step reversible.

Four steps

From a messy export to a file you can trust
  1. 01
    Upload

    Drop in a UTF-8 CSV. It is checked and saved to your account straight away.

  2. 02
    Review

    Column types, blanks, stray spaces, empty rows and duplicates, all counted.

  3. 03
    Fix

    Apply one fix at a time and see exactly what each one changed.

  4. 04
    Export

    Download a spreadsheet-safe CSV whenever you are ready.

Everything it does

Six capabilities, no setup
  • Profile

    Profile every column

    • Types are inferred as number, boolean, ISO date (YYYY-MM-DD) or text.
    • Missing counts and a completeness meter for each column.
    • Blank and whitespace-only cells count as missing; values such as “N/A” stay as data.
  • Inspect

    Find problems before you change anything

    • See how many cells have leading or trailing spaces.
    • Count fully empty rows and exact duplicate rows.
    • Filter the table to just the affected rows, or to the blanks in one column.
  • Clean

    Fix issues in one click

    • Trim whitespace from every cell.
    • Remove rows where every cell is blank.
    • Remove exact duplicates, keeping the first occurrence.
    • Fill blanks in one column with a value of up to 100 characters.
  • Review

    Review and reverse

    • Each change reports how many rows and cells it affected.
    • Undo the most recent change, or reset to the original upload.
    • An activity log records the last 20 steps.
    • Edits from another tab are detected, so changes are never silently overwritten.
  • Export

    Export safely

    • Download the current rows as UTF-8 CSV with a byte-order mark, so Excel detects the encoding.
    • Cells starting with =, +, - or @ are prefixed with a tab so they are not run as formulas.
    • Browse every row page by page before you download.
  • Control

    Keep control of your data

    • Datasets are private to your account and saved between sessions.
    • Rename or delete any dataset.
    • Deleting your account removes every dataset with it.

What a file can contain

Files outside these limits are rejected with a message that explains what to change
File typeCSV with a .csv extension, UTF-8 encoded (a byte-order mark is fine)
File sizeUp to 128 KiB
RowsUp to 1,000 data rows, plus one header row
ColumnsUp to 20, with unique, non-empty names
Cell lengthUp to 500 characters
Fill value1 to 100 characters
DatasetsUp to 100 per account

Try it on
your own file.

Create an account

Already have one? Log in