Import From Excel to Address Book?
I have several large lists in an Excel file that I would like to import into address book easily. Can this be done? If so, please provide some direction.
iMac 2.8 GHz, Mac OS X (10.5.5)
Question marked as
Best reply
Save the files as tab delimited or CSV files and import using the address book import command
from Address Book help
If the application you’re exporting contacts from supports it, export vCards that include multiple contacts to speed up importing.
LN
from Address Book help
Home Index
Importing contacts
Address Book can import contact information that you save or export from other applications in vCard, LDIF, tab-delimited, and comma-separated (CSV) formats.
You can export addresses in LDIF format from Netscape, and vCards from Palm Desktop, Entourage, Outlook, and others. You can export text files in tab-delimited or CSV format from most databases.
To import addresses from other applications:
Export addresses from the other application in vCard, LDIF, tab-delimited, or comma-separated (CSV) format.
■
When exporting tab-delimited or CSV files, you may want to note the order of the information fields. If the file doesn’t contain labels, you can refer to your notes to manually identify the fields in a later step.
■
When exporting from Palm Desktop, use the default column layout.
■
Verify that exported .txt or CSV files don’t contain line breaks, which can cause the import to fail. >Use a text editing application such as TextEdit to find and remove the line breaks.
In Address Book, choose File > Import, and then choose the format of the exported file. Choose “Text File” for a tab-delimited or CSV file.
Select the file that contains the exported addresses and click Open.
If you are importing a text file, use the pop-up menus in the Text File Import dialog to specify how to import the data.
■
If the first record contains labels instead of contact information, select the “Ignore first card” checkbox.
■
Use the left and right arrows to see different records in the file you’re importing, to help you determine how to set the pop-up menus.
■
If you don’t want to import a field, set the pop-up menu to “Do not import.”
■
To set the pop-up menus for address fields, choose the type of address (home, work, or other) in the pop-up menu next to the first item of the address. Then use the address pop-up menus that appear to choose the corresponding data for each address field.
If the application you’re exporting contacts from supports it, export vCards that include multiple contacts to speed up importing.
To see the most recently imported contacts, click Last Import in the Group column. This list is updated each time you import contacts. Use the View menu to show or hide the Last Import item in the Group column.
You can use iSync to import contacts from your Palm device. For more information, open iSync, choose Help > iSync Help, and then search for “palm.”
LN
