what program do i need to transfer my contacts from iphone 8 to excel
A CSV file, which is curt for a comma-separated values file, allows you to store vast corporeality of information in a file that can be opened with spreadsheet apps like Microsoft Excel, or Apple'south Numbers app just like other spreadsheet file types tin exist.
This is a smashing way to keep a fill-in of your Contacts information prophylactic for whenever you have a catastrophic meltdown on your estimator or iOS devices, and in this tutorial, we'll show you how you tin consign your Contacts to either an Excel or a CSV file.
Exporting your contacts
Y'all can actually do this whether y'all're on a Mac, PC, or if you're on an iOS device. This guide volition evidence y'all both methods. Admittedly, exporting your contacts to Excel is much easier on your iPhone or iPad as information technology is a straightforward process. Information technology is a bit more than cumbersome to do from your computer, but fear not, our step-by-step tutorial will walk you through the entire process.
Making an Excel file or CSV file from contacts on your iPhone or iPad
For those of you who will be tackling this from your mobile device, whether information technology's an iPhone, iPod touch, or iPad, y'all can merely apply our app called Consign Contact to brand an Excel or CSV file for Microsoft Excel or Apple Numbers instead.
To do this, follow these steps:
1) Download and install the app on your iOS device.
Note that if you but need to consign your contacts to Excel, yous tin download the Contacts to Excel app, which will exercise the job only fine. Still, if you need to export your contacts to CSV (and more file formats), then y'all will demand the Consign Contact app. Either manner, both apps are near identical.
2) Launch the app, and when you're asked to give the app admission to your contacts, let information technology.
3) Tap on the CSV or Excel file type. CSV will output a .csv file that tin be opened with Excel. The Excel file blazon will output a .xlsx file that volition besides exist uniform with Excel. For better versatility, I suggest selecting the Excel file format. Tap theContinue button, which will backup all your contacts.
4) Tap on Export and select the desired export source for the XLS file. We'll exist using Dropbox because information technology'south convenient for us. Select Salve to Dropbox. Note that y'all can as easily select email, SMS, and more than.
v) Tap on Choose a Binder to select the salve location of your Excel file. One time you lot take selected a folder, tap Cull, then Save to save the file to the specific Dropbox binder.
6) At present on your Mac or PC, y'all can open up your output source. In our case, it was Dropbox. The file should exist sitting there and waiting for you to open up:
7) Open the file to ensure that everything looks good. It tin can exist opened with either Microsoft Excel or Apple tree Numbers.
And that'southward all there is to it! All of your contacts should testify up in this XLS file and they will be organized by name.
Making a CSV file from the contacts in your iCloud account
The nigh convenient way to exercise this from a Mac or PC is from iCloud.com, which you can admission from any device you want. You will follow these steps to make it happen.
i) Caput over to iCloud.com in your preferred web browser and log in with your credentials.
2) At present click on the Contacts app from the list of provided services.
3) Next, wait for your contacts to load, and then click on the Settings cog at the bottom left of the webpage.
four) From the list, click on the Select All option to make sure you take all of your contacts selected before proceeding to the next step.
5) One time selected, click on the Settings cog one time again, and this time click on the Export vCard… option.
6) A vCard file volition at present be downloaded to your calculator's Download'due south binder.
seven) Open your favorite web browser once once more, and visit the following URL:
http://labs.brotherli.ch/vcfconvert/
8) Click on the Choose File push and select the vCard file you downloaded earlier. Then, configure the following options as such:
- Format: choose CSV, choose Comma, enable Add Header Line
- Encoding: choose Unicode (UTF-viii)
- Filter: don't change anything
- Modifications: don't change anything
Once configured, click on the Convert button.
9) A CSV file will at present be downloaded to your computer's Downloads binder:
10) Test the file past opening it in Microsoft Excel or Apple Numbers. Everything should be sorted in an organized manner.
And you're done! Your contacts will be organized by name and their information volition be displayed in this spreadsheet.
Wrapping up
Now that yous have a CSV or XLS file backed up, y'all should really consider putting it somewhere safe, such as on a backup hard drive or wink bulldoze. This will ensure that whenever you lose your iOS device, Mac, or other Apple device, you will always accept a backup and can re-add contacts if necessary.
Although iCloud works smashing for keeping your contacts in sync across all of your devices, there are times when iCloud sees downtime and may non piece of work properly, then having your own spreadsheet file is a nifty style to ensure you always take an offline listing of your contacts and their data and makes re-adding it in the future a cakewalk.
Also read:
- Transferring contacts from one iOS device to another
- Removing unwanted electronic mail addresses from the Mac's Mail app
Did you know you could consign your contacts as a CSV or XLS file? Share in the comments below!
Source: https://www.idownloadblog.com/2016/07/04/export-contacts-cvs-excel-file/
0 Response to "what program do i need to transfer my contacts from iphone 8 to excel"
Post a Comment