Convert CSV text to proper case
Sign-up forms and older systems leave you with ANA RUIZ, ben ode and sAN fRANCISCO in the same list, which looks careless in a mail merge, on a shipping label or on an invoice. Upload the file and SpreadsheetFix gives every word a capital first letter and lower-cases the rest, in the columns you choose. It runs in your browser without uploading your list. Normalize Case is a Pro rule.
- Plan
- Pro rule
- Account
- Not required
- Upload
- None
No file to hand?
Before and after
first_name,last_name,city ANA,RUIZ,SAN FRANCISCO ben,ode,new york émile,zola,PARIS cARA,lIN,los angeles
first_name,last_name,city Ana,Ruiz,San Francisco Ben,Ode,New York Émile,Zola,Paris Cara,Lin,Los Angeles
How it works
- 1
Upload the CSV or Excel file. With Pro, Normalize Case opens already set to Title Case.
- 2
Use the column picker to choose the columns to convert (names, cities, product titles) and leave out emails, codes and IDs.
- 3
Preview every changed cell, then download.
What Title Case does here
Each word, meaning a run of characters that starts with a letter or digit and ends at the next space, gets an upper-case first letter and the rest in lower case. “SAN FRANCISCO” becomes San Francisco, and accented letters work too, so “émile” becomes Émile. Punctuation inside a word doesn’t start a new word, so JEAN-LUC becomes Jean-luc and O’NEIL becomes O’neil.
Choose columns before you run it
With no columns selected, Normalize Case changes every text column in the file. That would turn ana@acme.io into Ana@acme.io and an invoice number like INV-101 into Inv-101. Open the column picker on the rule and tick only the columns that hold names or titles; everything else is left exactly as it was.
Names that need a second look
Title Case is a rule, not a dictionary. It can’t know that McDonald has a second capital, that van der Berg is often written with lower-case particles, or that IBM should stay in capitals; those come out as Mcdonald, Van Der Berg and Ibm. It gets the bulk of a list right in one pass, and the preview highlights every changed cell so you can spot the few names worth fixing by hand.
Questions
How do I change text to proper case in a CSV?
Upload the file, pick the name or title columns in the Normalize Case column picker, and run it. Every word in those columns starts with a capital and the rest is lower case. This needs Pro.
Is this the same as Excel’s PROPER function?
It does a similar job across whole columns at once, without a helper column or a formula to fill down. One difference: PROPER capitalises after any non-letter, giving Jean-Luc and O’Neil, while SpreadsheetFix only starts a new word after a space, giving Jean-luc and O’neil.
Will it change numbers or dates?
Digits have no case, so values like 2024-03-01 or 1299.00 come out the same. Codes that mix letters and digits, such as AB-100X, do change, which is another reason to choose your columns first.
Is my customer list uploaded?
No. The conversion runs in your browser with JavaScript, and names and addresses never leave your computer.
Is proper-case conversion free?
No. Normalize Case is a Pro rule (€12/month). Pro also raises the row limit from 5,000 to 500,000 rows per file.