Apple Event: May 7th at 7 am PT
I am trying to import my contacts from Numbers/Excell to Adress Book, my question is:
How to import contacts from numbers to adress book?
Mac Pro, iOS 5.0.1, How to import contacts from numbers
Hi Pstefogo,
This is a bit involved, but the steps are simple.
Begin by dragging a contact from your AddressBook to a Numbers Blank Sheet. This establishes a table with the proper format for the import that you will do later.
Select the new table and hover over one of the column labels. Click the little triangle on the right side of the label and select Unhide All Columns.
Now you must copy/paste your source Numbers or Excel data into this new numbers table. You might have to do it one column at a time, or you could rearrange your source table to exactly match the new table before copying, and thus be able to move it all at once.
Once you have transferred the contact data to the new table, Export as CSV, which is the format that AddressBook wants to see on Import.
Go into AddressBook and select File > Import and select the CSV file that you just saved and import it.
Regards,
Jerry
And what's the difference between Address, Street Address and Home Address, Home Street Address, etc?
Dophile
That's a good question. I didn't knew, so copied the field names to the field data and Imported to Contacts. Here's what I got:
I know you could figure this out, but I'll point out that in this view of a contact, the Field Descriptions in the Contact View are on the left, and the data file Header names are on the right:
This may be less confusing:
Jerry
how to import contacts from numbers to adress book
