Setting up your contacts in Outlook 365 begins with syncing your existing account or importing a file from another service. If you are wondering how to import contacts into outlook 365, you have come to the right place. This guide will walk you through every method step by step, whether you are switching from Gmail, Apple, or a CSV file.
Importing contacts does not have to be complicated. Microsoft Outlook 365 offers several ways to bring your address book in. You can import from a CSV file, sync from another email account, or even copy from a previous Outlook version. Each method works for different situations.
Let us start with the most common scenario: you have a file with your contacts saved as a CSV (Comma Separated Values) file. This is the standard format for exporting contacts from most services like Google Contacts, iCloud, or Yahoo.
How To Import Contacts Into Outlook 365
This section covers the core steps for importing a CSV file directly into Outlook 365. Follow these instructions carefully to avoid duplicate entries or missing fields.
Step 1: Prepare Your CSV File
Before importing, make sure your CSV file is formatted correctly. Outlook expects specific column headers like “First Name”, “Last Name”, “Email Address”, and “Phone Number”.
- Open your CSV file in a text editor or Excel
- Check that the first row contains header names
- Remove any blank rows or extra columns
- Save the file as a .csv format (UTF-8 recommended)
If your file comes from Google Contacts, it usually works fine. For iCloud exports, you might need to adjust the column order. Outlook is picky about header names, so use exactly “First Name” and “Last Name” without spaces or special characters.
Step 2: Open Outlook 365 And Navigate To People
Launch Outlook 365 on your desktop or web browser. For the desktop app, click the “People” icon at the bottom left. This opens your contacts view. For the web version, click the grid icon (waffle) and select “People” from the app list.
In the People section, look for the “Manage” menu at the top. Click it and choose “Import contacts” from the dropdown. This option is available in both desktop and web versions of Outlook 365.
Step 3: Choose Your File And Import
Click the “Import” button and browse to your CSV file. Select it and click “Open”. Outlook will process the file and show a preview of the contacts it found. Check that the preview looks correct before confirming.
- Click “Import” button
- Browse to your CSV file
- Review the preview window
- Click “Finish” to complete the import
After a few seconds, your contacts should appear in the People section. You might see a message saying “Import completed successfully”. If you get an error, check the file format again. Common issues include missing headers or incorrect date formats.
Importing Contacts From Gmail
Many users switch from Gmail to Outlook 365 and need to bring their Google contacts along. The easiest way is to export from Google and then import into Outlook. Here is how to do it.
Export From Google Contacts
First, go to contacts.google.com and sign in with your Google account. Click the “Export” option in the left sidebar. Choose “All contacts” and select “Google CSV” as the format. This creates a file that Outlook can read.
- Open Google Contacts
- Click “Export” on the left
- Select “All contacts”
- Choose “Google CSV” format
- Click “Export” and save the file
Google CSV files include fields like “Name”, “Email”, “Phone”, and “Address”. These map directly to Outlook’s fields, so you should not lose any data. If you have custom labels in Google, they might not transfer perfectly.
Import Into Outlook 365
Now follow the same steps from the previous section. Open People in Outlook 365, click “Manage”, then “Import contacts”. Select your Google CSV file and complete the import. Check for duplicates after the import finishes.
Sometimes Outlook creates duplicate entries if you already have some contacts synced. To remove duplicates, go to “Manage” and choose “Clean up contacts”. This tool finds and merges duplicate records automatically.
Syncing Contacts From ICloud
Apple users often ask how to import contacts into outlook 365 from iCloud. The process is similar but requires an extra step because iCloud exports in vCard format (VCF), not CSV.
Export From ICloud
Sign in to iCloud.com with your Apple ID. Click “Contacts” to see your list. Select all contacts by pressing Ctrl+A (Windows) or Cmd+A (Mac). Then click the gear icon and choose “Export vCard”. This downloads a .vcf file.
Outlook 365 can import vCard files, but only one at a time. If you have many contacts, this is tedious. A better approach is to convert the VCF to CSV first using a free online tool. Search for “vcf to csv converter” and upload your file.
Import The CSV File
After converting to CSV, follow the standard import steps in Outlook 365. Open People, click “Manage”, then “Import contacts”. Select your converted CSV file and finish the import. Check that all fields transferred correctly, especially phone numbers and addresses.
One common issue with iCloud exports is that some contacts have multiple email addresses. Outlook might only import the first one. To fix this, edit the CSV file before importing and add separate columns for “Email 2” and “Email 3”.
Importing From A PST File
If you are upgrading from an older Outlook version, you might have a PST file containing your contacts. PST is Outlook’s native data file format. Importing from PST is straightforward.
Locate Your PST File
Find your old PST file on your computer. It is usually in the Documents folder or under AppData. If you are not sure, open the old Outlook and go to File > Account Settings > Data Files. The path to your PST file is listed there.
Import Into Outlook 365
In Outlook 365, go to File > Open & Export > Import/Export. Choose “Import from another program or file” and click Next. Select “Outlook Data File (.pst)” and browse to your PST file. Choose “Import items into the same folder” and select “Contacts”.
- Go to File > Open & Export > Import/Export
- Select “Import from another program or file”
- Choose “Outlook Data File (.pst)”
- Browse to your PST file
- Select “Import items into the same folder”
- Check “Contacts” and click Finish
This method preserves all contact details, including categories and notes. It is the most reliable way to transfer contacts between Outlook versions.
Using The Web Version Of Outlook 365
You can also import contacts using the web version of Outlook 365. This is useful if you do not have the desktop app installed. The steps are slightly different but equally simple.
Access People On The Web
Open your browser and go to outlook.office.com. Sign in with your Microsoft 365 account. Click the app launcher (waffle icon) and select “People”. This opens your web-based contacts manager.
Import From CSV Or VCF
In the People web app, click the gear icon for settings. Choose “Import contacts” from the menu. You can upload a CSV or VCF file. The web version supports both formats, but CSV is more reliable for bulk imports.
- Click gear icon in People
- Select “Import contacts”
- Upload your CSV or VCF file
- Wait for the import to complete
- Check your contacts list
The web version imports contacts into the default contact folder. You cannot choose a different folder during import. If you need to organize contacts into groups, do that after the import is complete.
Importing From LinkedIn Or Social Media
Some users want to import contacts from LinkedIn or other social platforms. Outlook 365 does not have a direct import for these, but you can use a workaround.
Export From LinkedIn
On LinkedIn, go to “Me” > “Settings & Privacy” > “Data privacy” > “Get a copy of your data”. Select “Connections” and request an export. LinkedIn will email you a CSV file with your connections’ names and email addresses.
Import The CSV
Once you have the CSV file, clean it up by removing any columns you do not need. LinkedIn exports often include job titles and company names, which Outlook can store in the “Company” field. Then import the file using the standard CSV import method.
Note that LinkedIn contacts might not have phone numbers or physical addresses. You will need to add those manually if you want complete contact records.
Troubleshooting Common Import Issues
Even with the right steps, imports can sometimes fail. Here are common problems and how to fix them.
File Format Errors
Outlook 365 only accepts CSV and VCF files for import. If your file is in XLSX or another format, convert it first. Use Excel to save as CSV (UTF-8). For VCF files, make sure they are not corrupted.
Duplicate Contacts
After import, you might see duplicate entries. Use the “Clean up contacts” tool under “Manage” to merge duplicates. This tool compares names and email addresses and suggests merges.
Missing Fields
Some fields like “Birthday” or “Notes” might not import correctly. This happens if the CSV column headers do not match Outlook’s expected names. Check Microsoft’s documentation for the exact header names required.
- Check header names in your CSV
- Use “First Name” not “Given Name”
- Use “Email Address” not “E-mail”
- Remove special characters from headers
Best Practices For Managing Contacts In Outlook 365
After you successfully import your contacts, keep them organized. Here are some tips to avoid future headaches.
Create Contact Groups
Use contact groups (formerly distribution lists) to send emails to multiple people at once. In People, click “New contact group” and add members from your imported list. This is great for team projects or family newsletters.
Sync With Your Phone
Outlook 365 can sync contacts to your iPhone or Android phone. Install the Outlook mobile app and sign in with the same account. Your imported contacts will appear on your phone automatically.
Regular Backups
Export your contacts periodically as a CSV file. Go to “Manage” > “Export contacts” and save the file. This protects you from accidental deletions or account issues.
Frequently Asked Questions
Can I Import Contacts Into Outlook 365 From A Mac?
Yes, the process is the same. Use the web version of Outlook 365 or the Mac desktop app. Export your contacts from Apple Contacts as a VCF file, then import into Outlook.
How Do I Import Contacts Into Outlook 365 Without A CSV File?
You can manually add contacts one by one, but that is time-consuming. Alternatively, sync your contacts from another email account using the “Add account” feature in Outlook settings.
Why Are My Imported Contacts Showing As Blank?
This usually happens when the CSV file has missing or incorrect headers. Check that your file includes “First Name” and “Email Address” columns. Also, make sure there are no empty rows in the file.
Can I Import Contacts Into Outlook 365 From Excel?
Yes, but you must save the Excel file as CSV first. Open your Excel file, go to File > Save As, and choose “CSV (Comma delimited)” as the format. Then import the CSV file into Outlook.
How Long Does It Take To Import Contacts Into Outlook 365?
For a few hundred contacts, the import takes seconds. For thousands of contacts, it might take a minute or two. The web version can be slower than the desktop app for large imports.
Final Thoughts On Importing Contacts
Now you know how to import contacts into outlook 365 using multiple methods. Whether you are coming from Gmail, iCloud, or an old PST file, the process is straightforward. Always backup your contacts before importing to avoid data loss.
Remember to check for duplicates after the import. Use the clean-up tool to merge any repeated entries. With your contacts in Outlook 365, you can start sending emails and scheduling meetings right away.
If you run into any issues, refer back to this guide. The most common problems are file format errors and missing headers. Fix those, and your import should go smoothly.
Outlook 365 is a powerful tool for managing your professional and personal contacts. Take advantage of features like contact groups and mobile sync to get the most out of your imported list. Happy organizing