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.
=UPPER(A2) ' john smith -> JOHN SMITH
=LOWER(A2) ' JOHN SMITH -> john smith
=PROPER(A2) ' john smith -> John SmithPROPER 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:
=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:
- Insert a blank column next to the data you want to change.
- In its first cell type =UPPER(A2), replacing A2 with the first cell of your data.
- Press Enter, then double-click the small square at the bottom-right corner of the cell to copy the formula down the column.
- Select the new column and copy it with Ctrl+C.
- 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.
- 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.