Changing contact to canonical form (adding + country_code)

Question

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?

score 8 · Accepted Answer · answered Jan 05 '12 at 10:44

8

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.

answered Jan 05 '12 at 10:44

Ace

659
2
5
10

+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 01:08

score 1 · Answer 2 · edited Apr 05 '13 at 05:04

1

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:

Open the CSV, XLS, or XLSX file as Google spreadsheet
Edit > Find and replace
Select the option Search using regular expression
Find ^91 will search all numbers in sheet beginning with 91. In replace, put +91
Similarly, do for all contacts of yours with other country codes

edited Apr 05 '13 at 05:04

geffchang

17,565
18
57
73

answered Apr 05 '13 at 04:42

Prajakta

11
1

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 05 '13 at 07:28

score 0 · Answer 3 · answered Dec 22 '12 at 00:12

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.

score 0 · Answer 4 · edited Oct 25 '14 at 22:40

0

How about Easy Prefix Country Code?. This adds country code to all contacts selectively.

edited Oct 25 '14 at 22:40

ale

19,723
34
110
159

answered Oct 25 '14 at 14:05

Khan

1

Changing contact to canonical form (adding + country_code)

4 Answers4