Contacts to CSV File Guide

A CSV file, which is short for a comma-separated values file, allows you to store vast amount of information in a file that can be opened with spreadsheet apps like Microsoft Excel, or Apple’s Numbers app just like other spreadsheet file types can be.

This is a great way to keep a backup of your Contacts information safe for whenever you have a catastrophic meltdown on your computer or iOS devices, and in this tutorial, we’ll show you how to you can export your Contacts to either an Excel or a CSV file.

Exporting your Contacts

You can actually do this whether you’re on a Mac/PC or if you’re on an iOS device. We will show you both methods.

Making a CSV file from the contacts in your iCloud account

The most convenient way to do this from a Mac or PC is from, which you can access from any device you want. You will follow these steps to make it happen.

1) Head over to in your preferred web browser and log in with your credentials.

Log in to iCloud website Apple

2) Now click on the Contacts app from the list of provided services.

iCloud Website Contacts App

3) Next, wait for your contacts to load, and then click on the Settings cog at the bottom left of the webpage.

iCloud Website Contacts Settings Button

4) From the list, click on the Select All option to make sure you have all of your contacts selected before proceeding to the next step.

iCloud Website Contacts Select All

5) Once selected, click on the Settings cog once again, and this time click on the Export vCard… option.

iCloud Website Contacts Export vCard

6) A vCard file will now be downloaded to your computer’s Download’s folder.

vCard File Mac Finder Downloads Folder7) Open your favorite web browser once again, and visit the following URL:

CSV Converter Website

8) Click on the Choose File button and select the vCard file you downloaded earlier. Then, configure the following options as such:

  • Format: choose CSV, choose Comma, enable Add Header Line
  • Encoding: choose Unicode (UTF-8)
  • Filter: don’t change anything
  • Modifications: don’t change anything

Once configured, click on the Convert button.

CSV Converter Website Convert Button

9) A CSV file will now be downloaded to your computer’s Downloads folder:

Mac Finder Downloads Folder CSV File

10) Test the file by opening it in Microsoft Excel or Apple Numbers. Everything should be sorted in an organized manner.

CSV File in Microsoft Excel

And you’re done! Your contacts will be organized by name and their information will be displayed in this spreadsheet.

Making an XLS Excel file from contacts on your iPhone or iPad

For those of you who will be tackling this from your mobile device, whether it’s an iPhone, iPod touch, or iPad, you can just use a free App Store app called SA Contacts Lite to make an XLS file for Microsoft Excel or Apple Numbers instead.

To do this, follow these steps:

1) Download and install the app on your iOS device.

2) Launch the app, and when you’re asked to give the app access to your Contacts, allow it.

SA Contacts Lite Export Contacts to Excel

3) Tap on the blue Start button, then from the next interface, tap on the More button.

4) Select the desired output source for the XLS file. We’ll be using Dropbox because it’s convenient for us.

5) Sign in to your selected service. Since we choose Dropbox, it will ask us to sign into Dropbox.

Export iPhone Contacts to Excel With SA Contacts Lite App

6) Next, you will tap on the blue Continue button, and the upload process will begin as it sends the file to our Dropbox account.

7) The app prompts you, saying it’s complete. Tap OK.

8) Now on your Mac or PC, you can open your output source. In our case, it was Dropbox. The file should be sitting there and waiting for you to open:

Mac Finder Dropbox Contacts XLS file

9) Open the file to ensure that everything looks good. It can be opened with either Microsoft Excel or Apple Numbers.

XLS File with contacts in it

And that’s all there is to it! All of your contacts should show up in this XLS file and they will be organized by name.

Wrapping up

Now that you have a CSV or XLS file backed up, you should really consider putting it somewhere safe, such as on a backup hard drive or flash drive. This will ensure that whenever you lose your iOS device, Mac, or other Apple device, you will always have a backup and can re-add contacts if necessary.

Although iCloud works great for keeping your contacts in sync across all of your devices, there are times when iCloud sees downtime and may not work properly, so having your own spreadsheet file is a great way to ensure you always have an offline list of your contacts and their information and makes re-adding it in the future a breeze.

Also read:

Did you know you could export your contacts as a CSV or XLS file? Share in the comments below!

  • Joaquim N.

    Thank you for the online vcf converter tool. Really helpful!

  • Erik Aukerman

    Thanks for this I have been looking for a way to do this for some time. It doesn’t seem to work in chrome or maybe its because I am on windows. The tutorial is on OSX so I will try it on my mac.

  • Noohar

    Don’t want to be “that guy” but the App is a fail in my books. Still not updated for larger 6 Plus & 6s Plus screen.

  • MrTarek

    and anyway without iCloud?

  • Agneev Mukherjee

    This is one article, I’ll regret reading because It’s practically useless with iCloud syncing and no, I’ve never encountered downtimes in 6 years of using Apple products… Why do so much of hassle?

  • IG: RuskingGonzalez

    I’m running iOS 9.0.2, i want th emoji from last iOS, but i will install the jailbreak on my iPhone running 9.0.2, is there any tweak that i can use so i can use new emojis?

  • Lorenzo Ghedini

    Maximum file size allowed: 8 MB in Online vCard converter

  • Alexander Schwarz

    Thanks, still works!

  • Darryl Ingham

    You just saved me a massive amount of work – too easy. Thank you

  • Dennis Harris

    Finally, a way to export my phone list to Thunderbird on my PCs, and for free! I tried 2 or 3 other exporters on my 550 number phone list, and they all failed, but SA Contacts Lite did the job. Thanks!