What is the best way to update multiple contacts phone numbers?

SOLVE
Regular Contributor

The mobile network providers in my country are going to make a change in the format of Mobile Numbers.

 

Says all numbers starting with 0168 will be changed to 038 says: 0168XXXXXXX will be changed to 038XXXXXXX. 0120XXXXXXX will be changed to 070XXXXXXX.

(The XXX will not be changed).

 

I'm worrying that this will affect many of my contacts. What is the best way that I can use to update mobile phone numbers of my contacts?

I'm using Hubspot CRM free edition and have around 500 contacts. 

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Community Thought Leader | Diamond Partner

Hi @dzungk

 

Wow, that's a big change. And tricky to apply to all contacts in a CRM. 

 

The easiest approach is probably to export all your contacts with phone numbers containing '0168' to excel, perform a find and replace to swap it with '038' and re-import those contacts (just email address for dedupe and the new phone numbers) back into HubSpot. 

 

Hope this helps. 

Phil Vallender | Inbound marketing for B2B technology companies
3 Replies 3
Community Thought Leader | Diamond Partner

Hi @dzungk

 

Wow, that's a big change. And tricky to apply to all contacts in a CRM. 

 

The easiest approach is probably to export all your contacts with phone numbers containing '0168' to excel, perform a find and replace to swap it with '038' and re-import those contacts (just email address for dedupe and the new phone numbers) back into HubSpot. 

 

Hope this helps. 

Phil Vallender | Inbound marketing for B2B technology companies
Regular Contributor

Thanks Phil,

 

It worked. 

Reply
0 Upvotes
Highlighted
Occasional Contributor

Hi @Phil_Vallender 

This did the trick for me aswell, but ideally, this could be solved via workflow where you just replace or append text to the property like we know it from spreadsheets.

I'm having a similar issue where I need to add a country code to all my phone numbers and this is currently not possible via workflows... Any chance we can add this to the wishlist?
Michael

Reply
0 Upvotes