How to Export vCards From Mac Mail to CVS

The Numbers application can import vCard data and export it into different formats.

All Apple computers running the Mac OS X operating system come with the Mac Mail application installed. Mac Mail and other similar desktop email clients store contact information in a file format known as a vCard. However, you may come across the need to work with vCard data in a spreadsheet or database application that can only recognize text files. With the Numbers application from the Apple iWork suite, you can export vCard data as comma separated text files.

Things You'll Need

• Mac running OS X 10.5 or later
• iWork '08 or later

Instructions

1. Launch the Numbers application on your Mac.

2. Open an existing spreadsheet file or double-click on the "Blank" template option to create a new one.

3. Drag and drop the vCard file into the cell in the upper-left corner of the spreadsheet. Numbers will automatically import the vCard data and separate it into rows and columns.

4. Open the "File" menu at the top of the screen and select "Export."

5. Go to the "Comma Separated" tab at the top of the pop-up window. Press "Next."

6. Navigate to the location on your hard drive where you want to save the converted file and enter a name for it in the "Save As" field.

7. Hit the "Export" button to convert the vCard data into a comma separated text file and save it to the selected location.

References

• Apple Support: Adding Address Book Data to an Existing Table
• Apple Support: Exporting to Other Document Formats