This applet allows you to import Microsoft Excel spreadsheet data into an address book. You can preview the address book field matching prior to importing the spreadsheet data.
When importing email addresses into the address book email field, the solution will not add contact records which do not have a valid Internet formatted email address, i.e. it does not have an @ character in the email address. In addition,duplicate contact records, based on a comparison of the email address, will not be added to the address book.
You must map at least one of the following address book name fields: first name,last name or display name. If an imported contact has no data for any of the mapped name fields, it will be ignored and not added to the address book.