How to Import an Excel List Into Outlook Contacts

To import an Excel list into Outlook contacts, save the sheet as a CSV (Comma delimited) file, then in classic Outlook go to File > Open & Export > Import/Export, choose Import from another program or file, pick Comma Separated Values, and select your file. Map your columns to Outlook fields before you click Finish. In new Outlook or Outlook on the web, go to People and use Import contacts instead.

They cover classic Outlook for Windows (Microsoft 365, Outlook 2024, 2021, 2019 and 2016), new Outlook for Windows, and Outlook on the web (including Outlook.com). Mac users can use the web method; see the note below.

Which Steps Should You Follow?

Outlook version Where to import Can you map columns?
Classic Outlook for Windows File > Open & Export > Import/Export Yes, with Map Custom Fields
New Outlook for Windows People > Import contacts No, so name your columns to match Outlook
Outlook on the web / Outlook.com People > Manage contacts > Import contacts No, so name your columns to match Outlook
Outlook for Mac Use Outlook on the web Not available on the Mac app

Microsoft notes that if the new Outlook steps don’t work, you may still be using classic Outlook, so try those steps instead. If your Outlook window has a File tab with Open & Export, you’re in classic Outlook. Either way, you start by saving your list as a CSV file. Once your contacts are in Outlook, Word can use them when you print envelopes in Word.

Before You Start: Tidy Up Your Excel List

  • Put each contact on its own row and each type of information (first name, last name, email, phone) in its own column.
  • Give every column a clear name in the first row. Outlook needs column headings in the first row, so don’t delete or replace that row. Columns named Name, First Name, and Last Name match standard Outlook fields automatically. If you only want a single Name column, you can combine the first and last name columns in Excel before you save the file.
  • Keep the contacts on a single worksheet. Outlook imports CSV files, and a CSV file can only hold one sheet.
  • Leave cells blank when you don’t have the information. You don’t need to fill every column.
  • If you plan to use new Outlook or Outlook on the web, rename your headings to Outlook’s names now, using the table below. Those versions don’t have a mapping step.

Column names Outlook recognizes

Microsoft’s Outlook.com import help lists the headings Outlook understands. These are the ones most contact lists need:

Your column might say Rename it to
First, Given Name First Name
Last, Surname Last Name
Email, Email Address E-mail Address
Second email E-mail 2 Address
Cell, Mobile Mobile Phone
Work Phone, Office Business Phone
Organization, Employer Company
Comments Notes

A reliable shortcut is to export one contact from Outlook to a CSV file and copy your data under its headings.

Step 1: Save Your Excel List as a CSV File

  1. Open the workbook and click the worksheet with your contacts.
  2. Click File > Save As and choose where to save it. If the workbook is stored in OneDrive or SharePoint, you’ll see Save a Copy instead; use that.
  3. In Save as type, choose CSV (Comma delimited) (*.csv) and click Save. If your list has accented letters or non-English names, choose CSV UTF-8 (Comma delimited) (*.csv) instead.
  4. Excel warns that the file type doesn’t support workbooks with multiple sheets. Click OK. This only describes a CSV limitation, and your original .xlsx workbook isn’t changed.
  5. Excel may also say some features might be lost. Click Yes to save the current sheet as a CSV file. Choosing No at this kind of prompt can leave you with a file Outlook can’t import.
  6. Close the CSV file.

You now have a .csv copy of your contact list that Outlook can read. If you work with these files often, you can also set CSV files to open in Excel by default.

The same file also works in Google; here’s how to import CSV contacts into Gmail.

Tip for some countries: semicolons vs commas

Some locales use a different list separator by default. German, for example, uses a semicolon, but Outlook doesn’t support semicolons as a field separator. If your CSV file uses semicolons, replace them with commas before you import.

To see which separator your file uses, open the CSV file in Notepad before you import it.

Test with a few contacts first

For a long list, import a small test file first. Save a copy of the CSV with three or four rows, import it, and check the results. Then delete the test contacts and import the full file.

Step 2: Import the CSV File Into Classic Outlook

  1. At the top of the Outlook ribbon, click File.
  2. Choose Open & Export > Import/Export.
  3. Choose Import from another program or file and click Next.
  4. Choose Comma Separated Values and click Next.
  5. Browse to your CSV file. Under Options, choose Replace duplicates with items imported, Allow duplicates to be created, or Do not import duplicate items. If you’re adding a list for the first time, Do not import duplicate items is the safest choice.
  6. Click Next and pick the destination folder. Contacts is selected by default, and you can pick or create another folder.
  7. Click Next and make sure the check box next to your file name is selected. Don’t click Finish yet.
Steps to import an Excel contact list into classic Outlook
Classic Outlook uses the Import/Export wizard and a mapping step.

If you’re asked for a password and you haven’t set one, click Cancel to move to the next window. After importing, you can add the new contacts to a group by editing a distribution list in Outlook.

If the account you’re importing into is an Outlook.com account, Microsoft points you to its Outlook.com import steps instead. Use the web method below, and the contacts show up in classic Outlook after it syncs.

Step 3: Map Your Columns to Outlook Fields

