CleanMySheet guide
Format phone numbers in CSV or Excel
CleanMySheet uses the + / 00 country codes already in the column to format the rest. Default output is international (e.g. +91 98765 43210 or +1 415 555 0100). 10-digit Indian mobiles are not rewritten as US (555) numbers. Apply Format phone numbers from the catalog. Columns are detected by header (phone, mobile, cell, WhatsApp) or sample values. Aadhaar / PAN / SSN columns are skipped.
Phone numbers will be highlighted after scan.
Drop CSV or Excel here
Tap to choose a file. Parsing stays on this device.
Parsing stays on this device. Optional: drop a .cleanmysheet.json recipe with it.
Steps
- Upload the contact file
- Search “phone” and apply Format phone numbers
- Review Diff view
- Export
Not a carrier lookup
This is formatting, not validating that a number is in service. Invalid short strings are left alone.
Related searches this page answers
- format phone numbers excel
- normalize phone csv
- clean mobile numbers spreadsheet