I suggest you ...

How to export contacts from Mighty Text (to google contacts)

Open excel,

Copy and paste your contacts from mighty text into your excel spreadsheet.

It will look like one big column with:
Aon Doe 123 123 1234 (mobile)
Jon Doe 123 456 7890 (mobile)
Jon Dot 123 456 7899 (mobile)
...etc...

Select the open cell next to your list (B1) and copy and paste the formula below and hit ctrl+shift+enter

=1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$70),1)),0),COUNT(1*MID(A1,ROW($1:$70),1)))

This should extract out all and only numbers to column B. (you may need to clean up row A a tiny bit, delete parentheses and minus signs, if not all your numbers extract)

Should look like this,
123 123 1234
123 456 7890
123 456 7899
...etc...

To extract all names, select the open cell next to your numbers (C1) and copy and paste the formula below and hit enter

=LEFT(A1,MIN(FIND({"0","1","2","3","4","5","6","7","8","9"},A1&"0123456789"))-1)

This should extract out all and only names to column C.

Should look like this,

Aon Doe
Jon Doe
Jon Dot
...etc...

Now you need to put these two columns into a form that google contacts understands. Click the link below, copy and paste the top row there to an excel sheet.

https://spreadsheets.google.com/ccc?key=0Ahg0Kn8xqrSkdEhqWUdvQVVrVmN3dGNzQWVJZkFKcHc&hl=en

Copy and paste your names (Column C) from sheet 1 to your new sheet into column A.

Copy and paste your numbers (Column B) from sheet 1 to your new sheet into column AJ.

Save sheet as ".csv (comma delimited)" file.

Go to your gmail, click "gmail" in the top left, click "contacts" in the drop down menu, click "more" in the top left/middle, click "import" in the drop down. Import your .csv file.

yay! vote so ppl see this.

15 votes
Vote
Sign in
(thinking…)
Sign in with: sso facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
chenbrianchen shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: sso facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base