Mapping tells Outlook which column holds which type of information, so phone numbers and addresses land in the right fields.

  1. Click Map Custom Fields.
  2. Under From, you’ll see the column names from your CSV file. Under To, you’ll see Outlook’s contact fields. Columns that already match show under Mapped from.
  3. For columns that don’t match, drag them from the left pane onto the right field. For example, Microsoft shows dragging a column named “Cell Ph” onto Mobile Phone, which is under Other Address after you click its plus sign.
Outlook Map Custom Fields dialog matching CSV columns to Outlook contact fields
Drag each unmatched column from the left onto the right Outlook field.
  1. Repeat for the rest, such as dragging Address to Home Street or Business Street.
  2. Click OK, then click Finish.

Your contacts are imported. To see them, choose the People icon at the bottom of the navigation bar. Open two or three contacts and check that the email address and phone numbers are in the right boxes. Any column you didn’t map is left out.

The same wizard also works in the other direction for mail, so you can export Outlook emails to Excel as a CSV file.

How to Import Contacts in New Outlook or Outlook on the Web

  1. Select People in the navigation bar. In new Outlook, if People isn’t there, select More apps and then People.
  2. On the ribbon, select Import contacts. In Outlook on the web or Outlook.com, select Manage contacts > Import contacts.
  3. Select Browse, choose your CSV file, and select Open.
  4. Select Import.
Steps to import a CSV contact list into new Outlook
New Outlook and Outlook on the web import from the People view.

Outlook adds the contacts from your file to your account. Before it finishes, the tool shows some example contacts so you can check the text looks right. Because the contacts are saved to your Microsoft account, they also appear in Outlook on your other devices signed in to that account.

Why UTF-8 encoding matters

A CSV file with UTF-8 encoding works best, since it handles all languages and alphabets. If your contacts include characters like Greek, Cyrillic, Arabic, or Japanese and the preview looks garbled, select Cancel, convert the file to UTF-8, and start again.

To convert a file that’s already a CSV, open a blank workbook in Excel, select Data > From Text/CSV, choose the file, and select Import. Under File Origin, pick the encoding that makes the preview readable, select Load, and then save it with File > Save As as CSV UTF-8 (Comma delimited) (*.csv).

Using Outlook for Mac

Microsoft’s import steps for Outlook for Mac cover only Outlook archive files (.pst and .olm), not CSV files. If your Mac uses a Microsoft 365, Outlook.com or Hotmail account, sign in to Outlook on the web in a browser, import the CSV file with the steps above, and the contacts sync to Outlook on the Mac.

When the Contact Import Fails

These fixes come from Microsoft’s contact import troubleshooting article plus common file problems.

  • Contacts imported with blank fields: The columns weren’t mapped, or the information wasn’t in the file. Open the CSV in Excel to check it, then import again. In classic Outlook, use Map Custom Fields and choose Replace duplicates with items imported so the existing entries get filled in.
  • Only some contacts imported: A badly formatted row can stop the import partway. If 300 of 800 contacts came in, check row 301 of your list, fix or delete it, save, and import again.
  • “A file error has occurred in the Comma Separated Values translator”: The file has poorly formatted data. Look for stray line breaks inside cells or extra commas, save the file again as CSV, and retry.
  • “Unable to retrieve data”: The CSV file is probably empty. Open it in Excel to confirm the contacts are there.
  • Error that the file format isn’t correct (Outlook on the web): Keep the column headings in the first row, make sure the file is saved as .csv, and compare your headings with the list above.
  • Duplicates appeared: In classic Outlook, run the import again and choose Do not import duplicate items or Replace duplicates with items imported. In new Outlook and Outlook on the web, delete the extra entries from People.
  • Everything ended up in one column: Your file probably uses semicolons. Replace them with commas.
  • Strange characters in names: Save the file as CSV UTF-8 and import again.
  • No Open & Export option: You’re in new Outlook or Outlook on the web. Use the People method.

How to Undo an Import

Outlook has no undo button for an import. If you imported into a new folder in classic Outlook, delete that folder. Otherwise, open People, select the new entries (hold Ctrl to pick several), and delete them. That’s another reason to run a small test file first.

Excel to Outlook Contacts Questions

Can Outlook import an .xlsx file directly?

No. Microsoft’s steps start by saving the workbook as a .csv file, because Outlook imports CSV files and not workbooks with multiple sheets. Some older guides mention a Microsoft Excel option in the wizard, but Microsoft’s current steps use Comma Separated Values.

Where do imported contacts go?

In classic Outlook, they go to the folder you pick in the wizard, which is Contacts by default. In new Outlook and Outlook on the web, they go to your account’s contacts. Open the People view to see them.

Do I need to know which Outlook I have?

It helps, since the menus differ. If you see File > Open & Export, you’re using classic Outlook. If you’re not sure which Office version you have, here’s how to check which version of Excel you’re using.

Can I import a contact list into a distribution list directly?

No. The import adds individual contacts. Import them first, then add them to a contact group.

Can I paste rows from Excel into Outlook contacts?

Microsoft doesn’t document copy and paste for creating contacts, so use the CSV import. It’s the supported way to bring a whole list in at once.