How to Import Contacts in Outlook From Excel

To import contacts from Excel into Outlook, arrange each person on a separate row, save the worksheet as a CSV file, then import that file into the correct Outlook Contacts folder. In classic Outlook for Windows, use File > Open & Export > Import/Export; in new Outlook or Outlook on the web, use People > Manage contacts > Import contacts. The CSV step matters because Outlook’s contact import tools generally do not import an Excel workbook directly.

What You’ll Need

An Excel workbook containing the contacts you want to add. Keep one contact per row and put a clear header at the top of each column, such as First Name, Last Name, Email Address, and Mobile Phone.
Access to the Outlook account and Contacts folder where the contacts should appear. If you use several accounts, decide which one is the destination before importing.
A saved copy of the list as a comma-separated values file (.csv). Keep the original Excel workbook as your editable backup; CSV does not preserve formulas, formatting, or multiple worksheets.

Step-by-Step

Prepare the contact list in Excel. Put field names in row 1 and one person’s details on each following row. Use separate columns for separate pieces of information: for example, First Name, Last Name, Company, Job Title, Email Address, Business Phone, Mobile Phone, and Business Street. Avoid blank rows within the list, merged cells, subtotal rows, and extra notes above the headers. Remove columns you do not intend to import, or leave them out when you map fields later.
Check the values before saving. Look for misspelled addresses, spaces before or after email addresses, and data in the wrong column. Set phone-number and postal-code columns to Text before entering values if they can start with zero or include characters such as +. Excel may otherwise remove leading zeros or reinterpret a value. If a cell displays a formula result, make sure that result is the information you want Outlook to receive. CSV saves cell values, not workbook formulas or formatting.
Save a CSV copy. In Excel for Microsoft 365 on Windows, select File > Save As > Browse, choose a folder, and select CSV UTF-8 (Comma delimited) (*.csv) in the file-type list if it is available. Select Save and accept Excel’s warning that a CSV file supports only the active sheet and some workbook features. For the Mac version of Excel, use File > Save As and choose a CSV format in the file-format menu; the wording can vary by Excel build. If your workbook has several sheets, select and check the sheet containing the contact list before saving. Keep the .xlsx original.
Choose the Outlook version and destination. In classic Outlook for Windows, make sure the mailbox or data file that should receive the contacts is available in the folder list. In new Outlook for Windows or Outlook on the web, open the People view and confirm the intended account is selected. When a contact list is imported into the wrong account or folder, it may not show up where you expect, even though the import succeeded.
Import with classic Outlook for Windows. Select File > Open & Export > Import/Export. In the Import and Export Wizard, choose Import from another program or file, then select Next. Choose Comma Separated Values and select Next. Browse to the CSV file you saved and choose how Outlook should handle duplicates: replace duplicates, allow duplicates, or do not import duplicates. If unsure, choose not to import duplicates for a cautious first attempt, or test with a small copy of the list. Select Next.
Select the Contacts folder in the wizard. Choose the Contacts folder under the mailbox or data file where the people belong. Check the folder name and account carefully; do not select Calendar or a similarly named Contacts folder under a different account. If the wizard shows an option to include subfolders, use it only when the CSV is being imported into a folder structure that actually needs it. Select Next to continue.
Match the spreadsheet columns to Outlook fields. In the final wizard screen, select Map Custom Fields. The left side lists the column headings from your CSV, and the right side lists Outlook contact fields. Drag each heading you want to import to its matching field; for example, map Email Address to E-mail Address and Mobile Phone to Mobile Phone. Expand a field group if necessary to find a particular field. Unmapped columns are not imported. Do not map a whole name column to First Name if it contains both first and last names; split it in Excel or map it to an appropriate full-name field. Select OK, then Finish.
Import with new Outlook or Outlook on the web. Open People, select Manage contacts, and choose Import contacts. Browse to the CSV file and start the import. If Outlook asks which account or folder to use, choose the destination you checked earlier. The exact wording or placement of the command can change as Microsoft updates the interface. Follow any prompts to select or confirm the CSV file, and wait for the completion message before closing the page.
Confirm the results. Open the destination Contacts or People list and search for a few names from different parts of the spreadsheet. Open individual records to check that names, email addresses, phone numbers, and company details landed in the correct fields. Compare the number of imported contacts with the number of nonblank data rows, allowing for any duplicate records Outlook skipped. Keep the original workbook and CSV until you are satisfied with the result.

Common Mistakes

