CSV Bulk Cell Cleaner
Local ProcessingTrim, change case, add prefixes/suffixes, find & replace, round, convert percentages, normalise dates or number rows in a CSV.
How It Works & Processing Standards
Trim, change case, add prefixes/suffixes, find & replace, round, convert percentages, normalise dates or number rows in a CSV.
Tool processing runs in your browser. If you create a calculator or conversion share link, its values are included in the URL. See the privacy policy for account, analytics and advertising data.
Current Limits
- Desktop max file size: 50MB
- Mobile max file size: 20MB
Choose a clean-up under "Task" and set a column if needed. Bring messy data into one format without spreadsheet formulas.
What You Can Do
- Trim, case, find/replace
- Remove surrounding spaces, change case and replace text.
- Rounding and percent
- Set decimal places or turn 0.123 into 12.3%.
- Dates and row numbers
- Normalise dates like 2026/9/7 to 2026-09-07 and add a row-number column.
How to Use CSV Bulk Cell Cleaner
- 1Choose a taskPick the clean-up.
- 2Enter CSV and columnPaste CSV and set the column and options.
- 3Get the resultCopy the CSV or download Excel.
Examples
Percent (1 decimal)
Input: 항목,비율
A,0.1234
B,0.5
Result: 항목,비율
A,12.3%
B,50.0%
Normalise dates
Input: 날짜
2026/9/7
2026.10.01
Result: 날짜
2026-09-07
2026-10-01
Common Use Cases
- Bringing data entered by several people into one format
- Tidying numbers and dates for reports
Frequently Asked Questions (FAQ)
Does the header change?
With "first line is header" on, the header is left alone and only data cells are cleaned.