Contact Problems

Import External Contacts into the Microsoft 365 Global Address List

Emma BrownEmma Brown Nov 18, 2026 870 views

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.
Before you start

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.

Solution 1Recommended

Import mail contacts in bulk with Exchange Online PowerShell

Use a CSV file and Exchange Online PowerShell to create multiple external mail contacts.

1
Prepare the CSV file

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.

2
Install and connect

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.

3
Import the contacts

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.

4
Verify the contacts

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.

Import mail contacts in bulk with Exchange Online PowerShell
Allow time for updates: New contacts may not appear immediately in every Outlook address list. Cached Outlook clients may need to download an updated offline address book.
Free Microsoft Office alternative

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.

Organize contact names and external email addresses in a spreadsheetWork with Microsoft Excel XLSX files and CSV contact listsUse a familiar spreadsheet interface for an easier transition from Microsoft OfficeEdit files with a free, lightweight office suite
QA img-9

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.