How to convert all excel columns to any case without upper/lower/proper formulas
- Step 1Save the whole sheet as CSV — Excel: File → Save As → CSV UTF-8. The Case Normalizer redirects to the CSV Case Converter, which reads CSV — no helper columns required anywhere.
- Step 2Drop the CSV in — Every header becomes a checklist item. The first row is treated as headers and is excluded from conversion automatically.
- Step 3Leave all columns unticked to convert everything — An empty selection means 'apply to all columns' — the bulk path. Or tick a subset to protect identifier columns like SKU or OrderID.
- Step 4Pick the mode that maps to your formula — UPPER for
UPPER(), lower forLOWER(), Title forPROPER(), Sentence for the case Excel can't do. Each shows an example. - Step 5Convert in one pass — All selected columns' data cells are rewritten at once. The cells-changed count confirms how much the sheet actually needed.
- Step 6Re-open in Excel — Open the output CSV — no Paste-Special-Values, no helper-column cleanup. For per-column type checks afterward, see excel-format-inspector.
Worksheet function → tool mode
Direct mapping, plus the one behavioural difference to know about.
| Excel function | Tool mode | Same result? | Note |
|---|---|---|---|
UPPER() | upper | Identical | toUpperCase() on the cell |
LOWER() | lower | Identical | toLowerCase() on the cell |
PROPER() | title | Mostly | Both capitalise after spaces; PROPER also capitalises after a hyphen/number, this tool does not (whitespace tokenising) |
| (none — no Excel function) | sentence | N/A | First char of cell up, rest down |
Helper-column workflow vs this tool
Steps eliminated when you convert via CSV instead of worksheet formulas.
| Step | PROPER()/UPPER() in Excel | This tool |
|---|---|---|
| Add helper column per source column | Required | Not needed |
| Write + drag-fill the formula | Required | Not needed |
| Copy → Paste Special → Values | Required | Not needed |
| Delete helper column | Required | Not needed |
| Repeat for N columns | N times | Once (all columns) |
| Headers accidentally shouted | Yes, if range includes them | Never (headers preserved) |
Tier limits (the CSV Case Converter you reach)
CSV-family limits apply because the Excel page redirects to the CSV tool.
| Tier | Max file size | Max rows | Files at once |
|---|---|---|---|
| Free | 2 MB | 500 | 2 |
| Pro | 100 MB | 100,000 | 10 |
| Pro-media | 500 MB | 500,000 | 50 |
| Developer | 500 MB | Unlimited | Unlimited |
Cookbook
Bulk-conversion recipes that replace the helper-column dance, plus the PROPER() vs Title difference shown side by side.
Lowercase the entire sheet in one pass
Leave all columns unticked, pick lower. Every data cell across every column is lowercased; headers stay as typed.
Input: Name,City,Email JOHN,LONDON,J@X.COM MARY,PARIS,M@Y.COM Mode: lower | Columns: (all) Output: Name,City,Email john,london,j@x.com mary,paris,m@y.com
PROPER() across the sheet without helper columns
Title mode is the PROPER() replacement for the whole sheet at once — no twenty helper columns.
Input: FIRST,LAST,DEPT john,SMITH,sales ops mary,JONES,it support Mode: title | Columns: (all) Output: FIRST,LAST,DEPT John,Smith,Sales Ops Mary,Jones,It Support
PROPER() vs Title — the hyphen difference
Excel's PROPER() capitalises after hyphens and numbers; this tool's Title tokenises by whitespace only. Know the difference before relying on it.
Cell: stainless-steel m3 bolt
Excel PROPER(): Stainless-Steel M3 Bolt
Tool Title mode: Stainless-steel M3 Bolt
^ hyphen segment NOT capitalisedProtect ID columns while bulk-converting names
Tick only the human-readable columns so SKUs and order IDs keep their exact casing.
Input: SKU,Name,Notes ab-100,john smith,VIP customer Mode: title | Columns: Name, Notes (SKU left out) Output: SKU,Name,Notes ab-100,John Smith,Vip Customer
Sentence case — the mode Excel has no function for
Excel offers no single-formula sentence case. This mode uppercases the first character of each cell and lowercases the rest.
Input (Description): URGENT order from key ACCOUNT shipped MONDAY Mode: sentence | Columns: Description Output: Urgent order from key account Shipped monday
Edge cases and what actually happens
Page redirects to the CSV Case Converter
By designThe Excel Case Normalizer redirects to the CSV Case Converter. Save the sheet as CSV UTF-8, bulk-convert, then re-open. Output is CSV.
Title ≠ PROPER() on hyphens and digits
ExpectedExcel PROPER() capitalises after a hyphen or number; Title mode tokenises by whitespace only, so stainless-steel → Stainless-steel and a3-bolt keeps the b lowercase. If you need exact PROPER() behaviour on hyphens, split first or post-process.
Headers never shouted
PreservedApplying UPPER() to a whole range in Excel also uppercases the header cells. This tool excludes the header row automatically, so a bulk UPPER pass won't turn Customer Name into CUSTOMER NAME.
Empty column selection means all columns
ExpectedLeaving every checkbox unticked is the signal to convert all columns. Tick a subset only when you want to protect specific columns (IDs, SKUs).
Numbers and dates left as text bytes
PreservedCase conversion is a no-op on digits and punctuation, so numeric and date-looking cells pass through unchanged at the text level. (Saving as CSV strips Excel number formatting regardless — that's the CSV round-trip, not this tool.)
Locale-specific casing not applied
LimitationUses toUpperCase/toLowerCase, not locale-aware variants. Turkish dotless-i and similar rules aren't honoured — use a locale-aware script for those.
Free tier 500-row cap on a tall sheet
Tier limitFree is 500 rows / 2 MB. A 20-column sheet of a few thousand rows needs Pro (100,000 rows / 100 MB) or higher to convert in one pass.
Quoted multi-line cells preserved
PreservedRFC-4180 quoted cells with internal commas or newlines are parsed correctly and re-quoted on output — bulk conversion won't shift columns.
Accented characters round-trip
Supportedcafé, Niño, Zürich convert correctly when you save and re-open as CSV UTF-8.
Already-correct cells not counted
ExpectedCells already in the target case are left unchanged and excluded from the cells-changed count — a low count on a partly-clean sheet is expected, not a bug.
Frequently asked questions
Can I replace UPPER/LOWER/PROPER without helper columns?
Yes. Save the sheet as CSV UTF-8 and use the CSV Case Converter (where the Excel Case Normalizer redirects). Pick UPPER, lower, Title, or Sentence and convert all columns in one pass — no helper column, drag-fill, or paste-special-values.
Which mode equals PROPER()?
Title mode. It capitalises the first letter of each whitespace-delimited word. The one difference: PROPER() also capitalises after hyphens and digits, while Title tokenises on whitespace only.
Will bulk UPPER shout my headers too?
No. Unlike applying UPPER() to a full range in Excel, this tool always excludes the header row. Only data cells are converted.
How do I convert every column at once?
Leave every column checkbox unticked — an empty selection applies the chosen mode to all columns. Tick a subset only to protect specific columns.
Is there a sentence-case formula equivalent?
Excel has no single-formula sentence case. This tool's Sentence mode does it: first character of each cell up, the rest down.
Does it keep my SKUs and IDs intact?
If you scope the conversion (tick only name/description columns), yes. If you convert all columns, IDs are re-cased too — so leave identifier columns out of the selection.
Why is PROPER() giving different results on hyphenated parts?
Excel PROPER() treats a hyphen as a word boundary; Title mode here treats only whitespace as a boundary. stainless-steel → Stainless-steel in this tool. Split on the hyphen first if you need PROPER()'s behaviour.
Does it handle accented characters?
Yes — JavaScript case methods handle standard Unicode. Save and re-open as CSV UTF-8. Locale-specific rules (Turkish i) are not applied.
How many rows can I bulk-convert?
Free 500 / 2 MB; Pro 100,000 / 100 MB; Pro-media 500,000 / 500 MB; Developer unlimited. These are the CSV-family limits enforced by the tool.
Does my sheet get uploaded?
No. The CSV Case Converter runs in your browser. Even a wide customer sheet stays on your machine.
What do I get back?
A CSV with headers preserved and all (or selected) columns' data cells re-cased. Re-open in Excel or chain into whitespace trimming or dedup.
Can I undo if I picked the wrong mode?
Keep the original CSV (or the original .xlsx) and just re-run with the correct mode. The conversion is deterministic, so re-running from the source always gives a clean result.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.