What is the easiest way to export a Contact spreadsheet?
 

I'd like to move my contacts to a new device from my beloved brick, and have been trying to find the easiest way.

Ideally I'd like to export a spreadsheet from my phone and then upload that into my main Google Apps email account.

I have tried MfE to sync my contacts, but it's giving some errors. I'm also using Backup app, but that created a zip file and I've started looking through it but there's a lot in there and no sign of a contacts spreadsheet!

My preference would be to just export all contacts to a spreadsheet and then take that off the device. Is that possible, please?

Re: What is the easiest way to export a Contact spreadsheet?
 

Open contacts, hit the title bar and press export. You will get a list of vcards in a directory ready for you to transfer to your other device.

Re: What is the easiest way to export a Contact spreadsheet?
 

oh my word, that was so easy! I can probably manipulate the vcards into the new device (it's a htc) or into Google Apps

thanks!

Re: What is the easiest way to export a Contact spreadsheet?
 

remember there is one vcard per contact, so it kind of becomes PITA to import them.

you can use the following command to merge all vcard into one file

more *.vcf > ../all.vcf

and then open the all.vcf in notepad++ and replace END VCARDBEGIN VCARD with END VCARD\n\n BEGIN VCARD

as every thing is appended in one file, the next vcard does not got to new line after ending of previous vcard.

once the replace is done, you are all set to import all the vcard into google or outlook or evolution.

Re: What is the easiest way to export a Contact spreadsheet?
 

thank you, that is particularly helpful! i would not have had a clue how to merge those vcards into 1 file and really appreciate the detailed help.

Re: What is the easiest way to export a Contact spreadsheet?
 

thanks mehulrajput!

I'm having some trouble with the find/replace step - would you have a few minutes to help please?

I created the all.vcf file, and here's an excerpt. (I snipped the details obviously for privacy). As you can see I don't have a "END VCARDBEGIN VCARD" string, it's different in each case.


::::::::::::::
Abbey.vcf
::::::::::::::
BEGIN:VCARD
VERSION:3.0
UID:1397
REV:2010-05-31T13:44:15Z
TEL;TYPE=CELL,VOICE:+353 <snip>
FN:Abbey
N:Abbey;;;;
END:VCARD::::::::::::::
Adrian Lynch.vcf
::::::::::::::
BEGIN:VCARD
VERSION:3.0
UID:1398
REV:2010-05-31T13:44:15Z
TEL;TYPE=CELL,VOICE:+353<snip>
FN:Lynch\, Adrian
N:Lynch;Adrian;;;
END:VCARD::::::::::::::
Adrienne Mockler.vcf
::::::::::::::
BEGIN:VCARD
VERSION:3.0
UID:1399
REV:2010-05-31T13:44:15Z
TEL;TYPE=CELL,VOICE:+353<snip>
FN:Mockler\, Adrienne
N:Mockler;Adrienne;;;
END:VCARD

On top of that I don't have (and can't seem to figure out how to get) notepad++ for my ubuntu. I have gedit and the doing find-replace with /n/n only adds in '/n/n' as opposed to adding in a new line.

Any tips, please?

Re: What is the easiest way to export a Contact spreadsheet?
 

You can use "glogarchive 0.7"

It exports to ".csv" is read by Excel, etc ...

Re: What is the easiest way to export a Contact spreadsheet?
 

Try using cat instead:
Note back slash not forward slash

Re: What is the easiest way to export a Contact spreadsheet?
 

oh i sorry didn't realise you have ubuntu installed. it is much more easier in ubuntu :-)... so here you go..

create all.vcf using the following command. you will have to be in the directory where single vcf for each contact is kept.

cd <directory to where single vcf are kept>
more *.vcf > ../all.vcf
cd ..

now open vi editor

vi all.vcf

type the following command

:%s/END VCARDBEGIN VCARD/END VCARD\n\nBEGIN VCARD/g
:wq

and you are all set. sorry do not know how to do it through gedit as i more of a vi guy :-)

Re: What is the easiest way to export a Contact spreadsheet?
 

You can do all of that using the N900 shell: