Fix capitals in names in a spreadsheet
Names typed into forms arrive in capitals, in lower case, or both. Excel's PROPER function helps, but it turns McDonald into Mcdonald and Head of HR into Head Of Hr. Klerio's free cleaner fixes the capitals and gets those right.
How it works
- Open the free cleaner and drop in your CSV or Excel file.
- Tick 'Fix capitals in names'. Klerio finds the name, town and company columns from their headings and contents.
- Check the list of changes before you download.
- Download the file as CSV or Excel.
Why Klerio
- Names done properly: mcdonald becomes McDonald, o'brien becomes O'Brien, mary-jane becomes Mary-Jane.
- Small words stay small: Head of HR, Van der Berg, Stoke-on-Trent and Newcastle upon Tyne.
- Deliberate capitals kept: Names already written with care, like McLeod or DataWorks, aren't touched.
- Companies left as written: Brand names like IBM or easyJet are only changed if they're all in lower case.
Common questions
Why not use PROPER in Excel?
PROPER capitalises every word the same way, so you get Mcdonald, Head Of Hr and a formula column to copy back over the original. The free cleaner changes the values themselves.
Which columns does it change?
Name, town and company columns. Emails, IDs and codes are left alone.
Is it free?
Yes, the free cleaner needs no account, and your file stays on your computer.
More guides
- Remove duplicates from a CSV or Excel file
- Clean a CSV file online, free, without uploading it
- Compare two Excel or CSV files and see what changed
- Merge CSV and Excel files into one
- Clean a contact list, and keep it clean
- Format UK phone numbers and postcodes in a spreadsheet
- The client data tool for virtual assistants
- Split an Excel or CSV file into one file per client
- Convert US dates to UK dates in a spreadsheet
- Match two lists in Excel, without VLOOKUP