Skip to content

Instantly share code, notes, and snippets.

@hisabimbola

hisabimbola/script

Created September 2, 2016 06:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hisabimbola/3ce35e4fb6530c0ea4eff44035ceb5ae to your computer and use it in GitHub Desktop.
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)
@hisabimbola
Copy link
Author

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