Import CSV File Into Outlook Contacts: Steps & Tips

To import a CSV file into Outlook contacts, open People, choose Manage contacts > Import contacts, select the CSV file, and start the import. In classic Outlook for Windows, use File > Open & Export > Import/Export and follow the wizard to import the file into your Contacts folder.

What a CSV contact file contains

A CSV file is a plain-text table in which values are separated by commas. It can hold contact details such as names, email addresses, phone numbers, companies, and postal addresses. Outlook reads the rows and turns them into individual contact records; it does not import the spreadsheet as a workbook or preserve its formatting.

The first row should identify the columns, and each later row should represent one person. For example:

First Name,Last Name,E-mail Address,Mobile Phone
Maya,Chen,maya@example.com,555-0101
Luis,Garcia,luis@example.com,555-0102

These are illustrative addresses and numbers. Your file can have other columns, but clear headings make it easier for Outlook to connect each value to the right contact field. A column called Email is usually understandable, but a heading that matches Outlook’s field name, such as E-mail Address, can make mapping more straightforward in classic Outlook.

CSV has no single universal contact format. One program might label a field “Given Name,” another “First Name,” and Outlook may display its own field name. That is why a successful import depends not only on having a valid CSV file, but also on matching the source columns to Outlook’s contact fields.

Prepare the file before importing

Make a copy of the original data before changing it. Then check the copy for missing headings, blank rows, and values placed in the wrong columns. In Excel for Microsoft 365 on Windows, use File > Save As and choose CSV UTF-8 (Comma delimited) (*.csv) as the file type. Excel saves only the active worksheet to a CSV file, so select the sheet containing the contacts first.

CSV format does not preserve multiple worksheets, cell colors, formulas as formulas, or Excel-specific formatting. It stores the displayed values in a simple text format. If Excel warns that some workbook features may be lost, that is expected when saving as CSV; keep the original workbook if you may need its other sheets or formatting later.

Use one contact per row and a descriptive heading for each column.
Check that names, email addresses, and phone numbers have not shifted into neighboring columns.
Format phone numbers and postal codes as text if leading zeros or symbols must be preserved.
Remove columns you do not want to import, while keeping a separate untouched copy for reference.
Save using a supported CSV format. UTF-8 is a sensible choice for names with accents or characters outside basic English.

Commas inside a value can be handled by CSV quoting rules. For example, a company name such as “Smith, Jones & Co.” should be enclosed in quotation marks in the file so the comma is not mistaken for a column break. Spreadsheet programs generally add this quoting when they save a properly structured CSV, but it is worth checking a file produced by a less common system.

Import contacts in new Outlook or Outlook on the web

In the newer Outlook experience, the contact list is managed through People. The labels may vary slightly as Microsoft updates the interface, but the general route is to open People, select Manage contacts, and choose Import contacts. Outlook then asks you to locate the CSV file and begin the import.

Open Outlook and go to People. If the People icon is not visible, look for it in the app navigation or open the app launcher.
Select Manage contacts > Import contacts.
Choose the CSV file on your computer and confirm the import.
Wait for the import to finish, then review People and search for a name from the file.

Outlook on the web uses a similar People workflow: open People, select Manage contacts, and choose Import contacts. Because the contacts belong to the signed-in mailbox or account, check that you are using the account where you want the records to appear. If you have several Microsoft accounts, importing while signed in to the wrong one is an easy mistake to make.

If the import option is missing, first confirm that you are in People rather than the mail view, and check whether the account is connected and fully loaded. Features and labels can differ between personal Outlook.com accounts, work or school accounts, and different Outlook releases. Importing through Outlook on the web may be a useful alternative when the desktop interface does not show the expected command.

Import a CSV in classic Outlook for Windows

Classic Outlook has a dedicated Import and Export Wizard. This is also the version that offers the most explicit control over duplicate handling and field mapping during import.

Select File > Open & Export > Import/Export.
Choose Import from another program or file, then select Comma Separated Values.
Browse to the CSV file. Choose how Outlook should handle duplicates: replace duplicates with imported items, allow duplicates, or do not import duplicates.
Select the destination Contacts folder. If Outlook has more than one mailbox or contact folder, check the destination name carefully.
If needed, choose Map Custom Fields to connect the CSV headings to Outlook fields, then finish the wizard.

Duplicate options matter when you are updating an existing list. “Allow duplicates” can create a second record for someone already in Contacts. “Do not import duplicates” avoids adding records Outlook identifies as duplicates, while replacing duplicates can update matching records with imported values. Do not assume a match is based only on the person’s name; review the outcome, particularly when people share names or use multiple email addresses.

