CleanCSV

Change Text Case in CSV and Excel Files

Convert text to lowercase, UPPERCASE or Title Case in every column or only the ones you pick, and capitalize person names properly.

Free, no sign-upFiles never leave your deviceCSV, Excel & JSON

CSV & Excel cleaning workspace

No account. No uploads. Just clean data.

100% in your browser
1

Upload your file

Drop your CSV or Excel file here

or browse your device. You can select several files at once.

CSV, TSV, TXT, XLSX, XLS, ODS and JSON · up to 50.0 MB and 250,000 rows

Your files never leave your device.

Step by step

How to use this tool

  1. 1

    Drop your CSV or Excel file into the tool above.

  2. 2

    Change text case is on and set to Title Case. Switch to lowercase or UPPERCASE if you prefer.

  3. 3

    Choose Selected columns to limit the change, for example to City and Country. Email columns stay lowercase when Normalize email addresses is on.

  4. 4

    Check the preview, then download.

Title Case for names and places

Title Case capitalizes the first letter of each word and lowercases the rest, including after hyphens and apostrophes, so “o'neil” becomes “O'Neil” and “mary-jane” becomes “Mary-Jane”. For contact lists, Capitalize person names applies this only to columns such as Name, First Name or Surname and leaves company names and codes alone.

Watch out for acronyms

Title Case also changes acronyms and brand names (“IBM” becomes “Ibm”), so limit it to the columns that need it. Case changes never touch header names; use the header style in the Columns section for those.

Consistent case before matching

Many systems treat “Paris” and “PARIS” as different values. Making a column consistently lowercase or Title Case before you deduplicate, build a pivot table or import avoids split categories and missed matches.

Frequently asked questions

Can I make only one column uppercase?

Yes. Choose Selected columns under Change text case and pick the column.

Does it change header names?

No. Use Header names in the Columns section to format headers as Title Case or snake_case.

Does it work with accented letters?

Yes. Case conversion follows your browser's language rules, so letters like é, ß and ø are handled correctly.