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

Leave a Reply