CRM

dzungk
Participant

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

SOLVE

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. 

0 Upvotes
1 Accepted solution
Phil_Vallender
Solution
Most Valuable Member | Elite Partner
Most Valuable Member | Elite Partner

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

SOLVE

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

View solution in original post

3 Replies 3
Phil_Vallender
Solution
Most Valuable Member | Elite Partner
Most Valuable Member | Elite Partner

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

SOLVE

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
MichaelThelle1
Participant

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

SOLVE

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

0 Upvotes
dzungk
Participant

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

SOLVE

Thanks Phil,

 

It worked. 

0 Upvotes