ConvertCSV

Clean Tools

Change CSV Text Case

Convert text in chosen columns to UPPER, lower, or Title Case. Runs locally in your browser — nothing is uploaded for processing.

Input

Paste CSV or upload a file

Options

Output Preview

Result

Run the tool to preview output here.

Change CSV Text Case

Change CSV Text Case rewrites letter case in the columns you select. Lowercase names typed into a form can become Title Case, and mixed-case country codes can become consistent upper case before they are matched against a lookup table.

Choose UPPER CASE, lower case or Title Case. Numbers keep their exact text, the header row keeps its names unless you tick the header option.

Key features

  • UPPER, lower and Title Case
  • Chosen columns or the whole file
  • Plain numbers and scientific notation left alone
  • Optional header renaming

About the CSV to CSV format

Each selected cell is converted whole. Title Case lowercases the text, then capitalizes the first letter after the start of the cell and after each space, hyphen, slash or opening bracket. A cell that parses completely as a number, including scientific notation such as 1e5, is returned unchanged so it is not rewritten as 1E5. Fields containing commas or quotes are written back in quotes, so the column structure is preserved.

How it works

Each cell is first tested for a complete number. If it is one, the cell is returned as typed. Otherwise the text is converted with the standard string case functions. Title Case uses Unicode letter classes, so accented capitals such as Élodie are handled like plain ASCII letters.

Common use cases

  • Matching customer names against a CRM that stores them in Title Case
  • Making ISO country codes uppercase before joining them with a reference table
  • Lowercasing a mixed-case email column before deduplicating it

How to use this tool

  1. Enter the sheet in the text box, or pick a .csv with Click to upload.
  2. Enter the columns to change in the box, or leave it blank for all of them.
  3. Choose the case, and tick the header box only if the column names should change too.
  4. Click Convert, then copy or download the result.

Example

Names and SKUs (input)

name,city,sku
ada lovelace,london,ab-120
GRACE HOPPER,new york,ab-121

Title Case on name and city (output)

name,city,sku
Ada Lovelace,London,ab-120
Grace Hopper,New York,ab-121

Tips for best results

  • Use Title Case on person and place names only. Product codes, acronyms and URLs come out looking wrong.
  • Select the columns explicitly. Leaving the box blank changes every cell, including identifiers you may need unchanged.

Common errors and how to fix them

Changing the header case would make two column names identical.
Headers such as Name and NAME become the same name after conversion. Untick the header option, or rename one of the columns before running the tool.

Best practices

  • Convert one column and check a handful of rows before running the whole sheet.
  • Case changes are not recorded anywhere, so a lowercased email column cannot be restored to its original capitals from the output alone.

Frequently asked questions

Are values like 12a changed?

Yes. Only a value that parses completely as a number is skipped, so 12a becomes 12A in upper case mode.

Does accented text convert correctly?

Yes. Upper, lower and Title Case all apply to accented letters, so é becomes É in upper case.

For more background on data formats and conversion workflows, read our format guides.