About Change Case in a CSV
This page opens with Title Case. Every text cell is changed, so "dhaka", "DHAKA" and "Dhaka" become one spelling, which makes grouping and duplicate removal work. It is free, needs no sign-up and runs in your browser, so nothing you enter is uploaded.
The sample has 18 cells changed. Numbers are not touched. Title case capitalises after spaces, hyphens and apostrophes, so very short special cases such as "N/A" become "N/a"; treat those as missing first if that matters.
How to use Change Case in a CSV
- Open Paste or upload data to load your file, or start with the sample.
- Switch on the steps you need: whitespace, case, types, missing values, duplicates, find and replace.
- To look for outliers, choose a number column and a method, and adjust the threshold if you want.
- Read Before and after for the row counts and what changed, and check the preview below it.
- Copy the cleaned CSV or download it.
Features
- Trim and collapse whitespace.
- Remove duplicate rows, optionally ignoring case.
- Treat NA, N/A, null, nan and a lone dash as missing, then keep, drop, or fill with a value, the mean, the median, the most common value or the value above.
- Fix types: currency and thousands separators, bracket negatives and yes/no, while keeping ids with leading zeros.
- Standardise text to lower, upper or title case.
- Find and replace in one column or all, with whole-cell, case and regular expression options.
- Outlier detection with IQR, z-score or modified z-score, highlighted in the preview, with an option to remove them.
- A before and after summary with counts of every change.
Worked examples
CHITTAGONG and dhaka gives Chittagong and Dhaka
18 cells changed in the sample.
Privacy: how it works
- Your table is read and cleaned by code running in this browser tab. Nothing is uploaded, and your original file is never modified.
Tips
- Trim whitespace first. A trailing space is the usual reason two equal-looking values count as different.
- Turn on "treat NA as missing" before filling, so the placeholders are counted as gaps.
- Filling with the mean pulls values towards the centre and understates spread. The median is safer when outliers exist.
- Download a cleaned copy and keep the original. This tool never edits the source file.
Frequently asked questions
Is it really free?
Yes. There is no price, no trial and no credit card. Ulkaa Tool does the work with your own device, so there is no server bill to pass on to you.
Do I need an account?
No. There is no sign-up and no login. Open the page and use it. An Ulkaa account is not needed for anything on this tool.
Does it run in my browser?
Yes. Your data are processed by code running in your browser tab, on your own device.
Is my data uploaded?
No. Your data are never sent to Ulkaa or to anyone else. You can check this yourself by watching the Network tab in your browser developer tools while you use the tool.
Will it change names like McDonald?
Title case writes McDonald as Mcdonald. Review names after a case change.
More Data Cleaner pages
- Data CleanerTidy a messy table and download it as a clean CSV, with a before and after summary.
- Remove Duplicates From CSVDelete repeated rows and keep the first of each.
- Fill Missing Values in a CSVReplace gaps with a sensible value, and see how many were filled.
- Trim Whitespace in a CSVRemove stray spaces that make equal values look different.
- Fix Data Types in a CSVConvert currency text and thousands separators into plain numbers.
- Find and Replace in a CSVReplace values across every column or just one.
- Outlier Detection in a CSVFlag the values that sit far from the rest of a column.
- IQR Outlier CalculatorFind values outside Q1 - 1.5 x IQR and Q3 + 1.5 x IQR.
- Z-Score Outlier DetectionFlag values more than a set number of standard deviations from the mean.
- Modified Z-Score OutliersA robust outlier rule based on the median and the median absolute deviation.