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 iCloud.com, which you can access from any device you want. You will follow these steps to make it happen.
1) Head over to iCloud.com in your preferred web browser and log in with your credentials.
2) Now click on the Contacts app from the list of provided services.
3) Next, wait for your contacts to load, and then click on the Settings cog at the bottom left of the webpage.
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.
5) Once selected, click on the Settings cog once again, and this time click on the Export vCard… option.
6) A vCard file will now be downloaded to your computer’s Download’s folder.
7) Open your favorite web browser once again, and visit the following URL:
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.
9) A CSV file will now be downloaded to your computer’s Downloads folder:
10) Test the file by opening it in Microsoft Excel or Apple Numbers. Everything should be sorted in an organized manner.
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.
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.
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:
9) Open the file to ensure that everything looks good. It can be opened with either Microsoft Excel or Apple Numbers.
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.
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.
- Transferring contacts from one iOS device to another
- Removing unwanted email addresses from the Mac’s Mail app
Did you know you could export your contacts as a CSV or XLS file? Share in the comments below!