[Q] Best way to edit google contacts csv export? - Galaxy S 5 Q&A, Help & Troubleshooting

I have no problem exporting my Google contacts to a CSV file. I do find however when I import the file into Excel 2010, there is some major "overlapping" from line to line. By that I mean, the first column will often be something from the contact in the line above it. And sometimes there are actually blank lines.
How do I go about importing the CSV into Excel 2010 in the most efficient way? Is there a particular method that will make the CSV import so that all fields for a contact are on one line? Any help on this would be much appreciated; I have already looked around for what I really want, which is a bulk contact editor that will let me assign a particular value to multiple selected contacts or groups in my contacts, and haven't found that exact thing yet. This is the next best method I can think of to assign an organization to multiple contacts without having to edit every single contact individually.

Related

How to import contacts to touch

Friends,
I have recently switched from Nokia 3230 to HTC Touch. I have all my 3230 contact backed up in ".vcf" format. How shall i import all contacts to Touch.
there are more than 250 contacts, which are impossible to enter manually.
Please help me soon bcoz i m using touch without any contacts now :-(
Try to beam them from PC to Touch. Message like "Do you want to save <name> in your contats?" should appear, wait till all contacts are transfered and press "Yes to all"
kalpesh99 said:
Friends,
I have recently switched from Nokia 3230 to HTC Touch. I have all my 3230 contact backed up in ".vcf" format. How shall i import all contacts to Touch.
there are more than 250 contacts, which are impossible to enter manually.
Please help me soon bcoz i m using touch without any contacts now :-(
Click to expand...
Click to collapse
.vcf format is not supported by pocket pc and wont be recognized
how abt saving them to ur sim card and then savin them back in ppc contacts
if your sim card gets full...u can try by going at steps of 100 contacts per round or 50
gronostaj said:
Try to beam them from PC to Touch. Message like "Do you want to save <name> in your contats?" should appear, wait till all contacts are transfered and press "Yes to all"
Click to expand...
Click to collapse
what do you mean by "BEAM them"?? and i have all contacts in single '.vcf' file.
How shall i go about it??
When I switched from my Nokia 6620 I just saved all my contact from my 6620 in address book on my computer (using sinc for Nokia) and then opened Outlook and imported the contact from Address book to outlook. Once this is done, just use Activsinc (for touch) to sinc contacts to the touch. Worked for me. I had almost 200 contacts and it took only about 10 minutes to do it. (Ten minutes of waiting for Sinc to be completed)
hotrod101 said:
When I switched from my Nokia 6620 I just saved all my contact from my 6620 in address book on my computer (using sinc for Nokia) and then opened Outlook and imported the contact from Address book to outlook. Once this is done, just use Activsinc (for touch) to sinc contacts to the touch. Worked for me. I had almost 200 contacts and it took only about 10 minutes to do it. (Ten minutes of waiting for Sinc to be completed)
Click to expand...
Click to collapse
Hi
the real problem for me is (its sort of irony), the day i bought Touch, my nokia 3230 died. It does not boot at all. otherwise I could have sent all contacts from 3230 to Touch by bluetooth only.
right now, what i have in my hand is only a '.vcf' file having all my contacts (which i had created on 3230 using some 'backup contacts' application).
I searched on the net a lot for the application for winMobile which can import contacts from '.vcf' file, but i did not get a single appl.
So even after starting using Touch for 5 days, i am without any contacts on Touch...
Copying contacts into SIM and then retrieving has huge lose of information
ayyu3m said:
.vcf format is not supported by pocket pc and wont be recognized
how abt saving them to ur sim card and then savin them back in ppc contacts
if your sim card gets full...u can try by going at steps of 100 contacts per round or 50
Click to expand...
Click to collapse
Copying contacts into SIM and then retrieving has huge lose of information
1. name and surname are stored in single field in SIM with limited characters.. so name or surname is truncated.
2. If i have stored 3 numbers for a single person, all are stored as different contacts in SIM.. so combining them in Touch will anyways be a headache
3. any photo stored in contact is not saved in SIM.
But with '.vcf' file, all above problems are taken care of. so i am searching a WM application to retrieve contacts from '.vcf' file
Any application that can convert 'vcf' file into WM recognizable format will also be of great help.
.vcf = V Card File. Microsoft address book on your desktop can read V Card Files.
However; your HTC Touch does not so you have to convert them.
Open Microsoft Outlook. Go to IMPORT - click Import .vcf file. Choose your backed up vcf files and click. This will grab your .vcf files and convert them for outlook. They will be converted to become outlook address book files (unsure of what format / extension that is - Didn't check) Outlook will sinc with your device when you connect and voila === All contacts can be on your new device in the proper format since Outlook address book is compatible with WM Devices. The End.
PS. Make sure your activsinc is set up to sincronize contacts.
kalpesh99 said:
Hi
the real problem for me is (its sort of irony), the day i bought Touch, my nokia 3230 died. It does not boot at all. otherwise I could have sent all contacts from 3230 to Touch by bluetooth only.
right now, what i have in my hand is only a '.vcf' file having all my contacts (which i had created on 3230 using some 'backup contacts' application).
I searched on the net a lot for the application for winMobile which can import contacts from '.vcf' file, but i did not get a single appl.
So even after starting using Touch for 5 days, i am without any contacts on Touch...
Click to expand...
Click to collapse
Transfering your contacts from Nokia using bluetooth probably wouldn't have worked - Different format that the WM device does not recognize. It didn't work for me when I tried that first. My Nokia 6620 contacts were all .vcf files so when I sincronized by nokia to my computer my contacts automatically were saved on my computer in Microsoft address book as .vcf files.
You have them already saved as a .vcf file. All you need now is Microsoft outlook - and go to file - import - import .vcf file. voila converted and now in proper format for WM Device.
hotrod101 said:
.vcf = V Card File. Microsoft address book on your desktop can read V Card Files.
However; your HTC Touch does not so you have to convert them.
Open Microsoft Outlook. Go to IMPORT - click Import .vcf file. Choose your backed up vcf files and click. This will grab your .vcf files and convert them for outlook. They will be converted to become outlook address book files (unsure of what format / extension that is - Didn't check) Outlook will sinc with your device when you connect and voila === All contacts can be on your new device in the proper format since Outlook address book is compatible with WM Devices. The End.
PS. Make sure your activsinc is set up to sincronize contacts.
Click to expand...
Click to collapse
Hi...
I think outlook reads '.vcf' file as a single contact person detail. when i double-click on my '.vcf' file, which contains all the contacts, it shows up only first entry of .vcf file and not other contacts.. same thing happened when i imported .vcf file into outlook from 'file->impot->import vcf file'. It imported only first contact info of all contacts.
that means i have to first break my .vcf file (containing 250 contacts) into 250 different vcf files and then import them to outlook ???!!
kalpesh99 said:
Hi...
I think outlook reads '.vcf' file as a single contact person detail. when i double-click on my '.vcf' file, which contains all the contacts, it shows up only first entry of .vcf file and not other contacts.. same thing happened when i imported .vcf file into outlook from 'file->impot->import vcf file'. It imported only first contact info of all contacts.
that means i have to first break my .vcf file (containing 250 contacts) into 250 different vcf files and then import them to outlook ???!!
Click to expand...
Click to collapse
Try importing to Microsoft Address book first then to see if it will open all contacts. Once this is done you (if it does work) you will have to save each .vcf contact as a seperate .vcf file seperately onto your desktop- *(Shouldn't take too long) then use outlook to import the .vcf's.
I have a sneeking suspicion though that when you did your backup you might have only backed up one contact and not all of them.
When you backup .vcf's as an address book it is no longer a .vcf extension but something entireley different (the extension eludes me right now). like I said before .vcf stands for V Card file - ( one address card or file ) not address book. I hope that I am wrong though and that the Microsoft address book will open all the contacts for you.
Otherwise, you might have to try to find a way to either fix your Nokia just to properly backup your contacts or start from scratch as I don't know of any other way.
It is simple, but takes some time.
The cellfone accepts the .vcf cards... but you will have to follow these steps:
1. Copy all your contacts to your PC using the "explorer-friendly" folder at "My Computer" - this folder appears if you have installed Nokia PCSuite.
2. Then, after inslalling ActiveSync, a folder named "Mobile Device" will appear, which control the cellphone files.
3. Open the "Mobile Device" through "My Computer" and create a folder named "Contacts" inside your cellphone.
4. Copy all your previuos contacts to the new folder.
5. Using your cellphone, open the new folder which contains the new contacts, and CLICK ON EACH ONE > the phone will ask if you want to add the contact, then click YES.
It takes some time, depending on how many contacts do you have.
Thanks a lot folks
Thanks a lot hotrod101 and ov3r
using combination of steps suggested by you, I couls import all my contacts to Touch.
Following are the steps which might be useful to anybody else as well
1. in winXP open start->accessories->"Address book"
2. click file->import->business card (vCard)
3. "Address book" builds all contacts which r there in '.vcf' file and shows in form of list of individual vcf contacts
4. connect Touch to PC and open any folder in HTC through activesync explorer
5. select all contacts displayed in "address book" and drag them to particular folder in Touch.
6. inside mobile, keep clicking on individual file, where it prompts for saving contact.
7. this way, save all contacts (really cumbersome clicking all 250 contact file, but certainly easier than typing each contact manually.
*. One loss is photo stored in 'vcf' files are not imported to Touch.
Thanks a lot all folks who took out time to reply and suggest steps which lead me to import all contacts.
still one problem...
ooooopppppssss !!!
still one problem...
if there r more than 1 mobile numbers stored per contact, only 1 number is imported (in XP Address book itself). it allows only 1 mobile, 1 landline number to be imported, not 2 or more of each type..
One more query....
One more query....
Contacts in touch also show SIM contacts.... how to turn them off and view only phone contacts (since i have stored some imp contacts on SIM... so they are shown double in contact list, one from SIM and other from phone)
kalpesh99 said:
ooooopppppssss !!!
still one problem...
if there r more than 1 mobile numbers stored per contact, only 1 number is imported (in XP Address book itself). it allows only 1 mobile, 1 landline number to be imported, not 2 or more of each type..
Click to expand...
Click to collapse
Interesting problem. I don't know if importing the VCF's to Outlook would have solved that problem either. You could try to import one of the .vcf's with multiple #'s to outlook and see if all of the #'s made it. But it probably isn't going to be worth the effort. Just sinc now with your computer - then update all of the missing phone # and re sinc. unless you have a lot of contacts with missing phone #'s it shouldn't be that much hassle.
PS. Glad that you were able to get all of the contacts on there though. You must be so releived.
I don't know what to say about the SIM contacts though because I don't store my contacts to my SIM. Why not just delete the duplicate entry?
hotrod101 said:
Interesting problem. I don't know if importing the VCF's to Outlook would have solved that problem either. You could try to import one of the .vcf's with multiple #'s to outlook and see if all of the #'s made it. But it probably isn't going to be worth the effort. Just sinc now with your computer - then update all of the missing phone # and re sinc. unless you have a lot of contacts with missing phone #'s it shouldn't be that much hassle.
PS. Glad that you were able to get all of the contacts on there though. You must be so releived.
I don't know what to say about the SIM contacts though because I don't store my contacts to my SIM. Why not just delete the duplicate entry?
Click to expand...
Click to collapse
indeed i am relieved with all your help.... I did not have many contacts with double numbers.. so for such contacts, i will manually add second number...
Regarding storing contacts in SIM, it is needed when your cell stops working and u need to put your SIM in some other mobile to make call to anybody.. if no numbers r there in SIM, and ur cell stops working, I will be screwed up since i dont memorise any number
kalpesh99 said:
ooooopppppssss !!!
still one problem...
if there r more than 1 mobile numbers stored per contact, only 1 number is imported (in XP Address book itself). it allows only 1 mobile, 1 landline number to be imported, not 2 or more of each type..
Click to expand...
Click to collapse
that's really a problem, cuz Touch has many fields: cel, home phone, home p.2; work, work 2 etc; but does not have a field named "cellphone 2" or similar.
so, if a contact has two cellphones registered in its .vcf file, only one number will be imported. it's an incompatibility between Nokia and HTC field arrangement.
you may solve the problem by switching one of the numbers (ex: the less used by the person) to a differente field, i.e., "car phone", but before copying the .vcf file to the phone.
that's the only thing you can solve this problem.
PS: the second number (of two cellphone numbers) is in my phone as "car phone" or as "radio phone" in my contact list.
how to make .vcf file from my HTC Touch Pro?? because i'm going to update my ROM.. i've been trying to find it, but i coudn't find the way to safe it as .vcf file.
i would like to back up all my contact detail from my HTC...
please someone who know about this matter help me..
thank you
excelex said:
how to make .vcf file from my HTC Touch Pro?? because i'm going to update my ROM.. i've been trying to find it, but i coudn't find the way to safe it as .vcf file.
i would like to back up all my contact detail from my HTC...
please someone who know about this matter help me..
thank you
Click to expand...
Click to collapse
U could look for Cellica.Contacts.Synchronizer

From "phone" to "google" in contacts?

Any one who can guide me on how to change contact groups (source) from "phone" to "google" after the contact is created?
This has made me with a goddarn shatty contact list!! Even worse, I cannot sync more than a few contacts since about 95% of em got "phone" and I cannot edit them from google/contacts..
Hope you lads get my point..
Streaker said:
Any one who can guide me on how to change contact groups (source) from "phone" to "google" after the contact is created?
This has made me with a goddarn shatty contact list!! Even worse, I cannot sync more than a few contacts since about 95% of em got "phone" and I cannot edit them from google/contacts..
Hope you lads get my point..
Click to expand...
Click to collapse
I had exactly same problem with my Magic because I imported my contacts from SIM. This is how I did it.
1) Used HTC Sync app to sync contacts to outlook express
2) Export contacts from outlook express as CSV file
3) Imported into google contacts through web interface on PC (http://www.google.com/contacts)
4) Edit as you need and you will have option change group to My Contacts for each contact
This process is little laborious. You also change the view of contacts in contacts application options.
yschandra said:
I had exactly same problem with my Magic because I imported my contacts from SIM. This is how I did it.
1) Used HTC Sync app to sync contacts to outlook express
2) Export contacts from outlook express as CSV file
3) Imported into google contacts through web interface on PC (http://www.google.com/contacts)
4) Edit as you need and you will have option change group to My Contacts for each contact
This process is little laborious. You also change the view of contacts in contacts application options.
Click to expand...
Click to collapse
There's ExportContacts in the Market that will export your contacts as a csv file onto you SD card. Then you can import them into google contacts. That's what I did anyway.

