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.
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
- Download the sample CSV file for reference: csv_schema.csv
- Open the CSV reference file in Numbers (Mac) or Excel (PC)
- 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.
- 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.
- Upload the file you just exported into this tool.
>> Click here to open the tool. <<
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