iPhone contacts are one of the most important iPhone files, so you should make a contacts backup regularly to avoid data loss. Then, it comes to the problem of how to back up your iPhone contacts. Generally speaking, you can back up iPhone contacts with iCloud, iTunes, or a third-party iPhone data transfer program. Here, we will talk about backing up and exporting iPhone contacts to CSV or Excel file to the computer by using MobiMover Free and iTunes.
More information on CSV: CSV is short of Comma-Separated Values. it's a contacts format that can be accessed and saved by many common applications, like Excel, PDF, Gmail and so on. Therefore, you can export iPhone contacts to a CSV file, then open and save then as an Excel file.
Feb 20, 2018 - The easiest way to export your Android contacts to an Excel or a CSV file is to use an app like Covve (free). All you need to do is download. I need to export my Outlook 2016 Address book to a.csv file. I have done this many, many times in the past but now after I run the export the resulting.csv file when opened with Excel is completely blank except to row 1 which contains the.
Export iPhone contacts to CSV or Excel file using MobiMover Free
Using EaseUS MobiMover Free to export iPhone contacts to CSV or Excel file can be split into two steps. The first way is to use MobiMover to export iPhone contacts to your computer, and then open the contacts files with Excel to do further operations. EaseUS MobiMover is a smart and free iPhone transfer software allowing for four types of iPhone data transfer: Transfer to Device, Transfer to Other Device, Transfer to Computer, and Custom Transfer. You can choose any transfer model based on practical needs. Moreover, iPhone files managing solutions are offered for better iOS content management. Here, for exporting iPhone contacts to computer and saved as CSV/Excel files, you should select Transfer to Computer.
Download and install EaseUS MobiMover on your computer, then follow the steps to export your iPhone contacts.
Step 1: Connect your iPhone to your computer (Mac or PC), run EaseUS MobiMover Free and click iDevice to Mac from the main interface.
Step 2: If you want to transfer contacts only, go to click More and keep Contacts selected. As you can see, it would be time-saving to use MobiMover to transfer all the supported files from your iPhone to the computer at once.
Step 3: Click the folder icon and set a storage path for the contacts to be imported from your iPhone to your computer.
Step 4: Click Transfer to begin exporting contacts from your iPhone to the computer. Wait for the process to finish patiently. If you want to check the transferred items, open the contacts (in HTML format on your computer) with a browser to do it.
- Notice
- The exported contacts by MobiMover are saved as a .HTML file. If you need to import them to your iPhone again with MobiMover, keep the file in that format. To save the iPhone contacts to CSV or Excel file, continue with the next step below.
Step 5: After this process is done, find the contacts files, right-click it to choose to open as an Excel file or CSV file. Furthermore, contacts management is enabled, like editing, adding, deleting, and saving.
Transferring other iPhone contents to the computer by using MobiMover is the same as exporting iPhone contacts to a PC. Check guides on transferring iPhone photos to PC with MobiMover with a simple click.
Export iPhone contacts to Excel or CSV file using iTunes
Sync iPhone contacts to Windows file with iTunes
1. Install and run the latest iTunes on your computer. The reason for the latest iTunes version is for avoiding some common iTunes errors that will cause iTunes won't connect or iTunes won't recognize problems.
2. Connect your iPhone to the computer with a supported USB cable. Next, click the iPhone device in the left panel of iTunes.
3. Choose 'Info' at the top of iTunes. And tick the option 'Sync Contacts' with and choose 'Windows Contacts'.
4. Click 'Sync' to start syncing your iPhone contacts to a Contacts folder within your Windows profile.
Export iPhone contacts to CSV/Excel file
1. Locate the synced Contacts folder in your Windows profile. Press 'Windows + R' on the keyboard to open a 'Run' window > type 'web' > click 'OK'.
2. Choose 'Export' in the top right corner, and select 'CSV' (Comma-Separated Values) and click 'Export'.
3. Click 'Browse' to set the path to export iPhone contacts as CSV file.
4. Choose the specific iPhone contacts data you want to export to the CSV file and click 'Finish'.
5. At last, you can open this iPhone contacts CSV file with Excel and save it as an XLS file.
A CSV, or Comma Separated Values, file is created by exporting contacts from your email system.
After you have created a CSV file you will be able to upload your contacts to Gmail which is used to sync with your device.
Contacts created on the handset will be saved to the handset as 'Google' contacts and will sync with your Gmail account automatically unless contact settings for Gmail are changed.
Below you will find some of the most common email applications where you currently keep your contacts. Follow the instructions below to create a CSV file from your email provider, then scroll to bottom for CSV import instructions into Gmail to sync those contacts with your handset's Phonebook.
Hotmail
- From the left hand menu, select 'Contact list'
- Select 'Export' under the Manage menu
- Click on 'Export'
- Follow the browser instructions for downloading the file
- Remember the location where you saved the CSV file
Outlook 2003/2007/2010
- From the Outlook main menu, select File => Import and Export
- Highlight 'Export to a file', then click 'Next'
- Select 'Comma Separated Values (Windows)', then click 'Next'
- Highlight the 'Contacts' folder, then click 'Next'
- Select 'Browse' and specify a location and file name for the exported contacts
- Click 'Next
- Click 'Finish' and your contacts will be exported
- Remember the location where you saved the CSV file
Yahoo
- Click on 'Options' and select 'Mail Options' in the upper left-hand corner
- Click on 'Contacts' in the left hand menu
- Select 'Import/Export' under 'Management'
- Scroll down to the 'Export' section
- Click the 'Export Now' button next to Microsoft Outlook
- Follow the browser instructions for downloading the file
- Remember the location where you saved the CSV file
Outlook Express
- From the Outlook Express main menu, select File => Export => Address Book
- Select 'Text File (Comma Separated Values)'
- Click on 'Export'
- Specify a file name and select a location on your computer to save the file
- Click 'Next'
- Select the fields you want to include for each contact
- Click 'Finish' and your contacts will be exported
- Remember the location where you saved the CSV File
Thunderbird
- Launch the Thunderbird Address Book
- Select the Address Book you wish to export in the left-hand column
- Go to Tools -> Export
- Type in a name for the address book you are going to export
- Select a location on the hard drive, such as the Desktop, that will make it easy to find the exported file
- Make sure you change the 'Save As Type' from .ldif to .csv and click Save
- Remember the location where you saved the CSV file
Copy contacts from your Windows Mobile Phone to Microsoft Outlook using Windows Mobile Tools:
In order to use the methods below you will need either Active Sync (Windows 2000, XP) or Windows Mobile Device Center (Microsoft Vista). These programs provide users of Microsoft Windows a way to transport documents, calendars, contact lists and email between their desktop computer and a mobile device. CLICK HERE to download.
In order to use the methods below you will need either Active Sync (Windows 2000, XP) or Windows Mobile Device Center (Microsoft Vista). These programs provide users of Microsoft Windows a way to transport documents, calendars, contact lists and email between their desktop computer and a mobile device. CLICK HERE to download.
- Connect your phone to the PC via the USB cable
- Once your phone is connected a window will appear. Click Next to continue
- Select Contacts and click Next
- You will be prompted with the option of Allowing Wireless Connections. Click Next after you have made your selection.
- Active Sync will save the settings, and begin to synchronize
- Once synchronization is complete your phone contacts will now be synchronized between your phone and Outlook
Regardless of the method you choose above, once your contacts are in CSV format follow the steps below:
Import Contacts into Google Gmail:
- Log into Gmail on your Computer
- Click GMAIL on the Left hand side of your screen
- Click Contacts - the contacts list now opens
- Click More
- Click Import
- Click Choose File, and then navigate to the .csv file that you created with any of the above methods
- Select the file, and then click Import
- After your contacts are imported, a dialog box appears and displays the total number of contacts imported.
- Handset will sync Gmail contacts to phone according to sync schedule set up in your Google account.
- Contacts entered on the handset as Google contacts are then sync'd back into same Gmail account when accessed by a computer.