Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Importing CSV contacts to iCloud

I have a CSV file containing all of my contacts. I want to import these into iCloud. Is there an easy way to do this??


The problem I am having is this. Based on what I read online iCloud will not allow you to import a CSV file. I tried importing the contacts into Google Contacts to get them into vCard format. Unfortunately Google screws up the fields everytime. I have tried everything. I even added a contact into google manually and exported it to make sure that I was using the proper headings for the information. It still dumps everything into the Notes Field.


Obviously I would like to do this without the help of Google. Surely there is a way. As I said before, I have an Excel File containing the information and also a CSV file if one option happens to be easier.


Thanks in advance

J

iPhone 4S, iOS 5.0.1

Posted on Nov 15, 2011 2:39 PM

Reply
10 replies

Dec 29, 2011 8:05 AM in response to WALTER-MILANO-ITALY

I tried EVERYTHING to fix this. I imported contacts into Outlook and exported and they still would not go into the cloud. I tried creating a contact in google contacts and in iCloud and then exporting and copying the same exact field names.


I followed every tip that was shown on this discussion board and the tips on other boards.


I ended up manually entering all of these contacts in by hand. It actually worked out better bc I was able to get more information for my contacts into the fields. Nice because I am in sales and wanted to add previous years sales numbers etc. Thank god this time of year I am really slow.


This is something that apple seriously needs to look at. They have always prided themselves on making the PC to Mac transition easy. I wish this would have been easier.


Sorry I couldn't help more.

Jan 20, 2012 1:12 AM in response to Needshelp!

Icloud sincs with Mac-Lion or iOS 5 Adressbook (contacts)

You write you have data in Excel and CSV file and then that you exported from Outlook (to what?).

At which point do you have a stop ?

Importing CSV into Adressbook may need to check that each field (row) of the CSV exactly match the number and kind of fields in your contacs or Adressbook, which can be. This is important and it is explained in the above discussion where in the first attempt the import was not working and the CSV file was corrected to get the result.

It is a way that needs attention to empty fields and pays if you have really many contact to transfer.

I read you got your result succesfully in other way therefore I beleive you dio not need any further info about.


Sorry, I was not able to explain you better the way in my first message.

Dec 18, 2012 9:58 PM in response to Needshelp!

Yes, there is a way to transfer contact. Use Outlook import. Below are step by steps to upload an Outlook calendar to iCloud but I am sure you can use it for Contacts.


1. Using Outlook 2010, click File, select Import

2. Select EXPORT to a file

3. Select Microsoft Excel 97-2003 or Comma Seperated Values (Windows)

4. Select the Calendar to export from (this is the source calendar)

5. Save the exported file as: Calendar.csv

6. Export "Appointments" from folder: Calendar

7. Export and create individual occurrences’ of appointments or tasks that occur between: range_date and range_date

8. The utility will export your file

9. Go back to File, Import, and NOW you will IMPORT the same file but now the DESTINATION will be iCloud

10. Select Import from another program or file

11. Select Microsoft Excel 97-2003 or Comma Separated Values (Windows)

12. Browse to the import file and select it

13. Now, you can only use "Allow duplicates to be created" because the other two selections (Replace duplicates with items imported and Do not import duplicates items) will give you an error. In fact, "do not import duplicate items does not do anything.

14. Click Next and now Select the iCloud Calendar

15. Click Next and your calendar will be uploaded to iCloud. This will create duplicates and you will need to delete your calendar constantly.


---- Just use Outlook import utility for contact and jump to bullet point 9


9. Go back to File, Import, and NOW you will IMPORT the same file but now the DESTINATION will be iCloud

10. Select Import from another program or file

11. Select Comma Separated Values (Windows)

12. Browse to the import file and select it

13. Now, you can import contacts by selecting that location on iCloud

14. Click Next

Feb 3, 2016 8:42 PM in response to Needshelp!

Create a Gmail account first. It's free.If you have one already just login to the same.


A) In Gmail select contacts from the drop. You can see contact drop down just above the compose button (By default mail would be selected)


B) Click on 'more' button and select 'Import' and upload your 'CSV' file there. This will merge your CSV contact with your Gmail contacts


C) Follow these steps on your iPhone/Ipad/ i device and follow these steps

  1. Open the Settings app on your device.
  2. Select Mail, Contacts, Calendars.
  3. Select Add Account.
  4. Select Google.
  5. Fill out your account information in the following fields:
    • Name: Enter your name
    • User Name: Enter your full Google Account or Google Apps email address.
    • Password: Your Google Account or Google Apps password. (If you’ve enabled 2 Step verification, you’ll need to generate and enter an application specific password.)
    • Description: Enter a description of the account (e.g. Personal Contacts).
  6. Select Next at the top of your screen.
  7. Make sure that the "Contacts" option is turned ON. The switch should be green. Turn off other buttons if you don't require them.
  8. Select Save at the top of your screen.


D) Your Gmail contacts are now in sync with your i device

E) In i device iCloud setting , turn on 'sync contact' option, your device will automatically sync these contacts with your iCloud.


Your CSV contacts are merged with iCloud.


[In case, you wanted to get the contacts on i device from icloud and hence you wanted to get all of them on icloud from your CSV, you don't need to bother about syncing them with icoud now as your contacts are already on your device.]

Importing CSV contacts to iCloud

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.