The mapping screen is useful when Outlook does not recognize a source heading. Drag a CSV field from the left side to the appropriate Outlook field on the right. For instance, connect a source column called “Cell” to Outlook’s mobile phone field. You can also leave fields unmapped if you do not want to import them. If the values appear in the wrong places after import, the issue may be the mapping rather than the CSV itself.

Check the results and troubleshoot common problems

After importing, search for a few contacts whose details are easy to recognize. Open each record and verify that the first and last names, email address, phone number, and any important organization or address fields landed correctly. Looking at several examples is more reliable than assuming the first visible contact represents the whole file.

Names or details appear in the wrong fields: inspect the headings and, in classic Outlook, review Map Custom Fields. A column order or mapping mismatch is a common cause.
Accented characters look wrong: save a fresh copy as CSV UTF-8 and import that version. Older or nonstandard exports may use an encoding Outlook reads differently.
All values seem to be in one column: the file may use a separator other than commas, or may not be a correctly formed CSV. Re-export it as comma-delimited CSV rather than simply renaming a file extension.
Some people are missing: check for blank rows, incomplete records, duplicate settings, and whether the records were imported into a different Contacts folder or account.
Phone numbers lose leading zeros: spreadsheet software may treat numbers as numeric values. Preserve them as text in the source data and check the saved CSV before importing.

Do not confuse imported contacts with Outlook’s suggested addresses or autocomplete list. The autocomplete list is used to suggest recipients as you type in a message; it is not the same as a saved contact record in People. If a name appears in an email suggestion but not in Contacts, importing or saving a contact may still be necessary.

Keep the import safe and manageable

Before importing a large list, consider trying a small sample file with two or three contacts. This helps confirm that Outlook recognizes the columns and that the destination is correct. If the sample works, proceed with the full file. If it does not, adjust the headings or mappings before creating many incorrect records.

Contact files can contain personal information, including phone numbers and home addresses. Store the CSV somewhere appropriate, avoid sending it through an untrusted service, and delete temporary copies when you no longer need them. If the contacts belong to an employer or organization, follow its data-handling rules and make sure you are importing them into the intended work account.

Keep the original spreadsheet or an exported backup until you have checked the Outlook results. An import can add or update many contacts at once, and cleaning up a mistaken import may take longer than restoring the source data and repeating the process carefully. For an existing contact list, exporting or otherwise backing up the contacts first is a prudent precaution.

Outlook versions and alternatives

New Outlook and Outlook on the web generally use the People and Manage contacts route, while classic Outlook for Windows uses the Import/Export Wizard. These are different interfaces, so instructions for one may not match the buttons shown in the other. If you are unsure which desktop app you have, check whether the File tab includes the classic Open & Export command; the newer interface instead centers navigation around Mail, Calendar, and People.

On a Mac, Outlook’s import controls depend on the Outlook version and account setup. Some versions provide a CSV or text-file import through File > Import; if that choice is not available, using Outlook on the web for the same mailbox and its People import option can be a practical route. Avoid assuming that Windows wizard steps or labels are identical on Mac.

For a one-time transfer, CSV is often convenient because many address books and spreadsheet programs can create it. For ongoing synchronization between services, a CSV import is not a live connection: later changes to the source spreadsheet do not automatically update Outlook. You would need to import an updated file again, taking care with duplicate handling, or use a supported synchronization method offered by the services involved.

Frequently Asked Questions

Can I import a CSV file into Outlook without Excel?
Yes. Outlook imports the CSV file itself, so Excel is not required. You can create or export a properly formatted CSV using another spreadsheet, contacts app, or data system.

Where do imported contacts go?
They go into the Contacts folder or account selected during the import. In newer Outlook interfaces, check People under the account you used. If contacts seem missing, verify the signed-in account and any available contact folders.

Will importing the file replace my existing contacts?
Not necessarily. Classic Outlook lets you choose how to handle duplicates, and newer interfaces may apply their own import behavior. Review the available options and test with a small file if preserving or updating existing records is important.

Can I import an Excel workbook instead of a CSV?
Outlook’s contact import process expects a supported contact file such as CSV, not a standard multi-sheet Excel workbook. In Excel, select the worksheet with the contacts and save a copy as CSV UTF-8 before importing.

Why did Outlook import the names but not the phone numbers?
The phone column may have an unrecognized heading, an unsupported layout, or no mapping to an Outlook phone field. In classic Outlook, use Map Custom Fields to connect it explicitly, then check a contact after import.

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.