• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

AppleToolBox

Tools and Fixes for Mac, iPad, iPhone & iWatch

Search posts

  • About
  • Contact

CONNECT WITH US

CATEGORIES

  • iPhone
  • iPad
  • iPod
  • Apple Watch
  • Mac/MacBook
  • AirPods
  • Apple TV
  • News
  • Apple Services
  • HomePod
  • Reviews

SITE

  • Home
  • About Us
  • Contact
  • Advertise

Search posts

You are here: Home / iPhone / How to Export Contacts to Excel from your Mac and iPhone

How to Export Contacts to Excel from your Mac and iPhone

By Andrew Myrick 6 comments Last updated December 27, 2019

iCloud is a great tool to have if you are a regular iOS or macOS user. This service backs up just about all of your most important information, including your contacts.

Recently, we took a look at how you can fix iCloud contacts not updating on your Mac. But what if you want to create a “hard copy” of your contacts and export contacts to excel?

Related Reading

  • 7 tips to get the best out of your iPhone contacts
  • How to fix iPhone Favorite Contacts not working
  • How to fix iCloud Contacts not updating on MacBook

Well, the process is actually much easier than one would expect. In fact, you can do so from either your iPhone or from your Mac without experiencing too many headaches.

Contents

  • Export Contacts to Excel from iPhone
      • If you want to export your contacts from your iPhone to excel, follow these steps:
  • Export Contacts to Excel from Mac
      • Here are the steps you need to take to create a vCard:
      • However, as we stated above, this file can not easily be exported to Excel just yet. Instead, there are a few more steps we need to take.

Export Contacts to Excel from iPhone

Starting us off, we are going to take a look at how to export contacts to Excel from your iPhone. As iCloud does not make it easy to export contacts, you will first need to download an app.

The app that we found most useful was Contacts 2 XLS on the App Store. The app is completely free and makes the exporting process easy and painless.

After the app downloads,  create an account. You can use your email address, Google account, or even Facebook to create the account.

From there, you will need to allow Contacts 2 XLS access to your contact list. This is just a permissions check that is built into iOS and is a prompt that you likely see on many new apps installed.

After you are granted access, the contact import into the Contacts 2 XLS application. Then, you are directed to the main screen within the app, where there are a few different options.

From the main screen, you can simply ‘Backup now’, manage your backups, or sign up for a subscription to automatically backup. This is an in-app purchase and costs $14.99 per year, but is not needed for our process.

If you want to export your contacts from your iPhone to excel, follow these steps:

  1. Open Contacts 2 XLS
  2. From the main screen, press Backup now
  3. Once the backup completes, tap the Export icon in the bottom right

After you tap the Export button, you are provided with the share menu from iOS. Now, save the file in a myriad of applications, or you can save to the iOS Files app.

Obviously, you want to make sure that the exported file is sent somewhere that provides easy access. Think about sending it using the Notes app or even sent via an email to yourself.

Export Contacts to Excel from Mac

The process of exporting contacts to excel from your Mac is a bit more tedious than simply downloading an app. For this process, we will need to fire up your browser of choice and head over to iCloud.com.

Unfortunately, you cannot simply export your contacts to excel from here. Instead, you will be creating a “vCard”, which is Apple’s way of keeping your contacts in one place.

Here are the steps you need to take to create a vCard:

  1. Open your preferred browser, navigate to iCloud.com, and log in
  2. From the main panel, click on Contacts
  3. Select a contact then press cmd + A
  4. Tap the Gear icon in the bottom right-hand corner
  5. Select Export vCard

All of your contacts will then appear in your Downloads folder on your Mac. From there, you will want to move this to a safe place, and likely rename the file to My Contacts or something similar.

Export Contacts to excel

However, as we stated above, this file can not easily be exported to Excel just yet. Instead, there are a few more steps we need to take.

  1. Open your preferred browser and navigate to http://labs.brotherli.ch/vcfconvert/
  2. Press Choose File and navigate to your newly created contacts list
  3. Change these settings:
    1. Format: choose CSV, choose Comma, and enable Add Header Line
    2. Encoding: choose Unicode (UTF-8)
    3. Filter: don’t change anything
    4. Modifications: don’t change anything
  4. Press convert

From there, it creates a new .csv file in your downloads folder. Again, think about changing the name of this file to something that you remember or put somewhere safe.

Once it creates this new file, make sure everything is working by opening it in either Excel or Apple Numbers. The contact list is properly sorted and organized by name while giving you all of the information you need.

Related Posts:

  • Excel Lock Header
    How to Password Protect an Excel File on Mac (With…
  • How to Add Solver to Excel on Mac for Effortless What-If Analysis
    How to Add Solver to Excel on Mac for Effortless…
  • export apple numbers to excel
    How to Export an Apple Numbers File to Microsoft Excel
  • 2023 Mac Studio lifestyle – 1
    macOS Could Not Be Installed, How-To Fix
  • MacBook, iPhone, and Camera Lenses
    How to Use Notes on Mac: A Complete User Guide
  • 2022 Mac Mini with Studio Display and Accessories
    Mac Tips For New Users In 2023
  • sidecar on iPadOS and macOS
    Sidecar not working in iPadOS and macOS? How to fix…
  • iphone and airpods on a table
    These Apps Have the Best iOS 17 Widgets
  • photo of an iphone with ios 16 downloaded on it
    iOS 16 Tips and Tricks: The Definitive List
Andrew Myrick
Andrew Myrick

Andrew Myrick is a freelance writer based on the East Coast of the US. He enjoys everything to do with technology, including tablets, smartphones, and everything in between. Perhaps his favorite past-time is having a never-ending supply of different keyboards and gaming handhelds that end up collecting more dust than the consoles that are being emulated.

Reader Interactions

Write a Comment Cancel reply

Show 6 Comments

  1. Kinnebrew IV Joseph says

    December 25, 2021 at 2:57 PM

    WONDERFUL thank you for putting this all together ….I’m going to do it now.

    Cheers

    Reply
  2. Cat says

    December 18, 2020 at 7:30 AM

    Thank you very clear. Now I can get my Christmas cards out!

    Reply
  3. Leena says

    May 6, 2020 at 2:38 AM

    Thank you for this Very helpful!

    Reply
  4. William M Castro says

    January 27, 2020 at 1:06 AM

    Worked like a charm from my MAC 🙂
    Ty!

    -Wil

    Reply
  5. k says

    December 27, 2019 at 5:17 AM

    Response as follows

    Not Found

    The requested URL was not found on this server.

    Apache Server at labs.brotherli.ch Port 80

    Reply
  6. ColD says

    September 5, 2019 at 8:30 PM

    The exported CSV file of iCloud Contacts is pretty useless as all the data fields for each contact are strung together in a single text sting in each row – NOT even separated by any delimiter!

    Reply

Primary Sidebar

Recent Posts

  • How to Fix Apple Music Crashing on Windows 11
  • How to Run Android Apps on iPhone Without Jailbreak
  • How to Share Screen on Teams on MacBook
  • How to Use Microsoft Teams on Mac for Collaboration
  • How to Fix Bad AirPods Sound Quality on PC
  • Use This Trick to Sync Apple Notes and Microsoft Word

Connect with us

Footer

ABOUT

  • About Us
  • Contact us
  • Advertise
  • Privacy
  • Terms of Use

GUIDES

  • iOS & iPadOS
  • Apple ID
  • iCloud
  • App Store
  • iTunes
  • FaceTime
  • iMessage
  • Siri
  • Books and iBooks
  • Game Center
  • AirPlay

CONNECT

  • Facebook
  • Twitter
  • FeedBurner
  • YouTube

© Copyright 2010-2024 Guiding Tech Media · All Rights Reserved

This site and its content are in no way affiliated or endorsed by Apple, Inc. · Reproduction without explicit permission is prohibited

Last Updated on December 27, 2019 by Elizabeth Jones