Select the option Comma as CSV (comma-separated values) files are generally separated by commas.Click the Format dropdown list and choose CSV.Open your web browser and visit vCard to LDIF/CSV Converter, an online tool.Choose a location to keep the file you are going to export.From the top menu bar, choose File > Export > Export vCard.In the left sidebar, select All on My Mac (or a sub-group under it).Steps to export Mac contacts to CSV through conversion The conversion may take quite a while if the vCard file is relatively large.Here are the instructions to export iCloud contacts to CSV and export iPhone contacts to CSV. If you want to export contacts from these places, the same method can also help. In addition, Apple provides a cloud-based contact management service known as iCloud Contacts. The (Apple) Contacts app is also available for iOS.If you only need to export selected contacts, choose On My Mac in the sidebar, select the specific contacts in it, control-click and choose Export. By following the 6 steps above, you can straightforwardly export all Mac contacts to CSV.You can export Mac contacts with valid fields, all fields or custom fields. The method allows you to control the fields to be exported.Select a location on your Mac to store the exported comma-separated values.To export Mac contacts to Excel Spredsheet, select Excel from the Format drop-down list. To export Mac contacts to CSV, select CSV from the Format drop-down list.Right-click On My Mac in the left sidebar and choose Export.When you open it for the first time, click OK to permit access to your contacts on Mac.Steps to export Mac contacts to CSV or Excel directly

Format text in excel for mac 2011