Take the 2-minute tour ×
Android Enthusiasts Stack Exchange is a question and answer site for enthusiasts and power users of the Android operating system. It's 100% free, no registration required.

I am using Samsung Galaxy S2. Is there any automated way or app to change all my contacts with appropriate country code into canonical form.

I just found that lot of my contact are there without the country code. And few apps like whatsapp, viber etc does not recognize the contact unless + is appended with country code.

Is there any better way to do it than editing all my contacts?

share|improve this question

5 Answers 5

up vote 6 down vote accepted
+50

You can try syncing your phone contacts with Gmail, preferably into a group.

Then use Gmail's web interface to export that group into a Google CSV format, use a text editor to replace ",00xxx" with ",+xxx" (and do any other editing while you're at it) in the CSV file, and reimport into Gmail.

share|improve this answer
    
+1 for export>edit>import. The 'replace all' function of text editors is about as easy as it gets. –  Mr. Buster Jan 11 '12 at 1:08

I had used an app from the market to correct this as well. Google Contact Formatter. Not free unfortunately, but it did the trick just fine.

share|improve this answer
    
can you post a google play link to this app? –  ce4 Jun 10 '12 at 21:06
    
play.google.com/store/apps/… –  Brandorf Jun 12 '12 at 14:27
    
Thanks. Alas, now its clear why I couldn't find it: "This app is incompatible with all of your devices. This item cannot be installed in your device's country." –  ce4 Jun 12 '12 at 14:37

There is an Android app called Right Number (source available) to do exactly what you want. It reformats all the numbers to a canonical form, and then automatically adds the local prefixes whenever you do a call.

Disclaimer: I know personally one of the authors of that app.

share|improve this answer

In case you want to append country code to your contacts or append +91, here is best way to do and be sure of it done:

  1. Open the CSV, XLS, or XLSX file as Google spreadsheet
  2. Edit > Find and replace
  3. Select the option Search using regular expression
  4. Find ^91 will search all numbers in sheet beginning with 91. In replace, put +91
  5. Similarly, do for all contacts of yours with other country codes
share|improve this answer
    
I'm afraid that method doesn't work to add the appropriate country code, as the OP needs. Unless the appropriate code is already there, and just the "+" is missing -- the question indicates rather otherwise (country codes completely missing). However, if all contacts are from the same country, and the code is missing everywhere, replacing ^([0-9]) with +91-\1 (assuming "+91" as the appropriate country code) would do it :) –  Izzy Apr 5 '13 at 7:28

Currently, the best app to achieve this (and more) completely automatically and for free is Twitch! Contacts Formatter.

I used it and it worked perfectly. It also marks the contacts with invalid phone number for you to decide what to do with it.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.