Batch import or export a personal address book

Updated at:

Import contacts into your personal address book in bulk from a CSV or VCF file, or export the contacts in your personal address book to a file. Both operations are available on the Address Book page of an employee mailbox account.

Import contacts into your personal address book

An import has two stages: prepare a contact file on your computer, and then upload the file from the Address Book page of your mailbox.

Prepare the import file

Prepare your contacts in a file that meets the following requirements:

  • File format — CSV and VCF files are supported.

  • Required CSV table columns — Each contact must have a name and an email address.

  • Optional CSV table columns — You can also include a mobile number and a backup email address.

For a CSV file, format the table as shown in the following figure to improve the import success rate.

CSV template with the name, email address, mobile number, and backup email address columns

Import the contacts

  1. Open the import entry point.

    1. Click the Address Book tab in your mailbox to go to the Address Book page.

    2. Click the drop-down arrow to the right of Contacts, and then click Import Contacts.

      Import Contacts in the drop-down menu to the right of Contacts on the Address Book page

  2. Configure the import.

    Import settings: Select file, Import to group, Encoding, and Duplicates

    1. Select file: Upload the CSV or VCF file that you want to import from your computer.

    2. Import to group: Select an existing personal address book group, or create a new personal address book group.

    3. Encoding: Select the encoding that matches your file. If you do not know which encoding your file uses, select Auto-select.

    4. Duplicates: If your file contains information that already exists in your personal address book, select whether to ignore it or overwrite it.

  3. Click OK to start the import.

  4. Review the import results. After the import is complete, the results appear on the page together with the reason for each failure, as shown in the following figure. Fix the failed entries and upload the file again.

    Import results with the number of imported contacts and the reason for each failed entry

Note

Import failures are usually caused by an invalid format in the import file.

Export contacts from your personal address book

Export the contacts in your personal address book from the Address Book page of your mailbox. The export settings determine which contacts are exported and the format of the exported file.

  1. Open the export entry point.

    1. Click the Address Book tab in your mailbox to go to the Address Book page.

    2. Click the management menu to the right of your personal address book, and then click Export Contacts.

      Export Contacts in the management menu to the right of the personal address book

  2. Configure the export.

    Export settings: Export group, Encoding, and Export format

    1. Export group: Select the personal address book group that you want to export. You can also export all contacts.

    2. Encoding: Select the encoding that you want to use for the exported file.

    3. Export format: Select the file format that you want to export the contacts to.