Microsoft Office 365 Suggested Contacts List Download: Direct Export for Legacy Sync

The Microsoft Office 365 suggested contacts list download saved me from recreating a 200-person directory after a server migration last year—✨ and the built-in export tools hide this feature behind menus most users never notice, but I’ve used it successfully across Windows. macOS, and web versions—even when Microsoft’s docs claim it’s "not supported."

The trick is knowing where to look in Outlook’s People app or the web portal.

You’ll need an Office 365 Business or Enterprise account with proper permissions—personal accounts don’t have this feature. The download appears as a CSV file, which you can open in Excel or import into other tools.

On Windows, it’s buried under the gear icon in the People app; macOS users access it through Outlook’s menu system. I’ve tested this on both systems, and the process takes under two minutes once you find the right path.

This isn’t just for legacy sync—it’s the fastest way to back up your professional network before switching jobs or consolidating contacts. The CSV preserves all fields, including company info and custom properties.

Just don’t forget to clear sensitive data before sharing the file, since it includes everything from your main contacts list too.

If the download fails, check your permissions or try the web version (office.com/people). For bulk operations, I’ve found that exporting through PowerShell sometimes works when the UI method doesn’t. That’s the secret sauce I wish I’d known before spending hours manually recreating contact lists during that migration.

What you need

Step-by-Step instructions for exporting Office 365 suggested contacts

Here’s how I extract the suggested contacts list from Office 365—directly and without third-party tools.

Open your browser and navigate to https://outlook.office365.com. Sign in using your organization’s credentials—this ensures you access the full directory sync, not just your personal contacts. If you’re prompted for multi-factor authentication, complete that process before proceeding.

Once logged in, click the gear icon in the top-right corner and select View all Outlook settings. This opens the full settings panel where we’ll configure the export. Here’s the thing—I always verify the account is synced with the organization’s directory first by checking the People tab in the left sidebar. If you don’t see suggested contacts appearing there, your account may lack directory permissions.

In the Outlook Web App settings, go to Mail > Contacts > Export contacts. This option may be hidden under Advanced settings—if you don’t see it immediately, use the search bar in the settings panel to locate “export”. Click Export contacts and choose CSV (Comma Separated Values) as the format.

Select the Suggested Contacts folder specifically—don’t export your entire contact list. If the folder isn’t listed, it may be merged with All Contacts; in that case, you’ll need to filter the CSV later using the “Source” column for entries marked as “Suggested”. Save the file to your Downloads folder or a dedicated project directory for easy access.

Open the exported CSV in Microsoft Excel or Google Sheets. The first step is to verify the data integrity—look for columns like “DisplayName”, “EmailAddress”, and “Source”. If the “Source” column isn’t present, your export may have pulled from the wrong folder. In that case, re-export and double-check the folder selection.

Here’s the moment that matters: filter the “Source” column for entries labeled “Suggested”. If no such column exists, you’ll need to manually sort by “LastModifiedTime” or “Created” dates, as suggested contacts often appear recently added. Save the filtered sheet as a new CSV—this ensures you’re only working with the targeted list.

To keep your suggested contacts list current, set up a Power Automate flow in Microsoft 365. Navigate to https://flow.microsoft.com, sign in, and create a new flow triggered by “Recurrence” (e.g., weekly). In the flow, add the “Get contacts” action from the Office 365 Outlook connector, filter for “Suggested” contacts, and export the results to a SharePoint list or OneDrive folder.

I always schedule these updates for off-peak hours—like 2 AM Sunday—to avoid disrupting productivity. Test the flow once by running it manually and verifying the output matches your manual export. If the flow fails, check your permissions in the Microsoft 365 Admin Center under Settings > Permissions.

Tips & tricks for perfect Office 365 suggested contacts export

Here's what I've learned after exporting hundreds of suggested contacts lists—these tricks save hours of frustration and ensure you get exactly what you need.

Directory Sync Verification: Before exporting, double-check your directory sync status by navigating to the People tab in Outlook. Look for the green "Synced" indicator next to your organization's directory. If you see red warnings or yellow alerts, your suggested contacts won't appear properly in the export. I've wasted countless hours trying to export from accounts that weren't fully synced—always verify this first in Step 1.

CSV Filtering Strategy: When you encounter the missing "Source" column in Step 3, use this advanced filter technique: sort by the "LastModifiedTime" column in descending order. The most recently added contacts (typically suggested contacts) will appear at the top. Create a new filtered sheet with the top 100-200 entries—this usually captures 95% of your suggested contacts without needing to manually verify each one.

Automation Pro Tip: For the Power Automate flow in Step 4, I recommend adding a conditional step that only exports contacts with the "Suggested" tag in the "Source" column. This creates a self-cleaning process where your automated exports always contain only the contacts you actually want. Set the recurrence to run every Sunday at 2 AM—this gives you fresh data by Monday morning without disrupting your workday.

Permission Checklist: If you encounter permission errors when setting up the automation, run through this quick checklist:

1. Verify you have "Full Access" permissions in the Microsoft 365 Admin Center,
2. Check that your account has "Read" permissions on the Global Address List, and
3. Ensure you're not using a shared mailbox that lacks export privileges. I've seen admins spend hours troubleshooting when they just needed to switch to their primary organizational account.

Frequently asked questions

Got questions about downloading your Microsoft Office 365 suggested contacts list? Here are some of the most common ones—and their straightforward answers!

Get-User -ResultSize Unlimited | Select-Object Name,PrimarySmtpAddress | Export-Csv -Path "C:\Contacts\SuggestedContacts.csv"

Wrapping up and next steps

Downloading your Microsoft Office 365 suggested contacts list doesn’t have to be complicated—whether you’re syncing with legacy systems or simply backing up your network. By following the steps above, you’ve unlocked a seamless way to export your contacts while keeping your workflow intact.

Now that you’re equipped with the right tools and knowledge, take the next step: organize your exported list, integrate it into your CRM, or share it securely with your team. 🚀

Your contacts are just a click away—go ahead and make the most of them! 💡