contador web Saltar al contenido

How to export your iPhone contacts to a CSV or Excel file

A CSV file, small as a value file,allows to you store big amount in information in onefilewhat can to be Open with apps in spreadsheet,like for example theMicrosoft ExcelorONumbersfrom Apple.

This is a great and safe way to keep a backup of your contact information, in case there is a problem on your computer or iOS device that causes the loss of that data. This tutorial will show you how to export your contacts to an Excel or CSV file.

Exporting your contacts

You can do this using a Mac / PC or an iOS device. Learn both methods throughout this article.

Creating a CSV file from the contacts in your iCloud account

The most practical way to do this is through a Mac or PC through iCloud, which can be accessed on any device you want. Follow the steps:

1 – Go to iCloud.com in your browser and login with your data.

photo_2016-07-05_18-17-02 "width =" 640 "height =" 359 "srcset =" https://iphonedicas.com/wp-content/uploads/2016/07/photo_2016-07-05_18-17-02 -1024x575.jpg 1024w, https://iphonedicas.com/wp-content/uploads/2016/07/photo_2016-07-05_18-17-02-300x169.jpg 300w, https://iphonedicas.com/wp-content /uploads/2016/07/photo_2016-07-05_18-17-02-768x431.jpg 768w, https://iphonedicas.com/wp-content/uploads/2016/07/photo_2016-07-05_18-17-02- 696x391.jpg 696w, https://iphonedicas.com/wp-content/uploads/2016/07/photo_2016-07-05_18-17-02-1068x600.jpg 1068w, https://iphonedicas.com/wp-content/ uploads / 2016/07 / photo_2016-07-05_18-17-02-748x420.jpg 748w, https://iphonedicas.com/wp-content/uploads/2016/07/photo_2016-07-05_18-17-02-350x197 .jpg 350w, https://iphonedicas.com/wp-content/uploads/2016/07/photo_2016-07-05_18-17-02.jpg 1280w "sizes =" (max-width: 640px) 100vw, 640px

2 – ClickContacts in the application list.

IMG_4088 "width =" 640 "height =" 360 "srcset =" https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4088-1024x576.jpg 1024w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4088-300x169.jpg 300w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4088-768x432.jpg 768w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4088-696x391.jpg 696w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4088-1068x600.jpg 1068w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4088-747x420.jpg 747w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4088-350x197.jpg 350w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4088.jpg 1366w "sizes =" (max-width: 640px) 100vw, 640px

3 – Then wait for loading and click Settings in the bottom left corner of the page. Click Select all so that all your contacts are selected for the next step.

IMG_4090 "width =" 640 "height =" 360 "srcset =" https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4090-1024x576.jpg 1024w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4090-300x169.jpg 300w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4090-768x432.jpg 768w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4090-696x391.jpg 696w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4090-1068x600.jpg 1068w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4090-747x420.jpg 747w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4090-350x197.jpg 350w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4090.jpg 1366w "sizes =" (max-width: 640px) 100vw, 640px

4 – With all your contacts selected, click againSettings, and then select the optionExport vCard?

IMG_4095 "width =" 640 "height =" 360 "srcset =" https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4095-1024x576.jpg 1024w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4095-300x169.jpg 300w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4095-768x432.jpg 768w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4095-696x391.jpg 696w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4095-1068x600.jpg 1068w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4095-747x420.jpg 747w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4095-350x197.jpg 350w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4095.jpg 1366w "sizes =" (max-width: 640px) 100vw, 640px

5 – A vCard file will be transferred to your computer's download folder.

IMG_4118 "width =" 640 "height =" 360 "srcset =" https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4118-1024x576.jpg 1024w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4118-300x169.jpg 300w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4118-768x432.jpg 768w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4118-696x391.jpg 696w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4118-1068x600.jpg 1068w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4118-747x420.jpg 747w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4118-350x197.jpg 350w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4118.jpg 1366w "sizes =" (max-width: 640px) 100vw, 640px

6 – In your browser, open the following URL:

image_2016-07-06_19-41-14 "width =" 640 "height =" 360 "srcset =" https://iphonedicas.com/wp-content/uploads/2016/07/image_2016-07-06_19-41-14 -1024x576.png 1024w, https://iphonedicas.com/wp-content/uploads/2016/07/image_2016-07-06_19-41-14-300x169.png 300w, https://iphonedicas.com/wp-content /uploads/2016/07/image_2016-07-06_19-41-14-768x432.png 768w, https://iphonedicas.com/wp-content/uploads/2016/07/image_2016-07-06_19-41-14- 696x391.png 696w, https://iphonedicas.com/wp-content/uploads/2016/07/image_2016-07-06_19-41-14-1068x600.png 1068w, https://iphonedicas.com/wp-content/ uploads / 2016/07 / image_2016-07-06_19-41-14-747x420.png 747w, https://iphonedicas.com/wp-content/uploads/2016/07/image_2016-07-06_19-41-14-350x197 .png 350w, https://iphonedicas.com/wp-content/uploads/2016/07/image_2016-07-06_19-41-14.png 1366w "sizes =" (max-width: 640px) 100vw, 640px

7 ?Click the button Search forand select the vCard file you downloaded earlier. Then, configure the following options as in the image:

  • Format: select CSV, select CommacheckAdd header line
  • Encoding: selectUnicode (UTF-8)
  • Filter: not check anything
  • Modifications: not modified

With everything set up, click the buttonconvert.

IMG_4120 "width =" 640 "height =" 360 "srcset =" https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4120-1024x576.jpg 1024w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4120-300x169.jpg 300w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4120-768x432.jpg 768w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4120-696x391.jpg 696w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4120-1068x600.jpg 1068w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4120-747x420.jpg 747w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4120-350x197.jpg 350w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4120.jpg 1366w "sizes =" (max-width: 640px) 100vw, 640px

8 – A CSV file to be transferred to your computer's download folder.

IMG_4122 "width =" 640 "height =" 360 "srcset =" https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4122-1024x576.jpg 1024w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4122-300x169.jpg 300w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4122-768x432.jpg 768w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4122-696x391.jpg 696w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4122-1068x600.jpg 1068w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4122-747x420.jpg 747w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4122-350x197.jpg 350w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4122.jpg 1366w "sizes =" (max-width: 640px) 100vw, 640px

9 – Test the file by opening it in Microsoft Excel or Apple's Numbers. Everything should be organized in a spreadsheet like this:

IMG_4124 "width =" 640 "height =" 360 "srcset =" https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4124-1024x576.jpg 1024w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4124-300x169.jpg 300w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4124-768x432.jpg 768w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4124-696x391.jpg 696w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4124-1068x600.jpg 1068w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4124-747x420.jpg 747w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4124-350x197.jpg 350w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4124.jpg 1366w "sizes =" (max-width: 640px) 100vw, 640px

Making an XLS Excel file of contacts on your iOS device

For those who wish to do the process through their mobile devices, whether it is iPhone, iPad or iPod Touch, just use the applicationSA Contacts Lite to create an XLS file for Microsoft Excel or Apple Numbers. Follow the steps below:

1 – Download the app.

SA Contacts Lite SA Contacts Lite

2 – Open the app and allow access to your contacts. On the flapExport, touchStart and then onMore. Select where you want to save.

IMG_4127 "width =" 200 "height =" 300 "srcset =" https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4127-200x300.jpg 200w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4127-280x420.jpg 280w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4127-350x525.jpg 350w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4127.jpg 640w "sizes =" (max-width: 200px) 100vw, 200pxIMG_4128 "width =" 200 "height =" 300 "srcset =" https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4128-200x300.jpg 200w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4128-280x420.jpg 280w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4128-350x525.jpg 350w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4128.jpg 640w "sizes =" (max-width: 200px) 100vw, 200pxphoto_2016-07-06_21-10-44 "width =" 200 "height =" 300 "srcset =" https://iphonedicas.com/wp-content/uploads/2016/07/photo_2016-07-06_21-10-44 -200x300.jpg 200w, https://iphonedicas.com/wp-content/uploads/2016/07/photo_2016-07-06_21-10-44-280x420.jpg 280w, https://iphonedicas.com/wp-content /uploads/2016/07/photo_2016-07-06_21-10-44-350x525.jpg 350w, https://iphonedicas.com/wp-content/uploads/2016/07/photo_2016-07-06_21-10-44. jpg 640w "sizes =" (max-width: 200px) 100vw, 200px

3 – The file will be saved in the chosen location, login if necessary.

4 – Now on your computer, open the location where the file was saved. Here we use Dropbox and move to the desktop.

5 – It's over, just open the file in Excel or Numbers.

IMG_4131 "width =" 640 "height =" 360 "srcset =" https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4131-1024x576.jpg 1024w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4131-300x169.jpg 300w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4131-768x432.jpg 768w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4131-696x391.jpg 696w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4131-1068x600.jpg 1068w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4131-747x420.jpg 747w, https://iphonedicas.com/wp-content/uploads/2016/07/IMG_4131-350x197.jpg 350w, https://iphonedicas.com/wp- content / uploads / 2016/07 / IMG_4131.jpg 1366w "sizes =" (max-width: 640px) 100vw, 640px

Keep the file in a safe place. If you lose access to your device, lose your contacts or iCloud is unavailable, a backup of your contacts will be saved as a spreadsheet on your computer after this process.

Liked? Share this experience with your friends and stay tuned here on iPhoneTips !!