Hello All, we got the request to add multiple contacts in M365 address book. I hope you may also get this kind of request in future. If yes, this article helps you to achieve that request.

Of course, we have two ways to add multiple contacts.

Option 1: Using the contact template download from M365 admin portal  -> fill all the columns and upload it on multiple contact to add.

Example:

1. Log in to portal.office.com with admin credentials

1. Select Users -> Contacts ->Multiple contacts

1. Download the CSV file of Multiple contact format

1. Update the contact details in the CSV template

1. Import that csv file on M365 address book and Click Add contacts

Result can see like below:–

Note: You can upload up to 40 contacts per CSV file and follow the below instructions to avoid common errors.

• Each contact must have a unique email address and display name.​
• Email addresses may only use letters, numbers, and the following special characters: !#$%&’*+-/=?^_`|~.‎{}‎
• Email addresses cannot include accented characters.
• Email addresses can’t begin or end with a period (.).​
• The part of the email address before the @ symbol can have 64 characters or less.​
• Save as a CSV (comma delimited) file with 16 columns.​

Option 2: We have another way to add multiple contacts on M365 Using PowerShell and also you can add more than 1000 contacts at once.

Example:

1. Prepare the excel sheet with the following format and save it as CSV file.

1. Open PowerShell cmd -> Type  “Connect-ExchangeOnline” and enter the admin credentials

1. Run the following the cmd

  Import-Csv C:\Users\arun.ravi\Downloads\Import_Contact_Test1.csv |%{ New-MailContact -name $_.name -DisplayName $_.name -ExternalEmailAddress $_.email}

Result can see on the M365 admin portal

Thank You!!!