hisabimbola/script

Created September 2, 2016 06:12

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/hisabimbola/3ce35e4fb6530c0ea4eff44035ceb5ae.js"></script>
Save hisabimbola/3ce35e4fb6530c0ea4eff44035ceb5ae to your computer and use it in GitHub Desktop.

Download ZIP

Add extensions to Google Contacts

Raw

script

=IF(LEN(REGEXREPLACE(IF(LEN(SUBSTITUTE(AL1," ","")) = 11,SUBSTITUTE(AL1," ",""),""),"^0","+234")) = 14,REGEXREPLACE(IF(LEN(SUBSTITUTE(AL1," ","")) = 11,SUBSTITUTE(AL1," ",""),""),"^0","+234"),AL1)

Author

hisabimbola commented Sep 2, 2016

To use:

Export Contacts from Google Contacts,
Import into Google Sheets
Duplicate the "Phone 1 - value" column
Copy and paste the formula in the duplicated column
Info: You can update the formula to add your own extension, this currently add '+234' which is the extension for Nigeria. Update '+234' to your own extension.
Replicate the formula to affect all rows
Copy the value in the duplicated row, and paste only the value with the formula
Delete the old column
Download as CSV from the Google sheet, and import to Google Contacts
Sometimes, Google imports it as duplicates, so just use Google duplicate finder to find and merge duplicates

Voila!!! You done.

I am happy to help out in case of any issue

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment