How to Export Contacts From iPhone to a CSV File

If you need your iPhone contacts in a spreadsheet, a new phone, an email program, or a simple backup file, a CSV file is the most useful format. CSV files open in Excel, Google Sheets, and almost every contacts and business tool. The challenge is that the iPhone itself does not have a direct Export to CSV button.

Do not worry. There are several reliable ways to get a proper CSV file, using iCloud on a computer, a Mac Contacts app, or a trusted exporter app. This guide explains each method clearly, plus how to open and check your file afterward.

Quick Answer

The easiest way is to turn on iCloud Contacts on your iPhone, then on a computer sign in to iCloud Contacts, select all contacts, and export a vCard. Then convert that vCard to CSV using a trusted converter, or open the contacts in a spreadsheet-friendly tool. On a Mac, you can also drag contacts from the Contacts app and convert them, while exporter apps on iPhone can create a CSV directly.

What Is a CSV File and Why Use It?

CSV stands for comma-separated values. It is a simple text file where each contact takes one row, and details such as first name, last name, phone number, and email address sit in separate columns separated by commas.

This layout is perfect for viewing and editing a large contacts list. You can sort names alphabetically, find duplicates, fix numbers, or import the list into Gmail, Outlook, customer software, and mailing tools. Most of those services accept CSV directly, which is why people choose it over the iPhone’s default vCard format.

vCard, the .vcf format, is Apple’s standard export. It is excellent for moving contacts between phones, but you cannot easily read or edit it in a spreadsheet. Converting vCard to CSV gives you the best of both worlds: a safe original and an editable working file.

Before You Start: Make Sure Contacts Are in iCloud

Most methods need your contacts synced to iCloud first. Check this on your iPhone before you touch a computer.

Step-by-Step Instructions

1. Open Settings and tap your name at the very top.
2. Tap iCloud, then tap See All or Show All next to Apps using iCloud.
3. Make sure Contacts is turned on.
4. Stay connected to Wi-Fi for a few minutes so any recent contacts finish uploading.
5. Also check where new contacts are saved. In Settings, open Contacts and look at the Default Account. If it is set to Gmail or another account instead of iCloud, those contacts live in that account, not iCloud.

The Apple Support guide to setting up and using iCloud Contacts explains how sync works across iPhone, Mac, and the web, which helps if some contacts appear to be missing.

Method 1: Export From iCloud on a Computer, Then Convert to CSV

This method works on any Windows PC or Mac with a browser. It is free and uses only Apple’s official tools for the export step.

Step-by-Step Instructions

1. On your computer, open your browser and sign in to iCloud with your Apple ID.
2. Open Contacts. You should see the same contacts list as your iPhone. If contacts are missing, return to the iCloud sync check above.
3. Click one contact, then select all contacts. On Windows, press Ctrl + A. On a Mac, press Command + A.
4. Click the share or export icon, or the settings gear, depending on your view, and choose Export vCard.
5. Your browser downloads one .vcf file containing all the selected contacts. Save it somewhere clear, such as your Desktop.
6. Convert the .vcf file to CSV. You can import the vCard into Google Contacts and then export as Google CSV, or use a reputable offline converter tool on your computer.
7. Save the finished CSV with a clear name, for example iPhone Contacts 2026-10-21.csv.
8. Open the CSV in Excel or Google Sheets to verify names, numbers, and emails appear in proper columns.

If you already keep contacts in Google as well, our guide on how to back up contacts to Google and export them as a file shows the Google-side export steps in full detail.

Method 2: Use the Contacts App on a Mac

If you own a Mac signed in with the same Apple ID, your iPhone contacts are already in the Mac Contacts app. From there, export is quick.

Step-by-Step Instructions

1. Open the Contacts app on your Mac and confirm your iPhone contacts are visible.
2. Click a contact, then press Command + A to select all, or hold Command and click to select specific contacts.
3. From the File menu, choose Export, then Export vCard, and save the file.
4. For CSV, import that vCard into Google Contacts or a spreadsheet converter as described above. Some third-party Mac utilities also export Contacts directly to CSV or Excel format.
5. Open the resulting CSV and check a few contacts against your iPhone to make sure numbers and email addresses survived the conversion correctly.

This route is especially good for large lists, because working on a big screen makes it easier to select groups and spot errors.

Method 3: Create a CSV Directly With an iPhone App

If you have no computer available, a contacts exporter app can build the CSV on the phone itself. Choose an app with strong reviews, a clear privacy policy, and no demand for your Apple ID password.

Step-by-Step Instructions

1. Download a trusted contacts export app from the App Store.
2. Open it and allow Contacts permission when asked. Without this permission, it cannot read your list.
3. Choose Export and select CSV as the format.
4. Select All Contacts, or pick specific groups if the app offers that choice.
5. Create the export, then share the file to yourself by email, save it to the Files app, or send it to your computer.
6. Delete the file from any temporary location once your safe copy is stored, because it contains private numbers.

Be careful here. Free exporter apps vary in quality. Never enter your Apple ID password inside a third-party app, and avoid apps that upload your contacts to an unknown server without explanation.

How to Open and Clean Your CSV File

Double-click the CSV file to open it in Excel, or upload it to Google Sheets. Check the first rows carefully. First names, last names, phone numbers, and email addresses should each sit in their own column. If everything appears in one column, the file may use a different separator, and your spreadsheet’s Import or Text to Columns tool can split it correctly.

Use this moment to clean your list. Sort by name to spot duplicates, delete old contacts you no longer need, and fix numbers missing country codes. Save a clean master copy, and keep the original export untouched as your raw backup. Also keep the original .vcf file, because it is the best format for restoring contacts back to a phone later.

Common Mistakes to Avoid

• Exporting before iCloud sync finishes: New or edited contacts will be missing. Give Wi-Fi sync time and confirm the full list appears in iCloud first.
• Forgetting contacts stored in Gmail or Outlook: iCloud only shows iCloud contacts. Contacts saved to another account must be exported from that account separately.
• Trusting random online converters with private data: Your contacts file reveals many people’s numbers. Prefer offline tools or official services like Google Contacts for conversion.
• Deleting the vCard after converting: CSV is for spreadsheets and imports. Keep the .vcf too, because phones restore from it most reliably.
• Not checking the file: A quick column check catches broken exports before you wipe or change your phone.
• Leaving copies in email and downloads forever: Move the file to a protected backup folder and remove stray copies.

Conclusion

The iPhone does not export CSV directly, but the two-step route is simple: sync contacts to iCloud, export a vCard from iCloud or a Mac, and convert it to CSV for spreadsheets and other apps. Or use a carefully chosen exporter app when no computer is available. Keep both the CSV and the original vCard in a safe backup folder, and you will always have your address book in a format you can read, edit, and restore anywhere.

Frequently Asked Questions

Can I export iPhone contacts to CSV without a computer?

Yes. A trusted contacts exporter app can create a CSV file on the iPhone itself. Share the finished file to your email or Files app, then store it safely off the phone as well.

Why does iCloud only export vCard instead of CSV?

vCard is the universal contacts standard Apple uses for moving contacts between devices. Converting that vCard through Google Contacts or an offline tool is the standard way to get a spreadsheet-ready CSV.

Will the CSV file include contact photos?

Generally no. CSV holds text details such as names, numbers, emails, and addresses. Photos stay in the vCard file, which is another reason to keep both formats.

Some contacts are missing from my export. What went wrong?

They are probably saved in a different account, such as Gmail or Outlook, or iCloud sync had not finished. Check the Default Account in iPhone Contacts settings and export each account separately if needed.

Can I import this CSV back into an iPhone later?

Not directly into the iPhone Contacts app. Import the CSV into iCloud Contacts or Google Contacts on a computer first, then sync that account to the iPhone and the contacts will appear.