Address Book Import Specification
If you have a recipient list in a spreadsheet file, like Excel, you can import it into your Address Book.
Here is how:
- Your file must have these fields (in this order): FullName, AddressLine1, AddressLine2, City, State, Zipcode, and DisplayName. The Display Name field is optional.
- If no Display Name is specified, the Full Name is also used as the Display Name.
- Display Names must be unique.
- Be sure that the Zipcode column is formatted as text.
- Export the data to a CSV formatted text file without fieldnames on the first line. (Quotes around each field are optional.)
- Up to 100 recipients can be imported in each file.
Here's what a sample looks like in Excel:

Here's what the CSV output file would look like:
William Smith,10 Oak Street,,Hamden,CT,06518,Uncle Bill
Jennifer Smith,20 Maple Ave,,New Haven,CT,06510,Jenny
Paul Jones,H&F Clothiers Inc.,5 Pine Street,North Haven,CT,06606,Paul Jones
To import recipients into your Address Book, click here.
|