Import bulk contacts from Excel with "company" line filled

Hello,

I want to be able to mass-import a list of contacts from an excel file. I understand that I will need to convert my sheet first into a .csv fil and then a vCard file. I am struggling to get my information put into the correct places.


I want to import: first and last names, company names, mobile numbers, and email addresses.


How should I format my file so that all elements are included and imported into the correct places for the contact file?


Thank you!

iPhone 13

Posted on Feb 13, 2023 2:03 PM

Reply
1 reply

Feb 13, 2023 11:55 PM in response to bethanydixon

When you look deeply you will find that Contacts are neither stored on an iPhone nor on SIM. They are synced to an email account that you may have added and enabled Contacts. It could be Google, iCloud, AOL, Exchange, Outlook, Yahoo or any Other email client server.


When you enable Contacts in any of the email accounts they are displayed to you through the Contacts App. When you edit these contacts on an iPhone they are ultimately edited on the client-server.


Please see the pic below for a better understanding...



If you are unable to find your contacts which were stored in the email client, then try this --> Restore contacts, calendars, bookmarks, and more using ...


Check if the email account has been removed from the iOS mail app.

Add the email account that stores your contacts in the IOS mail app and enable Contacts.



What is your default Contacts account? If none, please add an email account and enable contacts.


See the pic below


Unlike some Android devices, contacts are neither stored locally on an iPhone nor in SIM. They are synced to an email account that you had Google, iCloud, AOL, Exchange, Outlook, Yahoo or any Other



If you have a corporate email account added through a profile on your device, please check with your organization's system administrator.



This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Import bulk contacts from Excel with "company" line filled

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