Normalize Case in Columns

Normalise capitalisation in table columns. Fix names like McDonald and O'Brien, Title Case, lowercase emails and UPPERCASE codes, only in the columns you pick.

  • Free, no sign-up
  • Runs in your browser
  • Your data stays private

How to use the Normalize Case in Columns

  1. Paste your table and list the columns to change.
  2. Choose proper names, Title Case, Sentence case, lowercase or UPPERCASE.
  3. Copy the table and review the changes tab.

Why use this Normalize Case in Columns

  • Proper namesHandles O'Brien, McDonald, van Beethoven and suffixes such as III.
  • Column targetingChange only name and city columns and leave emails alone.
  • Change logA table lists every cell that changed, before and after.
  • Header optionOptionally apply the change to the header row too.

Frequently asked questions

How do I fix ALL CAPS names in a spreadsheet column?

Choose that column and "Proper names". JOHN SMITH becomes John Smith.

Does it handle names like McDonald and O'Brien?

Yes. Mc prefixes, apostrophes, hyphens and lowercase particles like "van" are handled.

Can I lowercase emails only?

Yes. Enter the email column and choose lowercase.

Related tools

More Spreadsheet & CSV tools

User Reviews

–
No ratings yet
Write a review
Your rating *

Your email is never published. Reviews are moderated, and links aren't allowed.

What users are saying

No reviews yet

Be the first to share your experience with this tool — your feedback helps others.