Skip to content
ToolPlankDEV
Text Tools
100% In-Browser Execution

Updated:

Excel Uppercase, Lowercase & Title Case Converter

Use this excel uppercase tool to change text case in a pasted column or a whole Excel file. Pick an .xlsx or CSV file, tick the columns, choose UPPER, lower, Title or Sentence case and download. Your file never leaves your browser.

Processing in browser...

Loading the tool. It runs entirely in your browser, so your data is never uploaded.

More free tools you may need next.

Quick Guide

How to use Excel Case Converter

Simple step-by-step instructions to get the exact output you need.

  1. 01

    Choose how to add your data

    Open the Excel / CSV file tab and pick a .xlsx or .csv file from your device, or open the Paste text tab and paste a column you copied from Excel.

  2. 02

    Pick a case

    Choose UPPERCASE, lowercase, Capitalize Each Word, Title Case or Sentence case. The preview updates as you switch.

  3. 03

    Tick the columns to change

    For a file, tick one or more columns. Keep First row is a header switched on so your headings stay untouched. The preview shows a before and after for each column.

  4. 04

    Download or copy the result

    Press Convert & download file to get a new copy of your workbook, or use Copy in the Paste text tab. Your original file is never changed.

Convert Excel to Uppercase Without Uploading Your File

This excel uppercase converter opens your .xlsx or .csv file inside your browser tab, reads the column headings and lets you tick the columns you want to change. When you press the button it rewrites only those cells and hands you a new file. Nothing is sent to a server, so customer lists, payroll sheets and internal exports stay on your device.

You do not have to take our word for it. Open your browser's Network tab while you convert a file and you will see that no request carries your data anywhere.

Here is how the conversion rules apply:

  • Text cells in the selected columns are converted.
  • Numbers, dates and true/false values are left exactly as they are.
  • Formula cells are skipped, because rewriting them would break the formula. Wrap the formula in UPPER() if you need that result in capitals.
  • The header row is kept as it is unless you switch the header option off.
  • Your original file is never modified. You always get a new copy with the case type added to the name.

Excel Case Functions: UPPER, LOWER and PROPER

Excel has three built-in functions for changing case. None of them edits the cell in place. Each one returns converted text, which you then put in another cell.

Text
=UPPER(A2)    ' john smith  ->  JOHN SMITH
=LOWER(A2)    ' JOHN SMITH  ->  john smith
=PROPER(A2)   ' john smith  ->  John Smith

PROPER capitalizes every letter that follows a character that is not a letter. That is fine for most names, but it turns don't into Don'T and 3rd into 3Rd. The Title Case option in this tool avoids that and also keeps small words such as of and the in lowercase.

Excel has no function for sentence case, but you can build it from three others:

Text
=UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2)))

Step by Step: Change Case in Excel With a Formula

If you prefer to stay inside Excel, a helper column does the job in a minute:

  1. Insert a blank column next to the data you want to change.
  2. In its first cell type =UPPER(A2), replacing A2 with the first cell of your data.
  3. Press Enter, then double-click the small square at the bottom-right corner of the cell to copy the formula down the column.
  4. Select the new column and copy it with Ctrl+C.
  5. Right-click the first cell of the original column, choose Paste Special, then Values. On Windows you can also press Ctrl+Alt+V and then V.
  6. Delete the helper column. Your original column now holds the converted text.

Other Ways to Change Case in Excel

Excel has no Change Case button like Word has, and Shift+F3 opens the Insert Function box instead of switching case. These alternatives work well:

  • Flash Fill: type the converted version of the first row in the next column, then press Ctrl+E. Excel guesses the pattern, so scan the result before you trust it.
  • Power Query: choose Data, then From Table/Range, select the column and use Transform, Format, then UPPERCASE, lowercase or Capitalize Each Word. It is a good fit for monthly imports you repeat.
  • A VBA macro: useful when you must convert many sheets at once, but it needs a macro-enabled workbook.
  • Google Sheets: it uses the same UPPER, LOWER and PROPER functions.

Which Case Should You Use?

  • UPPERCASE (or making all caps in Excel) suits product codes, SKUs, state and country codes and any key you match against another list.
  • lowercase is the right choice for email addresses, usernames and URLs, and a good first step before removing duplicates.
  • Capitalize Each Word works for people's names, cities and addresses.
  • Title Case fits product titles, headings and book names.
  • Sentence case is best for descriptions and notes.

Case matters more than it looks. Excel's = comparison ignores case, but EXACT(), databases and many import tools do not, so Smith and SMITH can end up as two different records. Normalizing a column to one case before you merge lists saves a lot of cleanup later.

What This Excel Case Converter Can and Cannot Do

  • It opens .xlsx files up to 60 MB and .csv or .tsv files up to 200 MB, and reads them in the background so the page stays responsive. Older .xls, .xlsm and .xlsb files must be saved as .xlsx first, and password-protected files cannot be opened.
  • It changes text only. Numbers, dates and formula cells are never touched.
  • Title Case follows simple rules. It cannot know that iPhone or NASA are special, because it lowercases the word first. Review brand names and acronyms after converting.
  • It is a converter, not an Excel replacement. Charts, images, pivot tables and macros may be lost in the new copy, so keep your original file.

Frequently Asked Questions

Technical Q&A for Excel Case Converter

Common questions about edge cases, character encoding, and privacy guarantees.

Use a helper column with =UPPER(A2), copy it down, then paste it back over the original with Paste Special, Values. Or use this tool: open your file, tick the column, choose UPPERCASE and download the converted copy.

No. The file is opened, converted and saved inside your browser. It is never uploaded, stored or logged, and you can confirm that in your browser's Network tab.

In most workbooks, fonts, fills, column widths, number formats, formulas and merged cells carry over to the new file. Charts, images, pivot tables and macros may not, so always keep your original file and check the copy.

Yes. Tick only the columns you want. Everything else in the file stays as it was, and you can also choose columns on more than one sheet.

The tool only changes text. Numbers, dates and true/false values have no case, and formula cells are skipped so they keep working. Cells that were already in the chosen case also show as unchanged.

Capitalize Each Word matches Excel's PROPER function and capitalizes every word, so of and the become Of and The. Title Case keeps small words in lowercase unless they start or end the text, which is how most titles are written.

No. Excel has no shortcut or button for changing case. Use the UPPER, LOWER and PROPER functions, Flash Fill, Power Query or this tool.