|

How To Import Contacts From A CSV File Into Outlook (2026)

To import contacts from a CSV file in Outlook, open People in new Outlook and select Import contacts, or use File, Open & Export, Import/Export in classic Outlook.

The CSV needs its column headings in the first row and must be saved as CSV (Comma delimited).

The steps below come from Microsoft support pages.

Quick answer: how to import a CSV

Your OutlookWhere to click
New Outlook for WindowsPeople > Import contacts > Browse > choose the CSV > Open > Import
Classic Outlook for WindowsFile > Open & Export > Import/Export > Import from another program or file > Comma Separated Values
The fileHeadings in row 1, saved as CSV (Comma delimited)

Most failed imports come from the file itself, so check the CSV before you start.

Prepare the CSV file first

  • Keep the column headings in the first row, and do not replace them.
  • Headings must match Outlook’s display language, so a Portuguese Outlook needs Portuguese headings.
  • No field is strictly required, so enter only the information you want to import.
  • Save as CSV (Comma delimited) (*.csv), never as .xls, .xlsx or .xlm, which puts all the data in the first column.

When Excel asks whether to keep the CSV format, always choose Yes, because No saves an .xlsx file that Outlook cannot import.

Start from the sample file if you have no export

  1. Download Microsoft’s sample .csv file and save it as a .csv file, not as an Excel file.
  2. Open Excel, select File > Open, choose All Files, and open the .csv.
  3. Delete the sample data in rows 2 to 6.
  4. Type your contacts under the matching headings and save as CSV (Comma delimited).

Microsoft suggests testing with a few contacts first, then deleting them, adding the rest and importing again.

Turn an Excel contact list into a CSV

  1. Open the workbook and select the worksheet with your contacts.
  2. Select File > Save As and choose a location.
  3. For Save as type, select CSV (Comma delimited) (*.csv), then Save.
  4. Dismiss the two Excel warnings, which describe CSV limits and do not affect your original file.
  5. Select Yes to save the current sheet as CSV, then close the CSV file.

Saving a CSV copy does not change your original .xlsx workbook.

Microsoft also says the Outlook.com contacts importer accepts a .csv file or an Outlook .pst file.

Import a CSV into new Outlook

  1. In the left navigation bar, select People. If it is missing, select More apps, then People, and pin it.
  2. On the ribbon, select Import contacts.
  3. Select Browse, choose your CSV file, and select Open.
  4. Select Import.

Import a CSV into classic Outlook

  1. Select File > Open & Export > Import/Export.
  2. Choose Import from another program or file, then Next. If you are asked for a password you never set, select Cancel.
  3. Select Comma Separated Values, then Next.
  4. Browse to your .csv file.
  5. Under Options, choose how to handle duplicates, then select Next.
  6. Pick the destination folder, then select Next.
  7. Tick your file name, but do not select Finish yet.

Duplicate options and destination

Duplicate optionResult
Replace existing contactsImported rows overwrite matching contacts
Create duplicate contactsImported rows are added even if a match exists
Do not import duplicatesMatching contacts are skipped

Contacts is the default destination folder, but you can choose another folder or create a new one.

Map custom fields if columns do not line up

Before you select Finish, select Map Custom Fields to see your CSV columns on the left and Outlook’s standard fields on the right.

  1. Name, First Name and Last Name map automatically when your file uses those columns.
  2. For other columns, scroll the right pane and drag the CSV column onto the matching Outlook field.
  3. Repeat for each column, then select Finish.
  4. Select the People icon in the navigation bar to see the contacts.

For example, Microsoft drags an Address column to Home Street or Business Street depending on the address type.

Everything landed in one column

Microsoft says to open the file in Notepad and look for extra quote marks.

  1. Open the file in Excel.
  2. Select Data > Text to Columns.
  3. Choose Delimited, then Commas.
  4. Save as CSV again and re-import.

Names with accents or other alphabets look garbled

Microsoft recommends UTF-8 files, and names using Greek, Cyrillic, Arabic or Japanese characters are the main source of import problems.

  1. In Excel, create a blank workbook.
  2. Select Data > From Text/CSV, pick your file and select Import.
  3. Under File Origin, choose the encoding that displays the text correctly, then select Load.
  4. Select File > Save As and choose CSV UTF-8 (Comma delimited) (*.csv).

Common errors and what to do

ProblemMicrosoft’s fix
Nothing is importedOpen the file in Excel; if data is missing, edit it, or export again if it is empty
Format of the .csv file isn’t correctCopy your contacts into the sample file, keep the headings in row 1, and save as .csv
Only one sheet came inOutlook imports one worksheet per CSV, so save each sheet separately
Semicolons between fieldsSome locales such as German use them, so replace them with commas first

Move contacts out of classic Outlook to a CSV

  1. Select File > Open & Export > Import/Export.
  2. Choose Export to a file, then Next.
  3. Select Comma Separated Values, then Next.
  4. Select the Contacts (This computer only) folder under your account, then Next.
  5. Browse to a save location, name the file, select OK, then Next.
  6. Select Finish.

No completion message appears, and the progress box simply closes when the export is done.

Close the file without saving in Excel afterwards, because Microsoft says saving it there may make it unusable for import.

Sources

Leave a Reply

Your email address will not be published. Required fields are marked *