Tool 07

🔤 Change Text Case in Excel

Changes the capitalization of whole columns to Title Case, UPPERCASE, lowercase or Sentence case — without breaking names, company forms or state codes.

🔒 Works offline — your file never leaves your computer

What it does

Four styles: Title Case, UPPERCASE, lowercase and Sentence case
Title Case gets names right: JOHN MCDONALD → John McDonald, mary o'brien → Mary O'Brien
Keeps LLC, Inc., IT and US state codes like NY in capitals, and small words like "of" and "and" in lowercase
E-mail and web addresses are never changed
Choose which columns to change — or all text columns at once

Example

Before	After
JOHN MCDONALD	John McDonald
bank of america	Bank of America
SUMMIT IT SERVICES LLC	Summit IT Services LLC
boston, MA	Boston, MA

Real output of the tool with Title Case.

⬇ Download Tool — Free

or use it right here in your browser →

Single HTML file · opens in Chrome, Edge, Firefox or Safari · no installation, no sign-up

How it works

Download the toolClick the red button and save the file to your computer.

Open it in your web browserDouble-click the downloaded file. It opens in your browser — not in Excel. No installation, no account.

Choose your Excel file and save the cleaned copyClick "Run", check the before/after examples on screen, then save. Your original file stays untouched.

Good to know

Always keep a copy of your original file as a backup and check the cleaned copy before you use it.
Numbers, dates and formulas are never changed — only text cells.
Reads .xlsx, .xls and .csv files and saves the result as a new .xlsx file.
Only the first worksheet is cleaned. Other worksheets and title rows above your table are kept unchanged.
Values, dates and number formats are kept. Cell colors and fonts are not carried over to the cleaned copy.
The tools are provided free of charge and "as is". We have built and tested them with great care, but we cannot guarantee that every entry is recognized or changed correctly. As far as permitted by law, we accept no liability for results or any damage arising from their use. See Legal Notice & Disclaimer.

More about this tool

When lists come from different sources, capitalization is all over the place: JOHN SMITH in one row, john smith in the next, John Smith in a third. In letters, labels and offers this looks careless.

Excel's PROPER() function helps only halfway — it turns McDonald into Mcdonald, LLC into Llc and NY into Ny. This tool knows these cases. It keeps company forms, common acronyms and state codes in capitals, handles Mc and O' names and writes small words like "of" and "and" in lowercase.

Choose the style, pick the columns (or leave all selected) and save the cleaned copy. Your original file stays unchanged and nothing leaves your computer.

More free tools

✂️