Trying to import the .xlsx file directly: The standard Outlook import process expects a supported import format such as CSV, not a multi-sheet Excel workbook. Save a CSV copy first, and remember that only the active worksheet is included in that copy.

Assuming column names guarantee correct placement: A header such as “Cell” or “Work email” may not automatically match the Outlook field you mean. In classic Outlook, inspect Map Custom Fields instead of assuming every column will be recognized. In the web and new Outlook importer, use clear, familiar headers and check the imported records.

Importing into the wrong Contacts folder: Outlook can contain separate contact lists for different mailboxes, accounts, or data files. Verify the destination before finishing, particularly if you have a personal and a work account open.

Ignoring duplicates or spreadsheet formatting: Reimporting a list can create repeated records depending on the option selected. Also, CSV does not preserve cell formatting, and Excel may alter phone numbers or codes that look numeric. Check duplicates and important values before and after importing.

Tips

Make a small test CSV with two or three contacts when you are unsure about field matching. Confirm the results, then import the full list using the same structure.
Use simple, specific headers such as First Name, Last Name, E-mail Address, Business Phone, and Company. Avoid multiple header rows or blank column headings.
Keep a clean master list in .xlsx format. If you need to correct or update the contacts later, make changes in that workbook and prepare a fresh CSV rather than editing the CSV as your only copy.
If the data contains accented letters or non-English names, choose CSV UTF-8 when Excel offers that format. Check a few names after import to make sure characters display correctly.
For a list with separate first and last names, keep them in separate columns. That makes Outlook sorting and addressing more reliable than putting a complete name into a single field.

Troubleshooting

The import command is missing: Check whether you are using classic Outlook or new Outlook. The classic Windows wizard is under File > Open & Export > Import/Export. In new Outlook and Outlook on the web, look in People > Manage contacts. In Outlook for Mac, menus and available import features vary by version; if you cannot find a CSV import option in People, sign in to Outlook on the web with the same account and use its People import command. Imported contacts should then sync with that account.

The file is rejected or the import appears to do nothing: Open the CSV in Excel and confirm that the data is on the first row beneath a header row, the file ends in .csv, and it is not empty. If you saved multiple worksheets, save again while the correct sheet is active. Close the file in Excel before browsing to it in Outlook, then retry. If the file came from another application, save a fresh CSV copy from Excel.

Contacts are missing or fields are blank: In classic Outlook, run the wizard again with a small test file and inspect Map Custom Fields. A column that was not mapped will not populate an Outlook field. In a web or new Outlook import, simplify the headers, remove unused columns, and retry with a few records to identify which column causes the problem.

Names or phone numbers look wrong: Correct the values in the Excel workbook, set sensitive columns such as phone numbers to Text, and create a new CSV. If accented characters are garbled, save as CSV UTF-8 where available. Importing again may create duplicates, so review the duplicate-handling choice and remove any unwanted test contacts before repeating the full import.

You cannot find contacts after a successful message: Search People for a distinctive email address, then check the selected account and Contacts folder. Allow time for account synchronization if you are using Outlook across devices. If the records are in a different mailbox, export or remove them only after confirming which copy is correct.

Frequently Asked Questions

Can I import an Excel file into Outlook without converting it?
Usually not through Outlook’s standard contact import tools. Save the relevant worksheet as a CSV file, then import the CSV. Keep the .xlsx workbook because CSV does not retain the workbook’s formulas, formatting, or other sheets.

Will importing contacts from Excel create duplicates?
It can. Classic Outlook offers choices for replacing duplicates, allowing duplicates, or skipping them. If you import through new Outlook or the web, check the prompt and review the list afterward. A small test import is useful when you are unsure how records will be matched.

Can I import only selected rows or columns?
Yes. In Excel, copy the contacts you want to a separate worksheet or workbook, keep the header row, and save that sheet as CSV. You can also leave out unwanted columns. In classic Outlook, Map Custom Fields lets you leave columns unmapped, but it does not select individual rows.

Where do imported Outlook contacts go?
They go to the Contacts folder or account you choose during import. New Outlook and Outlook on the web associate contacts with the selected account. Check the People view and account before assuming the import failed.

Can I import contacts into Outlook for Mac?
Available options depend on the Outlook for Mac version. Look in People for an import command; if that build does not offer CSV contact import, use Outlook on the web with the same Microsoft account and import the CSV there. The contacts should sync to the account.

Can I import a CSV made in Google Sheets?
Yes, provided it is a properly formatted CSV with one contact per row and clear column headers. Check the exported file in Excel or a text editor if necessary, then import it using the steps for your Outlook version.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.