Clean your data quickly and easily, without complex tools or costly software.
← Back1. How the app works (quick start)
Step-by-step overview:
-
Upload a CSV file
- Maximum file size: 5 MB
- Only
.csvfiles are supported
-
Review detected column types
- Each column is automatically detected as Text, Number, or Date
- You can change the type using the dropdown
-
Choose processing actions
- Actions depend on the selected column type
- Multiple actions can be selected per column
-
Preview results
- Click Preview With Processing to see the first 10 processed rows
-
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
- Trim spaces – Removes leading and trailing spaces
- Normalize spaces – Replaces multiple spaces with a single space
- Remove non-printing 🔄 – Removes invisible or control characters
- Unicode normalize 🔄 – Standardizes accented and special characters
- Uppercase / Lowercase / Title Case 🔄 – Changes text letter casing
🔎 Why flagged: casing and Unicode normalization can affect IDs, codes, or case-sensitive values.
Use Text for:
- Names
- Descriptions
- Free-form values
Number columns
- Trim – Removes leading and trailing spaces
- Remove currency symbols 🔄 – Removes $, €, £, and similar symbols
- Convert to number 🔄 – Converts text to a numeric value
- Round 🔄 – Rounds numbers to a fixed decimal precision
🔎 Why flagged: rounding and conversion can permanently alter numeric precision or formatting.
Use Number for:
- Prices
- Quantities
- Numeric IDs
Date columns
- Trim – Removes leading and trailing spaces
- Standardize date format 🔄 – Converts dates to
yyyy-MM-dd
🔎 Why flagged: date parsing may reinterpret ambiguous formats (e.g. 01/02/2023).
Use Date for:
- Dates and timestamps in inconsistent formats
Email columns
- Trim – Removes leading and trailing spaces
- Validate email – Flags invalid email formats with “Suspect Email” at the beginning
Use Email for:
- Standard email validation
🔄 3. Changing column types
- The available actions will update automatically
- Default actions for the selected type will be pre-selected
- Previously selected actions may be reset if they’re incompatible
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
- Preview shows only the first 10 rows
- Final processing applies changes to the entire file
- Preview results may differ if later rows contain unexpected values
💳 5. Credits & limits
- Maximum Size allowed is per file 5MB
- Maximum Rows allowed per file is 50 000
- Maximum columns allowed per file is 200
- Files with 100 rows or fewer are free
- Files with more than 100 rows require credits
- One credit is used per 1000 rows processed
- Credits are only deducted when processing succeeds
🔐 6. Privacy & security
- Uploaded files are processed temporarily
- Files are deleted automatically after processing
- We do not store or reuse your data
⚠️ 7. Common issues & fixes
“My column type changed to Unknown”
- Make sure you didn’t refresh the page
- Try re-uploading the file
“Actions reset when I change type”
- This is expected behavior to prevent invalid transformations
“Nothing happens when I upload”
- Check file size (5 MB max)
- Make sure the file is a valid CSV