Technobabble

CSV to vCard Conversion Tool

97 Comments

Recently my company moved phones systems to a new VOIP provider. The transition was much smoother than expected on a technical level but we now have all new phone numbers. This posed a challenge to update everyone’s individual vCards. We had all this information in a spreadsheet so I figured I would just download a spreadsheet (or csv file) to vCard converter. After spending way too much time looking, I decided just to build one myself.

CSV to vCard Creator is a simple online tool that will convert a comma delimited file (comma-separated values or CSV) file and into separate vCard (.vcf) files by row.

How it works:
The process the data and converts it into a bunch of vCard files into a directory that is compressed into a zip file for your download.  You may encrypt the zip file simply by entering in a password in the web form before uploading the file.  All data will be deleted off the server after it is processed except for the zip file.  You will have 24 hours to download the zip as many times as you would like before it is deleted.

Instructions on how to use this tool

  1. Download the sample CSV file for reference: csv_schema.csv
  2. Open the CSV reference file in Numbers (Mac) or Excel (PC)
  3. Copy and paste the corresponding columns from your csv file to the sample csv file. ie: copy all the first names from your CSV file into the firstName column of the sample file, and so on. You MUST make your csv file fit the template csv file or the conversion WILL NOT WORK. Leave cells blank if you don’t have the information for the person.
  4. Export the template file (that now has all your CSV contacts) to CSV format. Numbers (mac) – Go to File in the top bar -> Export -> select CSV option -> next -> choose a name and export.
  5. Upload the file you just exported into this tool.

>> Click here to open the tool.  <<

Further Help:

Upload only a .CSV file (not .xls)

Each row will become a new vCard contact

Make sure to keep the columns the same as the template. The first column (or column A) is the “First Name” of the contact.  The second column (or column B) is the “Last Name“, etc.

You can leave any field (or cell) blank if you don’t have data to add to it

If there is a comma in any field (or cell), put quotes around it like this: “Vice President, Emerging Markets” or it will process it as two different fields

Dates are formatted in number with a 4 digit year followed by a 2 digit month and 2 digit day.
Thus January 05, 2012 would like this 20120105

For the website or image URL leave off the "http://" and just put in the address like this "dennismueller.org/blog"

For addresses use a semicolon to separate an address.  For example:
1 Market St.
San Francisco, CA 94105
United States of America

Should look like this:
1 Market St.;San Francisco;CA;94105;United States of America

97 thoughts on “CSV to vCard Conversion Tool

  1. Hi Dennis,
    I enjoyed reading your disclaimers!
    Your VCard converter works great as long as you start with your supplied template.
    My only issue so far is that the photos don’t seem to be working.
    I’ll continue to explore.
    Thanks!

  2. That is weird. I have not seen that unless thee was an error and never processed your CSV file. Please try just using me sample file and see if that works.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 580 other followers