Import From Excel to Address Book?
iMac 2.8 GHz, Mac OS X (10.5.5)
Apple Event: May 7th at 7 am PT
iMac 2.8 GHz, Mac OS X (10.5.5)
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.
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.”
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.
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.”
Import From Excel to Address Book?