Clean your data quickly and easily, without complex tools or costly software.

← Back

1. How the app works (quick start)

Step-by-step overview:

  1. Upload a CSV file
    • Maximum file size: 5 MB
    • Only .csv files are supported
  2. Review detected column types
    • Each column is automatically detected as Text, Number, or Date
    • You can change the type using the dropdown
  3. Choose processing actions
    • Actions depend on the selected column type
    • Multiple actions can be selected per column
  4. Preview results
    • Click Preview With Processing to see the first 10 processed rows
  5. Process & download
    • Click Process & Download to get your cleaned CSV

2. Column types & actions explained

✅ Default actions are selected based on common industry data-cleaning practices.
You can customize actions to fit your data and use case.
Actions are applied in the order shown.

⚠️ Warning: Actions marked with 🔄 may change the meaning or format of your data.
Use Preview With Processing to review changes before downloading.

Text columns

🔎 Why flagged: casing and Unicode normalization can affect IDs, codes, or case-sensitive values.

Use Text for:


Number columns

🔎 Why flagged: rounding and conversion can permanently alter numeric precision or formatting.

Use Number for:


Date columns

🔎 Why flagged: date parsing may reinterpret ambiguous formats (e.g. 01/02/2023).

Use Date for:


Email columns

Use Email for:


🔄 3. Changing column types

This helps prevent invalid transformations.


CSV Cleaning Help

1️⃣ Understanding the Previews

When you upload a CSV and preview processing, you’ll see two tables stacked:

  • Original Input – your raw CSV data
  • Processed Preview – the data after cleaning rules are applied
  • Changed Cells – only cells modified by cleaning rules

Tip: This makes it easy to see what changed at a glance.

2️⃣ Date Culture Selection

Many CSVs contain dates in different formats. You can select the Date Culture to ensure correct standardization:

Culture Code Label Example
en-US English (US) 03/25/2024
en-GB English (UK) 25/03/2024
fr-FR French 25/03/2024
de-DE German 25.03.2024
All Auto-detect Detects multiple formats

How it works:

  • If you select a specific culture, date standardization uses that culture to parse values.
  • If you select "All", the system will try multiple common date formats to detect the correct date automatically.
  • All dates are converted to ISO format (yyyy-MM-dd) in the processed preview and final output.

3️⃣ Summary

  • Original Input – shows your raw CSV
  • Processed Preview – shows the cleaned data
  • Yellow highlights – changed values
  • Date Culture – lets you control how dates are interpreted

Using these features ensures your CSV data is cleaned accurately and consistently, especially when working with international date formats.

4. Preview vs final processing


💳 5. Credits & limits


🔐 6. Privacy & security


⚠️ 7. Common issues & fixes

“My column type changed to Unknown”

“Actions reset when I change type”

“Nothing happens when I upload”