Bringing your address book into Outlook starts with locating the file format your old contacts are stored in. If you’re wondering how to import contacts into outlook, the process is simpler than you might think. Outlook supports several file types like CSV, PST, and VCF, so you can move contacts from Gmail, Yahoo, iCloud, or even an old computer. This guide walks you through every method, step by step, so you can get your contacts into Outlook without any hassle.
Whether you’re switching email providers or just setting up a new account, importing contacts saves you from typing each name and email manually. The key is knowing which file format you have and which Outlook version you use. Let’s start with the most common scenario: importing from a CSV file.
Preparing Your Contact File For Import
Before you begin the import process, you need to make sure your contact file is ready. Outlook prefers CSV files with specific column headers. If your file comes from Gmail or another service, it might already be in the right format.
Check Your File Format
Outlook can import these file types:
- CSV (Comma Separated Values) – Most common for contacts
- PST (Outlook Data File) – For transferring between Outlook accounts
- VCF (vCard) – Standard for individual contacts
- Excel files (.xlsx) – Not directly supported, but you can save as CSV
If your contacts are in a different format, convert them first. Many online tools can change VCF to CSV or Excel to CSV. Just make sure the file is saved with UTF-8 encoding to avoid character issues.
Clean Up Your Contact Data
Take a few minutes to remove duplicates or fix errors. Outlook will import everything as-is, so messy data means messy contacts later. Delete any blank rows or columns in your CSV file. Also, check that email addresses are formatted correctly (like name@example.com).
How To Import Contacts Into Outlook
This section covers the main method for importing a CSV file into Outlook. The steps are similar for Outlook 2016, 2019, 2021, and Microsoft 365. Follow along carefully.
Step 1: Open The Import Wizard
Launch Outlook on your computer. Click on “File” in the top-left corner. Then select “Open & Export” from the menu. Finally, click on “Import/Export” to launch the Import and Export Wizard.
Step 2: Choose Import From CSV
In the wizard, you’ll see several options. Select “Import from another program or file” and click “Next.” Then choose “Comma Separated Values” from the list. Click “Next” again to proceed.
Step 3: Browse For Your File
Click the “Browse” button and locate your CSV file on your computer. Select it and click “OK.” You’ll see options for handling duplicates. Choose “Replace duplicates with items imported” if you want to overwrite existing contacts. Or select “Allow duplicates to be created” if you prefer to keep both. Click “Next.”
Step 4: Select The Destination Folder
You need to tell Outlook where to put the imported contacts. Under “Select destination folder,” expand “Contacts” and choose the correct folder. Usually, it’s your default “Contacts” folder. If you have multiple accounts, pick the one you want. Click “Next.”
Step 5: Map The Fields Correctly
This is the most important step. Click the “Map Custom Fields” button. You’ll see two columns: “From” (your CSV file) and “To” (Outlook fields). Drag and drop each field to match. For example, drag “First Name” to “First Name,” “Email Address” to “E-mail Address,” and so on. If a field doesn’t match, Outlook will skip it. Click “OK” when done.
Step 6: Finish The Import
Click “Finish” to start the import. Outlook will process the file and add the contacts to your selected folder. Depending on file size, this might take a few seconds. Once done, check your Contacts folder to confirm everything imported correctly.
Importing Contacts From Gmail Or Other Services
If your contacts are in Gmail, Yahoo, or iCloud, you need to export them first. Then use the CSV import method above. Here’s how to get your contacts out of each service.
Export From Gmail
Go to contacts.google.com. Click “Export” on the left sidebar. Choose “All contacts” and select “Outlook CSV” format. Click “Export” to download the file. This CSV is ready for Outlook import.
Export From Yahoo Mail
Open Yahoo Mail and click the gear icon. Select “Settings” then “Contacts.” Click “Export” and choose “CSV” format. Save the file to your computer. Yahoo’s CSV might need field mapping adjustments.
Export From ICloud
Go to icloud.com and sign in. Click “Contacts.” Select all contacts (Ctrl+A or Cmd+A). Click the gear icon and choose “Export vCard.” This gives you a VCF file. Outlook can import VCF files directly.
Importing VCF (VCard) Files Into Outlook
VCF files are common for individual contacts. You can import them one by one or in bulk. Here’s the easiest way.
Import Single VCF File
Drag the VCF file directly into your Outlook Contacts folder. Or, open Outlook Contacts, click “Home” then “New Contact” and choose “Import vCard.” Browse for the file and click “Open.” The contact appears immediately.
Import Multiple VCF Files
Select all VCF files in a folder. Drag them into the Outlook Contacts folder at once. Outlook will create separate contacts for each file. This works well for small batches. For hundreds of files, consider converting them to CSV first.
Importing Contacts From Another Outlook Account (PST File)
If you have a PST file from an old Outlook installation, you can import contacts directly. This method preserves all contact details, including categories and notes.
Step 1: Open The Import Wizard
Follow the same steps as before: File > Open & Export > Import/Export.
Step 2: Choose Import From PST
Select “Import from another program or file” and click “Next.” Then choose “Outlook Data File (.pst)” from the list. Click “Next.”
Step 3: Browse For The PST File
Click “Browse” and locate your PST file. Choose how to handle duplicates. You can also set a password if the file is protected. Click “Next.”
Step 4: Select The Contacts Folder
Expand the PST file tree and find the “Contacts” folder. Check the box “Include subfolders” if needed. Then select “Import items into the same folder in” and choose your current Outlook Contacts folder. Click “Finish.”
Importing Contacts From Excel Or Other Sources
Sometimes your contacts are in an Excel spreadsheet. Outlook doesn’t import Excel files directly, but you can convert them easily.
Convert Excel To CSV
Open your Excel file. Click “File” > “Save As.” Choose “CSV (Comma delimited) (*.csv)” as the file type. Save it to your computer. Now you can import this CSV into Outlook using the steps above.
Import From Apple Contacts
On a Mac, open the Contacts app. Select all contacts and choose “Export” > “Export vCard.” Save the VCF file. Transfer it to your Windows computer and import into Outlook. Or use iCloud to sync contacts between devices.
Troubleshooting Common Import Issues
Even with careful steps, things can go wrong. Here are fixes for common problems.
Fields Not Mapping Correctly
If your CSV fields don’t match Outlook’s, use the “Map Custom Fields” button. Drag each field manually. If a field is missing, add it to your CSV file first. Common missing fields include “Middle Name” or “Business Phone.”
Duplicates After Import
Outlook might create duplicates if you import multiple times. Use the “Remove Duplicates” feature in Outlook Contacts. Go to “Home” > “Find” > “Clean Up” > “Remove Duplicates.” Select the folder and let Outlook find duplicates.
Characters Appearing Wrong
If names or emails show strange symbols, your CSV might have encoding issues. Save the file with UTF-8 encoding. In Excel, go to “Save As” and choose “CSV UTF-8 (Comma delimited) (*.csv).” Re-import the file.
Import Wizard Not Showing
If the Import/Export option is missing, your Outlook profile might be corrupted. Try repairing Office or creating a new Outlook profile. Also, check that you’re using a supported version of Outlook.
Tips For A Smooth Import Process
These extra tips will save you time and frustration.
- Always backup your current contacts before importing. Export them as a PST file just in case.
- Test the import with a small file first. Import 10 contacts to check field mapping.
- Use consistent naming conventions. For example, use “First Name” and “Last Name” instead of “Given Name.”
- Remove special characters from your CSV file. Characters like commas inside names can break the import.
- Close other programs during import to avoid conflicts.
Frequently Asked Questions
Can I Import Contacts Into Outlook Without A CSV File?
Yes, you can import VCF files for individual contacts or PST files from another Outlook account. You can also manually type contacts, but that’s time-consuming for large lists.
Why Are My Imported Contacts Showing In The Wrong Folder?
You probably selected the wrong destination folder during import. Delete the imported contacts and re-import, choosing the correct Contacts folder. Check your Outlook profile for multiple contact folders.
How Do I Import Contacts Into Outlook 365?
The steps are the same as for desktop Outlook. Use the Import/Export wizard from the File menu. Outlook 365 also supports importing from Google or iCloud directly through the “Add Account” feature.
What If My CSV File Has Extra Columns Outlook Doesn’t Recognize?
Outlook will ignore unrecognized columns during import. Use the “Map Custom Fields” option to see which fields are matched. Unmatched fields won’t appear in your contacts.
Can I Import Contacts Into Outlook On A Mac?
Yes, but the process is different. On Outlook for Mac, go to “File” > “Import” and choose “Contacts from a CSV file” or “vCard.” Follow the on-screen prompts. The Mac version has fewer options than Windows.
Final Thoughts On Importing Contacts
Importing contacts into Outlook is a straightforward task once you know the right steps. The key is preparing your file correctly and mapping fields accurately. Whether you’re using CSV, VCF, or PST files, Outlook gives you multiple ways to bring your address book in. Start with the CSV method for most situations, and use VCF for individual contacts or PST for full account transfers. With a little practice, you’ll be able to import contacts in minutes, saving hours of manual data entry.
Remember to always check your imported contacts for errors. Look for missing names, wrong email addresses, or duplicate entries. A quick review ensures your Outlook address book is accurate and ready to use. Now you know how to import contacts into Outlook, so go ahead and move your contacts over with confidence.