How to format phone numbers consistently in a CSV
Your phone numbers are all over the place: some have dashes, some have parentheses, some are just digits. You need them all in the same format for your system.
See it in action
Prompt
"Format all phone numbers as (XXX) XXX-XXXX"
Before
| # | name | phone | |
|---|---|---|---|
| 1 | Alice Brown | 5551234567 | alice@email.com |
| 2 | Bob Smith | 555.987.6543 | bob@work.co |
| 3 | Carol Davis | 1-555-246-8135 | carol@company.io |
After
| # | name | phone | |
|---|---|---|---|
| 1 | Alice Brown | (555) 123-4567 | alice@email.com |
| 2 | Bob Smith | (555) 987-6543 | bob@work.co |
| 3 | Carol Davis | (555) 246-8135 | carol@company.io |
Why use Magic CSV for this?
- Standardize any phone format to your preferred style
- Works with international numbers too
- Clean up messy data from multiple sources
Related guides
- Standardize Date Formats
Convert any date format to your standard
- Format Currency Values
Standardize currency with proper symbols and decimals
Ready to transform your data?
Upload your CSV, describe what you want, get clean data back.