Hi,
I have a number of excel spreadsheets with contacts on them I need to call, email etc, can I import them to either outlook or contacts on my Mac so I can access them to save typing them individually into the phone?
thanks
Justa799
save the excel sheet as csv
and then read this
Import contacts from other apps into Contacts on Mac - Apple Support
save the excel sheet as csv
and then read this
Import contacts from other apps into Contacts on Mac - Apple Support
It should be relatively easy to import this to Contacts, though I have not tested it thoroughly.
I assume that each row of your spreadsheet refers to a contact, and that columns match (say, for example, name is column A and email is column B, etc)
1) In Excel, save your excel file as CSV.
(File->Save As... then under File Format choose:
2) In Contacts, do File->Import... and select the csv file you just saved.
You will be asked what fields to assign to each entry.
For example, if your spreadsheet looks like this:
your import window will look like this:
Note that if you choose the header carefully it will be picked up automatically. For example, change "E-mail" to "Email" and it will be selected (instead of the default "do not import"). Of course you can have many more fields and entries.
nope, so far the easiest way I've found is to send an email from the standard Mac email then open in outlook sent folder, click on the address and add contact.
this seems a laborious way - surely there's an easier way to transfer the contacts across?
Great, got them into Mac contacts, next challenge, from Mac contacts to outlook, non of the import formats on outlook match the formats I can convert the contacts into...
I don't use Outlook, so there not much I can do to help there... but can't it use the contacts you already have in Contacts?
contacts from excel
