CSV column case converter: lower case, UPPER CASE or Name Case for chosen columns
In short: Upload a list, tick the columns and pick a case. Emails go to lower case, shouting names to Name Case, and the other columns stay as they were. Limit: It follows common naming rules, not every language's.
Upload a CSV or .xlsx file, or paste it with a header row. Tick the columns to change and choose lower case, UPPER CASE, Title Case or Name Case. Name Case keeps small words such as van and de, and McDonald and O'Neil style names. Other columns stay untouched and you download the file.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
Four example emails to lower case change 2 cells: AVA@ACME.COM and Ben@Globex.de.
- Cells changed
- 2
- Column
- Case
- lower
What this means for you
Case does not change whether a mailbox exists; a check shows which addresses exist.
- Lower, UPPER, Title, Name Case
- Keeps van, de, McDonald
- Mixed case left alone
- Header untouched
- Case
- CSV
- Names
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Changed the case? Check the addresses before the send.
- Download the file, or use the check button under the result, which carries its addresses across.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I change the case of a CSV column?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Tick the columns to change.
- Choose lower case, UPPER CASE, Title Case or Name Case.
- Check the rows that changed and download the file.
Example
- You enter
- Four rows with an Email column holding AVA@ACME.COM, Ben@Globex.de, cara@initech.io and dev@hooli.com, changed to lower case.
- You get
- 4 rows read, 2 cells changed in 2 rows: ava@acme.com and ben@globex.de. The two that were already lower case are unchanged.
- Limits
- Runs in your browser; nothing is uploaded. Case does not change whether a mailbox exists.
Which case should I use for which column?
Use lower case for an email column, so the same address is not kept twice with different capitals. Use Name Case for first and last names that arrive in all capitals or all lower case. Use UPPER CASE for codes such as country or state abbreviations. Title Case suits job titles and cities.
Name Case keeps small words such as van, von, de, della and la in lower case after the first word, writes Mc names as McDonald and O' names as O'Neil, and capitalises each part of a hyphenated name.
What does the all-capitals-or-lower-case option do?
For Title Case and Name Case, the default is to change a cell only if it is written entirely in capitals or entirely in lower case. A cell that is already mixed, such as McDonald, de la Cruz or iPhone, is left as the person wrote it. Untick the option to rewrite every cell.
Cells with no letters, such as a number or a phone number, are never changed.
What does it not do?
It follows common rules, not every culture's naming. Names such as MacDonald written in capitals become Macdonald, because there is no safe way to know where a second capital belongs; check names you care about. To clean names in a mail merge, use the first name cleaner; to rename the headers, use the CSV column editor.
Who uses this tool, and for what?
- Marketers
- Fix names that arrive in capitals before a mail merge.
- Cold emailers
- Put the email column in lower case so repeats line up.
- Analysts
- Make a city or title column consistent before a pivot table.
What can’t this tool tell you?
- It follows common naming rules, not every language's.
- A name written MACDONALD becomes Macdonald, because only Mc and O' are recognised.
- Only the body rows are changed, not the header.
- Only the first sheet of a workbook is read.
Common questions
- Does it change the header row?
- No. Only the body rows of the ticked columns are changed. To rename headers, use the CSV column editor.
- Will it lower-case the whole email address?
- Yes, in lower case mode. Email addresses are not case sensitive in practice, though the part before the @ can be in rare cases, so check with your sending tool if you rely on that.
- What happens to McDonald?
- With the default option it is left alone, because it is mixed case. If a name arrives as MCDONALD or mcdonald, Name Case writes McDonald.
- Can I change several columns at once?
- Yes. The same case is applied to every ticked column.
- Does it need an email column?
- No. Any CSV works. If the list has a column of addresses, the check button under the result carries them across.
- Is my file uploaded?
- No. The file is read in your browser and goes nowhere.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.