Contact Management: XLS to CSV, ODS to CSV, CSV to VCARD

If you have a personally made spreadsheet containing contact information, you can easily convert it to CSV format and then to VCARD format so that you can import it into most contact management software (e.g. Evolution, Thunderbird addressbook).
Excel

First, you save the spreadsheet as CSV using commas as delimiters
(using OpenOffice Spreadsheet)
csv format
csv options

Open the CSV file in a text editor and copy the contents to the text field in this web page
http://homepage.mac.com/phrogz/CSV2vCard_v2.html
step1

Go to Step 2 tab and choose the appropriate fields from the drop down
step2

Go to the Step 3 tab and then copy the text in the text field and paste it into a VCF file.
step3

Import the VCF file to your favorite contact management software
(using Evolution)
import

You can see that the name, number, and website are in their proper fields.
fields

Possibly related posts: (automatically generated)

This entry was posted on Saturday, May 17th, 2008 at 6:38 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Contact Management: XLS to CSV, ODS to CSV, CSV to VCARD”

  1. Jeff Says:
    December 9, 2008 at 1:24 am | Reply

    I’m hoping you can help me. When I used this converter to convert a csv to vcf file everything transferred really well into the right places when i imported the list into my imac address book but all the fields were in quotations. How do i eliminate the quotations in this process.

    thanks,

    jeff

  2. efrenefren Says:
    January 23, 2009 at 10:39 am | Reply

    hi jeff. I’m too lazy to look for a solution for that right now. Just try to remove the quotation marks for now..

    I’m very sorry if I was not able to solve your problem but thanks for taking the time to post a comment.

Leave a Reply