How to import contacts and/or messages from my N97 to my Nexus One??

Hi Guys,
I'm new to xda-dev and I'll get my nexus one tomorrow or on monday (DHL screwed up delivery yet again here in London).
The first most important thing for me is to import my 500+ contacts from my Nokia N97 to the nexus and I have no clue how to do this since it's a different OS.
Can someone please guide me in details asap??
I heard about the using mail for exchange sync (steps needed) and this thing called "sprite migrate" (google it as I'm barred from posting links for now) which has free apps for Nokia (symbian) n Nexus (android) to do it.
Has anyone ever used any of these?? Also I have my Nokia contacts etc. backed up on the latest version of Ovi suite if that can be used as well.
Thanks a lot and please reply.
PS: I did a search and did not find a relevant thread answering this so please make this exhaustive.
I'd focus on getting your n97 contacts into Outlook Express/Windows mail/Etc first. Most contact formats can be imported into Gmail (and thus automatically synced to your N1)
But the n97->something on windows step is pretty nokia specific so I can't help you there.
I did the same thing for my gf and her N85. First, go into your Nokia's settings and copy all contacts to your SIM card. Then when you put your SIM card into your N1, you can import all the contacts off the SIM. Voila.
Thanks guys, my phone just arrived n i'll try the simple sim copy first (how do we forget such basic things!)...if not then the sprite migrate app sounds totally brilliant after reading the manual...copies bookmarks, texts, music, pics etc too!!
i had over 600 contacts and couldnt copy it to SIM. Instead i installed mail exchange on my n97 and synced with google contacts. Then it automatically synced with my Nexus one. Good luck.
Download the nokia pc suite. Install. It will read your contacts when you connect the nokia to the pc. From the suite export as csv file.
Go to gmail, create a dummy entry with the fileds you will need. Export from gmail contacts as csv.
Then open nokia csv file in excel and also gmail csv in excel.
Copy paste nokia csv contacts to the right columns in the gmail csv file.
when done, save gmail csv file and import back to gmail. Then synch contacts form the nexus. They will magically appear on the phone.
My contacts where 548. Everything worked smooth.
If something appears wrong, then check again/correct gmailcsv file on the pc and to the same procedure again. delete contacts from gmail beforehand.
You could install MailForExchange and sync your contacts directly to Google, as per here: http://www.google.com/support/mobile/bin/answer.py?hl=en&answer=147951
I used that to migrate from N95 to N1
Thing you're SOL with the messages though, I'm afraid.
htcmagic said:
Download the nokia pc suite. Install. It will read your contacts when you connect the nokia to the pc. From the suite export as csv file.
Go to gmail, create a dummy entry with the fileds you will need. Export from gmail contacts as csv.
Then open nokia csv file in excel and also gmail csv in excel.
Copy paste nokia csv contacts to the right columns in the gmail csv file.
when done, save gmail csv file and import back to gmail. Then synch contacts form the nexus. They will magically appear on the phone.
My contacts where 548. Everything worked smooth.
If something appears wrong, then check again/correct gmailcsv file on the pc and to the same procedure again. delete contacts from gmail beforehand.
Click to expand...
Click to collapse
You shouldn't need to create a dummy entry. I managed to get contacts off a nokia 5800, by simply exporting the csv from pc suite and uploading it direct through gmail.
hey i am using ovi suite with my nokia phone and i have all my contacts synced there and i tried syncing them with outlook then exporting csv and importing it into gmail. but there are some faults with this. some fields are not created in outlook (like nickname) and when i have more than one number assigned to a contact sometimes the second number or the third is not added to outlook. how can i exactly export my contacts as they are on my ovi suite ?
Screw OVI. Like I said above, use MailForExchange.
Ok, a lot of people immediately advocate Google Sync. Here's the problem and it's a KNOWN ISSUE with S60. Google Sync using MfE will NOT copy the different phone #s of the same contact. This was a problem for me. Sure only like 10-20 contacts of mine had multiple #s listed under their name, but I didn't want to go through line by line and fix it.
So you can:
1) Use Outlook to deal with it which should do it flawlessly
2) Use SIM (but I highly recommend you to look elsewhere and not use this)
3) I settled and instead of bothering with Outlook and installing PC Suite and crap, I decided to use Mac OSX. I have heard friends telling me how they plug in random dumbphones into their Mac and it does it all. Yeah. It did. My N82 synced FLAWLESSLY with iSync which comes built in. This is the one time I'm going to act like a retarded Mac user and scream "OMG my mac does everything." Somehow it just handles pulling contacts off FLAWLESSLY. It got the multiple #s for my contacts. I synced it onto my Moto Milestone without any trouble. Yay!
As for your SMS and maybe other info, try this:
http://www.spritesoftware.com/ - Look for Sprite Migrate software. It's free.
I tried it on my N82 but it failed. I submitted an error log, and it seems someone else had some issues with FP1 devices, and the manufacturer is aware. However you're on S60v5 so you might have better luck. People don't care about FP1 devices anymore so I think I'm SOL. Give it a try. Trust me I've looked into this issue a lot and I've crossposted on 20 forums about this (ok more like 2-3).
GoogleSync via MfE does copy all numbers for each contact, lots of mine have multiple numbers and all made it to GoogleContacts.
Not only that, it also copied the contacts pictures, their birthdays, etc.
SPRITE MIGRATE sounds ace!
lambrospower said:
hey i am using ovi suite with my nokia phone and i have all my contacts synced there and i tried syncing them with outlook then exporting csv and importing it into gmail. but there are some faults with this. some fields are not created in outlook (like nickname) and when i have more than one number assigned to a contact sometimes the second number or the third is not added to outlook. how can i exactly export my contacts as they are on my ovi suite ?
Click to expand...
Click to collapse
http://www.spritesoftware.com/products/migrate/how-does-it-work-
I just did the simple copy to sim and then to N1 method and then sorted duplicates out on google contacts site.
But I read about "sprite migrate" which is free and seems to transfer all messages/contacts nicely. Apps available on ovi store and android market to get u going as their instructions state. Let us know.
Easiest way ever
It's pretty simple:
1) get rid of Nokia Ovi Suite
2) Go to Nokia website and downloads Nokia Pc Suite ( i got version 7.1.51)
3) Follow on screen intructions for app install & phone connection
4) With the phone connected, click on the "contacts" icon (blue phone book). It will open Nokia Communicator, and a list with all your contacs
5) Select all of them( click on the first one, then go for CTRL + A)
6) Go to: File > Export
7) Choose a file name and location.
8) Go into: Gmail > Contacts > More actions > Import
9) Pick the csv file you just created, and have a nice and easy import
Congratulations on
Being well over a year too late
Coming up with a more long-winded solution than the one already posted
Lol @ above post.

Microsoft Myphone to Android / GMAIL

I recently bought an Aria, and there is no looking back. My previous phone was a fuze. All of my data is backed up on Microsofts Myphone service, I've been able to retrieve most of my data and contacts since Android auto syncs with GMAIL. However, I have a lot of data "stuck" on microsoft myphone. Is there a way to extract that data? Microsoft doesnt seem to have any export service on the site. Is there any easy way to do this? I'd rather not spend hours manually adding contacts into GMAIL while browsing the myphone page.
My suggestion is to put your sim back into your old phone, setup Google Sync to sync everything from your old phone to Gmail. I don't think there will ever be Android to MyPhone sync.
How to export from Microsoft MyPhone to CSV for Gmail
I know this post is quite old but I thought I'd post my solution here to save others time. It took me quite a while to get the CSV format right but it works.
First goto the myphone contacts page and right click-> view source.
Just up from the bottom of the source, you will find all the contact details wrapped in some ugly JavaScript. Copy it into a new text file (I used Notepad).
Repeat this for all the pages of your contacts.
At the very start of the text file, add this line:
Name,Mobile Phone,Home Phone,Other Phone,E-mail Address,E-mail 2 Address
It can be edited to whatever fields you want but these map perfectly into your gmail contacts. There isnt any very good documentation on which fields to use so it's trial and error.
Now go through and edit out all the JavaScript so you're left with just the data. I used Find/Replace to remove a lot of it then went through and tidied it all up manually, adding in the commas and sorting it into the correct order for the fields above. Its a long process but is easier than manually re-entering everything.
Go through and check it's all correct and the comma's are all in the right place. Each contact entry should be a new line and don't leave blank lines.
Save your file. You can now open it in a spreadsheet program to check all the fields line up correctly.
Now try it - goto your Gmail contacts and click "More Actions" -> "Import". Select your CSV file. I recommend adding them to an empty group so its easy to check them and delete them if it doesn't work correctly.
Click Import. Now go through and check them. If its not quite correct, delete them and try again. If you find certain details end up in the Notes field then it means you've used an incorrect field name.
I'm sure someone can write a nice script to do this all but I really don't have the time at the moment and I've already done it manually.
Hope this helps and Microsoft..... you should really have an export option!
I did this way when I jump to android world from WM:
I synced all contacts with outlook. Then export to CSV file from outlook, and imported to gmail contacts those files. I cant remember how exactly but u can find easily with google.
Thank you, it solved my problem (not without some work, but nevertheless in a small fraction of the time)

Importing contacts

The user manual indicates the Iconia A500 can import contacts in the CSV format. I tried it but it didn’t work. I also tried converting my CSV files to VCard. That didn’t work either.
Can anyone help me solving this issue?
Thanks for your support.
The best and easiest way to do it is to import your contacts to Gmail. Do you have any specific reason why you want to import your contacts as Iconia contacts? Having your contacts in Gmail is better so you also see the same contacts on your phone, assuming that you have an android phone.
Well, actually that’s exactly what I had done and yes, the contacts were imported but the addresses are all garbled.
I used the following procedure:
1 - I exported the contacts from Outlook to a CSV file.
2 - On my windows machine, I logged in to Gmail and imported the CSV file.
3 - On the Iconia, I logged in to Gmail and my contacts synchronised.

Categories

Resources