Clean phone numbers
“clean the phone number column into one format with country code, and list numbers that are too short”
Clean the phone number column into one format with country code, and list numbers that are too short in Contact list, using 10 digits for US/UK/DE and 9 for AU as the minimum length.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileContact listCSV export · 16 rows
- StepClean and check phone numbersStep 1
- ResultPhone number cleanup16 rows · 16 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 16 rows came out.
- Download Contact list sample (16 rows)Excel: File > Export > CSV
What you get back
The result of that run, the rows to look at first.
| Contact ID | Clean phone number | Status | Original phone number | Country |
|---|---|---|---|---|
| c_1006 | +15551234 | Too short | 555-1234 | US |
| c_1010 | +442079460 | Too short | 020 7946 0 | UK |
| c_1016 | +4989636480 | Too short | 89 636 480 | DE |
| c_1001 | +14155550148 | Length okay | +1 (415) 555-0148 | US |
| c_1002 | +14155550199 | Length okay | 415.555.0199 | US |
| c_1003 | +12125550107 | Length okay | (212) 555-0107 | US |
| c_1004 | +16465550133 | Length okay | +1-646-555-0133 | US |
| c_1005 | +13125550186 | Length okay | 1 312 555 0186 | US |
| c_1007 | +442079460958 | Length okay | +44 20 7946 0958 | UK |
| c_1008 | +442079460805 | Length okay | 020 7946 0805 | UK |
| c_1009 | +4402070460122 | Length okay | +44 (0)20 7046 0122 | UK |
| c_1011 | +61293744001 | Length okay | +61 2 9374 4001 | AU |
How do you format phone numbers in Excel?
Export your contacts from Excel, then clean the phone number column into one format with country code. You can also send any numbers that are too short to a separate list in your contact list. Use 10 digits as the minimum for US, UK, and DE numbers, and 9 digits for AU numbers.
How it works
How to use the Phone number cleanup workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Phone number cleanup: questions
What export should I use?
What happens to rows that do not match the rule?
How do I change the rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Remove duplicate rows, catch invoices paid twice, match messy names to a master list, standardise spellings and turn wide tables long.
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Remove duplicatesOne row of each, with a Copies column saying how many there wereSee the workflow Template
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Compare two listsCompare two exported spreadsheet lists by email, see matches, and label rows where name and email agree or differ.See the workflow Built by the agent
- Duplicate invoice checkPairs of bills that look paid twice: same supplier, same amount, close dates or the same numberSee the workflow Template
- Standardise namesA Standard name for every row, so spellings of the same name group togetherSee the workflow Template