Data Tools

Text Case Standardizer

Convert text to Title Case, UPPER CASE, lower case or Sentence case across all or selected columns. Numbers, dates and formulas are left unchanged, and your file never leaves your device.

  • Nothing uploaded
  • No size limit
  • No account

Drag and drop an Excel file here, or click to select

What the Text Case Standardizer tool does

Data typed by different people is rarely capitalized the same way: "ACME LTD", "acme ltd" and "Acme Ltd" all turn up in the same column. This tool changes text case across an Excel workbook in one pass, so names, cities and product codes come out consistent. Numbers, dates and formulas are left exactly as they are.

How to change text case in Excel

  1. Add your workbook

    Drop an .xlsx, .xls or .xlsm file. Its column headers are read so you can target specific columns if you want to.

  2. Choose the case you want

    Title Case for names and places, UPPER CASE for codes and identifiers, lower case for email addresses, or Sentence case for descriptions and notes.

  3. Apply to everything or just some columns

    Leave it on all text columns to standardize the whole workbook, or switch to selected columns and choose the ones to change.

  4. Standardize and download

    The rest of the workbook is left untouched, and the updated file downloads automatically.

Options explained

Title Case
Capitalises the first letter of each space-separated word: "ada lovelace" becomes "Ada Lovelace". Best for people, companies and place names.
UPPER CASE
Capitalises everything. Useful for reference codes, ticker symbols and country codes.
lower case
Lowercases everything. The usual choice for email addresses and URLs.
Sentence case
Capitalises the first letter of the cell and lowercases the rest, which suits free-text notes and descriptions.

What stays on your device

Your workbook is never uploaded. The Text Case Standardizer tool reads the file straight from your disk and does all of its work inside this browser tab, using the open-source ExcelJS and SheetJS libraries. There is no account, no upload limit and no copy of your data on any server — once this page has loaded, the tool keeps working even if you disconnect from the internet.

Limitations to know about

  • Only text cells are changed. Numbers, dates, booleans and formulas are left as they are, and a formula's result is not rewritten.
  • Header rows are never modified.
  • Title Case splits on spaces only, so the letter after a hyphen or apostrophe is not capitalized — "o'neil-smith" becomes "O'neil-smith".
  • Sentence case lowercases everything after the first letter, so acronyms inside a sentence lose their capitals.
  • When you choose specific columns, the list comes from the first worksheet, but the change is applied to matching column positions on every sheet in the workbook.

Frequently asked questions

How do I change the case of text in Excel without a formula?

Drop the workbook above, pick the case you want and apply it. Excel's own UPPER, LOWER and PROPER functions need a helper column and a copy-paste-values step afterwards; here the cells are rewritten in place and you download the finished file.

Will it change my numbers or dates?

No. Only cells holding text are touched. Numbers, dates, booleans and formulas pass through untouched, so a column of totals or order dates is safe even when you apply the change to every column.

What is the difference between Title Case and Sentence case?

Title Case capitalizes every word, which suits names and titles: "annual sales report" becomes "Annual Sales Report". Sentence case capitalizes only the first letter of the cell: "Annual sales report". Use Title Case for labels and Sentence case for prose.

Can I apply it to just one column?

Yes. Switch Apply To from all text columns to selected columns, then pick the ones you want from the list. Every other column is left alone.

Are my files uploaded to a server?

No. Every tool on Excel Toolbox runs in your browser using the open-source ExcelJS and SheetJS libraries. Your workbook is read from your own disk, processed in your browser tab, and written back out as a download. It is never sent to us or to anyone else, which is why the tools keep working if you go offline after the page has loaded.

How large a file can I process?

There is no upload limit, because nothing is uploaded — the ceiling is your device's memory. Files up to about 25 MB are comfortable on a typical laptop. Much larger workbooks will still work but take longer, and processing runs in the page, so leave the tab open until your download starts.

Related tools