The fastest way to import contacts into Outlook

The simplest path depends on where your contacts are now. If they're in a CSV file (a plain text format most contact programs can export), Outlook can read them directly. If they're in another email program like Gmail or Apple Mail, you'll export them as a CSV first, then import into Outlook. The process takes about five minutes once you have the file.

Outlook handles imports through its built-in import tool, which you'll find under File > Open & Export > Import/Export. This single tool works for CSV files, older Outlook backups, and contacts from other programs — you just need the file in the right format first.

Key Takeaways

  • CSV files are the universal format that Outlook accepts, and most contact programs (Gmail, Apple Contacts, Yahoo Mail) can export to CSV in under a minute.
  • Outlook's import tool is under File > Open & Export > Import/Export, and it walks you through matching your contact fields to Outlook's fields.
  • You can import into your main Contacts folder or create a new folder first if you want to keep imported contacts separate while you review them.
  • Duplicate contacts sometimes appear after import — Outlook has a built-in duplicate finder under File > Options > Contacts that can merge them automatically.

Exporting contacts from Gmail or other email programs

Before you can import into Outlook, you need to export your contacts from wherever they currently live. Gmail stores contacts in Google Contacts (contacts.google.com), not in Gmail itself, so log in there first. Click the menu icon (three horizontal lines) in the top left, then select Export. Choose CSV format and read the file to your computer — it will be named something like "contacts.csv".

If your contacts are in Apple Mail or iCloud, open Contacts on your Mac, select all contacts (Command+A), then go to File > Export > Export vCard. This creates a file with a .vcf extension. Outlook can import .vcf files directly, so you don't need to convert it to CSV first.

For Yahoo Mail, Outlook, or other web-based email, log in to the account, find the Contacts or Address Book section, and look for an Export or read option. The exact location varies by service, but the export will be a CSV file you can save to your computer.

Importing a CSV file into Outlook on Windows

Open Outlook and go to File in the top left. Click Open & Export, then select Import/Export. A wizard window will open with a list of options. Select "Import from a file" and click Next. Choose "Comma Separated Values (.CSV)" from the list and click Next again.

The wizard will ask you to browse for the file. Click Browse, navigate to wherever you saved your CSV file (usually your Downloads folder), select it, and click Open. You'll see options for how to handle duplicates — "Replace duplicates with items imported" will overwrite any contact that already exists in Outlook with the same name, while "Allow duplicates to be created" will add the imported contact even if one with that name already exists. Choose whichever matches what you want, then click Next.

On the next screen, you'll choose which Outlook folder to import into. If you want them in your main Contacts folder, leave it selected. If you want to create a separate folder to review them first, click New Folder, name it something like "Imported Contacts", and select that instead. Click Next, and Outlook will begin the import. This usually takes less than a minute.

Importing a CSV file into Outlook on Mac

The Mac version of Outlook doesn't have a built-in import wizard, so you'll use a different method. Open your CSV file with a text editor or spreadsheet program first — right-click the file, select Open With, and choose Excel or Numbers. This lets you see what the data looks like and make sure it imported correctly from your original source.

Close that file without saving changes. Now open Outlook on Mac and go to File > Import. Select "Contacts from a text file" and click the arrow to continue. Browse to your CSV file, select it, and click Import. Outlook will show you a preview of the contacts and ask you to map the columns — for example, telling Outlook which column contains first names and which contains email addresses. Match each column to the correct field, then click Import.

Handling duplicate contacts after import

It's common to end up with duplicate contacts after importing, especially if some contacts were already in Outlook. The good news is that Outlook has a built-in tool to find and merge them. On Windows, go to File > Options > Contacts. Scroll down and click "Duplicate Contacts" under the Contacts section. Outlook will scan for duplicates and show you a list. For each pair, you can choose to merge them (which combines the information into one contact) or keep them separate.

On Mac, there's no automatic duplicate finder, so you'll need to review the imported contacts manually. Open your Contacts folder and sort by name — duplicates will appear next to each other. Click one contact, hold Command, and click the duplicate, then right-click and select Merge Contacts. Outlook will combine the information from both into a single entry.

Importing contacts from an older Outlook backup

If you're moving to a new computer or recovering contacts from an old backup, you may have an Outlook Data File (.pst file) instead of a CSV. Open Outlook on your new computer, go to File > Open & Export > Open Outlook Data File. Browse to the .pst file, select it, and click Open. Outlook will add that data file to your folder list on the left side. You can then drag contacts from the old data file into your current Contacts folder, or use Import/Export to move them all at once.

If you have a very old Outlook backup (.olm file from Mac or an older .pst format), you may need to open it in the original version of Outlook first, export it as CSV, and then import the CSV into your current version. This is rare, but if you run into an error saying the file format isn't recognized, that's usually the reason.

Troubleshooting common import problems

If the import fails or shows an error, the most common cause is that the CSV file is corrupted or in the wrong format. Open the CSV file in a text editor (Notepad on Windows, TextEdit on Mac) and check that each line has the same number of commas. If one line has extra commas or is missing them, that line may be malformed. You can edit it directly in the text editor, save it, and try importing again.

Another common issue is that contact fields don't match what Outlook expects. During the import wizard, you'll see a preview of the data and a chance to map columns. If a column is labeled "Phone" but Outlook is treating it as "Email", you can change it in the mapping step. If the preview looks wrong, cancel the import, open the CSV in Excel or Numbers, and check that the headers in the first row are correct.

If Outlook imports the contacts but they're missing phone numbers, email addresses, or other information, the original CSV file may not have included those fields. Go back to the source (Gmail, Apple Contacts, etc.) and export again, making sure you're exporting all contact information, not just names.

Frequently Asked Questions

Can I import contacts directly from Gmail without exporting to CSV first?

Not directly into Outlook — you have to export from Google Contacts as a CSV file first. However, if you use Outlook on the web (outlook.com), you can connect your Gmail account and sync contacts automatically. For the desktop version of Outlook, CSV export is the standard path.

What happens to my existing contacts when I import new ones?

Your existing contacts stay in place. During the import, you choose whether to replace duplicates or allow them. If you choose "Allow duplicates", you'll end up with two contacts with the same name. If you choose "Replace duplicates", the imported contact will overwrite the existing one, so make sure the imported version has more complete information.

Can I import contacts into a specific folder instead of my main Contacts folder?

Yes. During the import wizard, before you click Import, you can select a different folder or create a new one. This is useful if you want to review imported contacts separately before moving them to your main folder.

Why are some of my contacts missing after import?

The most common reason is that the CSV file didn't include all your contacts. Check the original source (Gmail, Apple Contacts, etc.) and make sure you exported all contacts, not just a filtered list. Some programs let you select which contacts to export — if you accidentally selected only a few, re-export everything and try again.

Do I need to delete the CSV file after importing?

No, but you can if you want. The CSV file is just the source — once Outlook imports it, the contacts are stored in Outlook's database. Keeping the CSV file is useful if you need to import the same contacts into another program later.