Import External Contacts into the Microsoft 365 Global Address List
Question details
An administrator needs to import external contacts into the Microsoft 365 Global Address List.
- Product
- Microsoft 365 Exchange Online
- Device & OS
- not provided
- Scenario
- Add external people to the organization’s address list when older documentation links are unavailable.
- Observed behavior
- External contacts should appear in the Global Address List so users can find them when addressing email.
Use an account with permission to create Exchange Online mail contacts, such as an Exchange administrator or recipient administrator. Prepare the external contacts’ names and email addresses, and check for existing contacts to avoid duplicates.
Import mail contacts in bulk with Exchange Online PowerShell
Use a CSV file and Exchange Online PowerShell to create multiple external mail contacts.
Create a CSV file named contacts.csv with the column headers Name and ExternalEmailAddress. Add one contact per row, for example: Name,ExternalEmailAddress followed by Jane Doe,jane@example.com.
Open PowerShell and run Install-Module ExchangeOnlineManagement if the module is not installed. Then run Connect-ExchangeOnline and sign in with an account permitted to manage recipients.
From the folder containing the CSV file, run: Import-Csv -Path './contacts.csv' | ForEach-Object { New-MailContact -Name $_.Name -ExternalEmailAddress $_.ExternalEmailAddress }. Review any errors reported for individual entries.
In the Exchange admin center, open Recipients > Contacts and check that the new mail contacts appear. Then search for them in the Global Address List after it updates.

Add external mail contacts individually in the Exchange admin center
Use the admin center when you have only a few external contacts to add.
Prepare contact lists with WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface. Use WPS Spreadsheets to prepare contact data in a CSV file; importing contacts into the Microsoft 365 Global Address List still requires Exchange administration tools.

Frequently Asked Questions
Why can’t I see a new contact in the Global Address List?
First check Recipients > Contacts in the Exchange admin center to confirm that the mail contact was created. Allow time for the address list to update; Outlook clients using cached mode may also need an updated offline address book.
Can I add an external contact without PowerShell?
Yes. In the Exchange admin center, go to Recipients > Contacts, select Add a mail contact, and enter the person’s name and external email address.
What columns are required for the sample bulk import?
The sample PowerShell command uses a CSV with Name and ExternalEmailAddress headers. Each subsequent row should contain the corresponding contact name and external email address.
Do external contacts need Microsoft 365 user accounts?
No. An Exchange Online mail contact represents an external recipient and does not require a Microsoft 365 user account. Administrators can create one under Recipients > Contacts in the Exchange admin center.




