Upload

Configure

Download

Upload your file

CSV, Excel (.xlsx/.xls) and JSON supported. Drag and drop or click to browse. Up to 20MB.

Drop your file here

CSV, Excel or JSON — or click to browse from your computer

filename.csv

0 rows, 0 columns

Preview (first 5 rows)

Choose your fixes

We analyzed your data. Select the cleaning operations you want to apply.

Data Analysis

Quick Presets

Data Quality

Remove Duplicates

Remove rows with duplicate values in selected column(s)

Clean Whitespace

Trim spaces and remove hidden characters from all fields

Remove Empty Rows

Delete rows with missing or empty values

Validation

Validate Emails

Check email format and add validation column

Select email column:

Lowercase emails Convert to lowercase

Remove invalid Delete rows with bad emails

Remove empty Delete rows without email

Fix domain typos gmial.com → gmail.com

Flag disposable Mark temp-mail addresses

A new column is_valid_email will be added with true/false values.

Formatting

Normalize Dates

Convert mixed date formats to a consistent format

Select date column(s):

Target format:

ISO 2024-12-31

European 31.12.2024

US 12/31/2024

UK 31/12/2024

Split Column

Split one column into multiple parts (e.g., full name → first + last)

Merge Columns

Combine multiple columns into one (e.g., street + city → address)

Text Case

Convert text to Title Case, UPPERCASE, or lowercase

Standardize Countries

Convert country names to ISO 2-letter codes (US, DE, UK...)

Clean Numbers

Remove currency symbols, fix thousand separators and decimals

Select columns with numbers:

Remove currency symbols $, €, £, ¥, CHF, USD...

Fix thousand separators 1,000 or 1.000 → 1000

Remove % symbol 85% → 85

Decimal format:

1234.56 1234,56

Round decimals:

Structure

Find & Replace

Search and replace text across your data

Filter Rows

Keep or remove rows based on conditions

Column

Condition

Value

Action: Remove matching rows Keep only matching rows

Normalize Headers

Standardize column names (snake_case, Title Case, camelCase...)

Target format:

snake_case full_name

camelCase fullName

Title Case Full Name

UPPER FULL_NAME

lower full_name

Remove special characters Fix duplicate headers

Select & Reorder Columns

Choose which columns to keep and in what order

Preview & Download

Review the changes and download your clean data.

Rows before

Rows after

Columns before

Columns after

Changes Applied

Original Data

First 20 rows

Transformations applied

Cleaned Data

Ready to download

Verbrauch beim Download

0 Rows

Format: