{"id":32440,"date":"2017-08-16T04:05:09","date_gmt":"2017-08-16T04:05:09","guid":{"rendered":"http:\/\/www.leawo.org\/entips\/?p=32440"},"modified":"2020-06-23T08:43:23","modified_gmt":"2020-06-23T08:43:23","slug":"how-to-export-iphone-contacts-to-csv-file-1114","status":"publish","type":"post","link":"https:\/\/www.leawo.org\/entips\/how-to-export-iphone-contacts-to-csv-file-1114.html","title":{"rendered":"How to Export iPhone Contacts to CSV File"},"content":{"rendered":"<p><i>&quot;I wish to export all my iPhone contact data to a single excel worksheet. Is there a way to export the data to an XLS or a CSV format (not separate CSV files for each contact)? I have the contacts in both my iPhone and the iCloud, but iCloud allows export as a vCard only.<\/i>&quot; - An Apple user posted on Apple Communities<\/p>\n<p>When you change to a new phone, it is vital to back up contacts on computer. Exporting iPhone Contacts to CSV file is a good way to keep your contact information safe. Now follow me to learn how to export iPhone Contacts to CSV file.\n<\/p>\n<div class=\"anchor-list-dark\">\n<ul>\n<li><strong><a href=\"#part1\">Solution 1: Export iPhone Contacts to CSV file with iCloud<\/a><\/strong><\/li>\n<li><strong><a href=\"#part2\">Solution 2: Export iPhone Contacts to CSV file with SA Contacts Lite on iPhone<\/a><\/strong><\/li>\n<li><a href=\"#part3\"><strong>Solution 3: Export iPhone Contacts to CSV file with Leawo iTransfer<\/strong><\/a><\/li>\n<\/ul>\n<\/div>\n<h2 class=\"wp-part\" id=\"part1\"><strong>Solution 1: Export iPhone Contacts to CSV file with iCloud<\/strong><\/h2>\n<p>Generally speaking, iCloud is the simplest way to export iPhone Contacts to CSV file. Follow these steps to learn exporting iPhone Contacts to CSV file with iCloud.<\/p>\n<p>1. Enter iCloud.com with Apple ID and password.<\/p>\n<div class=\"tc\"><a href=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1.jpg\"  onclick=\"return hs.expand(this)\"><img decoding=\"async\" data-src=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1.jpg\" title=\"How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1\" alt=\"How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1\" width=\"600\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><\/div>\n<p>2. Click Contacts and tap on gear icon at bottom left to choose &quot;Select All&quot;.<\/p>\n<div class=\"tc\"><a href=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-iCloud2.jpg\"  onclick=\"return hs.expand(this)\"><img decoding=\"async\" data-src=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-iCloud2.jpg\" title=\"How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1\" alt=\"How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1\" width=\"600\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><\/div>\n<p>3. Click the settings icon again and choose &quot;Export vCard&quot;, you can download it to your computer.<\/p>\n<div class=\"tc\"><a href=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-iCloud3.jpg\"  onclick=\"return hs.expand(this)\"><img decoding=\"async\" data-src=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-iCloud3.jpg\" title=\"How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1\" alt=\"How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1\" width=\"600\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><\/div>\n<p>4. Open any web browser and enter https:\/\/labs.brotherli.ch\/vcfconvert\/. <\/p>\n<div class=\"tc\"><a href=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-iCloud4.jpg\"  onclick=\"return hs.expand(this)\"><img decoding=\"async\" data-src=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-iCloud4.jpg\" title=\"How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1\" alt=\"How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1\" width=\"600\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><\/div>\n<p>5. Upload vCard file by tapping on &quot;Choose File&quot; and choose CVS in the &quot;Format&quot;. Keep other default settings and then click &quot;Convert&quot;, the CSV file will be downloaded to computer. <\/p>\n<div class=\"tc\"><a href=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-iCloud5.jpg\"  onclick=\"return hs.expand(this)\"><img decoding=\"async\" data-src=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-iCloud5.jpg\" title=\"How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1\" alt=\"How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1\" width=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><\/div>\n<p>6. Go to the folder and open the file to see if it does work in Microsoft Excel.<\/p>\n<div class=\"tc\"><a href=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-iCloud6.jpg\"  onclick=\"return hs.expand(this)\"><img decoding=\"async\" data-src=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-iCloud6.jpg\" title=\"How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1\" alt=\"How-to-Export-iPhone-Contacts-to-Excel-with-iCloud1\" width=\"600\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><\/div>\n<h2 id=\"part2\" class=\"wp-part\"><strong>Solution 2: Export iPhone Contacts to CSV file with SA Contacts Lite on iPhone<\/strong><\/h2>\n<p>For some people, they would like to handle the issue on iPhone. In this way, you can try to export iPhone Contacts to CSV file with SA Contacts Lite on iPhone.<\/p>\n<ol class=\"pl40\">\n<li>Download SA Contacts Lite and open it on iPhone. You will be asked to give the app access to contacts. Allow it and then continue.<\/li>\n<li>Click the blue &quot;Start&quot; and then &quot;More&quot; in the next interface.<\/li>\n<div class=\"tc\"><a href=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-SA-Contacts-Lite1.jpg\"  onclick=\"return hs.expand(this)\"><img decoding=\"async\" data-src=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-SA-Contacts-Lite1.jpg\" title=\"How-to-Export-iPhone-Contacts-to-Excel-with-SA-Contacts-Lite1\" alt=\"How-to-Export-iPhone-Contacts-to-Excel-with-SA-Contacts-Lite1\" width=\"600\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><\/div>\n<li>Choose one output source you would like. Here we advise you to choose &quot;Dropbox&quot; for the sake of convenience.<\/li>\n<div class=\"tc\"><a href=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-SA-Contacts-Lite2.jpg\"  onclick=\"return hs.expand(this)\"><img decoding=\"async\" data-src=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/How-to-Export-iPhone-Contacts-to-Excel-with-SA-Contacts-Lite2.jpg\" title=\"How-to-Export-iPhone-Contacts-to-Excel-with-SA-Contacts-Lite2.jpg\" alt=\"How-to-Export-iPhone-Contacts-to-Excel-with-SA-Contacts-Lite2.jpg\" width=\"600\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><\/div>\n<li>A box will pop up to ask you to sign in Dropbox. After that, tap on &quot;Continue&quot; and then it starts to export iPhone Contacts to CSV file. After it finishes, the app will give you a prompt. Click &quot;OK&quot;. Now you can find the Excel contacts file on Dropbox.<\/li>\n<\/ol>\n<h2 id=\"part3\" class=\"wp-part\"><strong>Solution 3: Export iPhone Contacts to CSV file with Leawo iTransfer<\/strong><\/h2>\n<p>With clear and concise interface, <a href=\"https:\/\/www.leawo.org\/itransfer\/\" title=\"Leawo iPhone Transfer software\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Leawo iTransfer<\/strong><\/a> is able to transfer various files including contacts, ringtones, photos, videos, etc. between iTunes, iPhone, iPad and PCs. It is also helpful to back up iPhone data to computer and iTunes. The software costs $19.95 for one year and $29.95 for a lifetime usage. After you pay for it, you can enjoy its services permanently. If you would like to export iPhone Contacts to CSV file, you can use this software to complete exporting iPhone to Excel in three steps with Leawo iTransfer.<\/p>\n<div class=\"container-fluid\">\n<div class=\"row\">\n<div class=\"jumbotron of myjumbotron-1\">\n<div class=\"container\">\n<div class=\"col-md-5\"> <img decoding=\"async\" data-src=\"\/images\/products-banner\/itransfer.png\" alt=\"iTransfer\" width=\"100%\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/div>\n<div class=\"col-md-7\">\n<h3><strong><a href=\"https:\/\/www.leawo.org\/itransfer\/\" title=\"Leawo iPhone Transfer software\" target=\"_blank\" rel=\"noopener noreferrer\">Leawo iTransfer<\/a><\/strong>&nbsp;<span class=\"win_icon\"><\/span><\/h3>\n<p>\u2609 Transfer files among iOS devices, iTunes and PCs with ease.<br \/>\n            \u2609 Transfer up to 14 kinds of data and files without iTunes.<br \/>\n            \u2609 Support the latest iOS devices like iPhone 7, iPhone 7 Plus, etc.<br \/>\n            \u2609 Play back, view, and delete data and files on iOS devices.<\/p>\n<p class=\"mt10\"> <a href=\"https:\/\/www.leawo.org\/downloads\/itransfer.html\"><img decoding=\"async\" alt=\"\" data-src=\"https:\/\/www.leawo.org\/images\/icon\/Trial_win1.png\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a> <a href=\"https:\/\/www.leawo.org\/downloads\/itransfer-mac.html\"><img decoding=\"async\" alt=\"\" data-src=\"https:\/\/www.leawo.org\/images\/icon\/Trial_mac1.png\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n<p>Download and install this iTransfer on your computer. The below steps would show you how to export iPhone contacts to CSV file with Leawo iTransfer.<\/p>\n<h3 class=\"wp-h3\"><strong>Step 1. Connect iPhone to computer <\/strong><\/h3>\n<p> Plug USB cable to computer and launch the software. You can see iPhone library in the left sidebar.\n<\/p>\n<div class=\"tc\"><a href=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/07\/how-to-transfer-apps-with-leawo-iTransfer1.jpg\"  onclick=\"return hs.expand(this)\"><img decoding=\"async\" data-src=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/07\/how-to-transfer-apps-with-leawo-iTransfer1.jpg\" title=\"Launch the software\" alt=\"cLaunch the software\" width=\"600\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><\/div>\n<h3 class=\"wp-h3\"><strong>Step 2. Select iPhone contacts to export to CSV file<\/strong><\/h3>\n<p>Move to iPhone &gt; Library &gt; Contacts and check all contacts before the contacts name. Afterwards, right click the &quot;Export&quot; button on the right panel.<\/p>\n<div class=\"tc\"><a href=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/how-to-export-iphone-contact-to-excel-with-leawo-itransfer2.jpg\"  onclick=\"return hs.expand(this)\"><img decoding=\"async\" data-src=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/how-to-export-iphone-contact-to-excel-with-leawo-itransfer2.jpg\" title=\"how-to-export-iphone-contact-to-excel-with-leawo-itransfer2\" alt=\"how-to-export-iphone-contact-to-excel-with-leawo-itransfer2\" width=\"600\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><\/div>\n<h3 class=\"wp-h3\"><strong>Step 3: Export iPhone contacts to CSV file<\/strong><\/h3>\n<p>A box will pop up to ask you to choose the output directory and file type. Set the file directory and choose CSV as output file format in the &quot;Save as type&quot; drop-down box. Therefore you can directly export iPhone contacts to CSV file.<\/p>\n<div class=\"tc\"><a href=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/how-to-export-iphone-contact-to-excel-with-leawo-itransfer3.jpg\"  onclick=\"return hs.expand(this)\"><img decoding=\"async\" data-src=\"https:\/\/www.leawo.org\/tutorial\/wp-content\/uploads\/2017\/08\/how-to-export-iphone-contact-to-excel-with-leawo-itransfer3.jpg\" title=\"how-to-export-iphone-contact-to-excel-with-leawo-itransfer3\" alt=\"how-to-export-iphone-contact-to-excel-with-leawo-itransfer3\" width=\"600\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><\/div>\n<p> Leawo iTransfer supports up to 14 types of data and files for you to manage from computer, including: photos, videos, music, contact, note, books, etc. You could transfer and manage all these data and files between iOS devices and computer. If you're using a Mac computer, you could make use of <strong><a href=\"https:\/\/www.leawo.org\/itransfer-mac\/\" title=\"Leawo iTransfer for Mac\" target=\"_blank\" rel=\"noopener noreferrer\">Leawo iTransfer for Mac<\/a><\/strong> for iOS data transferring and managing on Mac.<\/p>\n<h3 class=\"wp-h3\"><strong>Video Demo of How to Use Leawo iTransfer<\/strong><\/h3>\n<div class=\"tc\">\n  <div class=\"lazyload smush-lazyload-video smush-lazyload-youtube\" style=\"--smush-video-aspect-ratio: 560\/315\" data-bg-image=\"url(https:\/\/i.ytimg.com\/vi\/vVPC0VX-Uls\/maxresdefault.jpg)\" ><iframe width=\"560\" height=\"315\" data-src=\"https:\/\/www.youtube.com\/embed\/vVPC0VX-Uls\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\"><\/iframe><span class=\"smush-play-btn\" role=\"button\" aria-label=\"Play video\">\n\t\t\t\t<span tabindex=\"0\" class=\"smush-play-btn-inner\">\n\t\t\t\t\t<span>Play<\/span>\n\t\t\t\t<\/span>\n\t\t\t<\/span><\/div>\n<\/div>\n<h3 class=\"wp-h3\"><strong>Conclusion<\/strong><\/h3>\n<p>If you want to know which method to adopt for exporting iPhone contacts to CSV file on your computer, the below simple comparison might be helpful to you:<\/p>\n<p><strong>1. Ease of use<\/strong>: In comparison, SA Contacts Lite is the easiest way to export iPhone Contacts to CSV file, for you can complete the whole process on iPhone and don't need to use other software or website to convert file format to Excel.<\/p>\n<p><strong>2. Cost<\/strong>:<br \/>\nLeawo iTranfer is paid software that costs $29.95 for permanent use. As the saying goes &quot;you get what you pay for&quot;, once you pay for it, you can enjoy its services for your lifetime. You can easily transfer videos, music, notes, and ringtones between any iOS devices, iTunes and computers, not limited to contacts only.<\/p>\n<p><strong>3. Supported data type<\/strong>:<br \/>\niCloud only supports vCard format, but both Leawo iTransfer and SA Contacts Lite allow users to directly export iPhone Contacts to CSV file.<\/p>\n<p><strong>4. Time consumption<\/strong>: When it comes to time consumption, Leawo iTransfer and SA Contacts Lite are capable of exporting iPhone Contacts to CSV file in a few seconds.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&quot;I wish to export all my iPhone contact data to a single excel worksheet. Is there a way to export the data to an XLS or a CSV format (not separate CSV files for each contact)? I have the contacts &hellip;<\/p>\n<p class=\"read-more\"><a href=\"https:\/\/www.leawo.org\/entips\/how-to-export-iphone-contacts-to-csv-file-1114.html\">Read more &raquo;<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[303,364,340,315],"tags":[21],"class_list":["post-32440","post","type-post","status-publish","format-standard","hentry","category-export-ios-data","category-icloud-tips","category-transfer-data-from-ios-to-computer","category-transfer-iphone-data","tag-itransfer"],"acf":[],"aioseo_notices":[],"views":6002,"_links":{"self":[{"href":"https:\/\/www.leawo.org\/entips\/wp-json\/wp\/v2\/posts\/32440","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leawo.org\/entips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.leawo.org\/entips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.leawo.org\/entips\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leawo.org\/entips\/wp-json\/wp\/v2\/comments?post=32440"}],"version-history":[{"count":0,"href":"https:\/\/www.leawo.org\/entips\/wp-json\/wp\/v2\/posts\/32440\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.leawo.org\/entips\/wp-json\/wp\/v2\/media?parent=32440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.leawo.org\/entips\/wp-json\/wp\/v2\/categories?post=32440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.leawo.org\/entips\/wp-json\/wp\/v2\/tags?post=32440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}