Import CSV to Outlook: Contacts, Steps, and Troubleshooting

Yes. To import a CSV contact list into Outlook, open People or Contacts and choose Manage contacts > Import contacts in new Outlook or Outlook on the web. In classic Outlook for Windows, use File > Open & Export > Import/Export, then select Import from another program or file and choose Comma Separated Values.

What importing a CSV into Outlook does

A CSV file is a plain-text table in which each row usually represents one contact and columns hold details such as first name, last name, email address, phone number, and company. Outlook reads those columns and adds the records to a Contacts folder. The file itself is not an Outlook mailbox or a complete account backup.

In this context, importing a CSV means importing contacts. It is not the normal way to add email messages, calendar events, or tasks. If your goal is to move messages or a full mailbox, the suitable method depends on the source and destination; Outlook’s data-file or account-migration options are different from contact CSV import.

Outlook versions do not all use the same layout. The two common Windows experiences are classic Outlook and new Outlook, and Outlook on the web has a similar contact-import option. Before following steps, check which application you have: classic Outlook has a full File menu and the Import/Export wizard, while new Outlook has a streamlined interface and does not use that classic wizard.

Prepare the CSV before importing

Start with a small, well-formed file. If the contacts are in Excel, keep one contact per row and put a clear heading at the top of every column. Useful headings include First Name, Last Name, E-mail Address, Business Phone, Mobile Phone, Company, and Notes. Outlook may recognize common headings automatically, but clear labels make it easier to check or map fields.

Remove blank rows, test records, and columns you do not want Outlook to store.
Keep each kind of information in its own column. For example, put first and last names in separate columns if you want to sort or address them separately.
Check email addresses and phone numbers for extra spaces or unintended line breaks.
Save a copy of the source workbook before exporting. In Excel for Microsoft 365 on Windows, choose File > Save As, select a location, and choose CSV UTF-8 (Comma delimited) (*.csv) as the file type when available.

CSV stores a single worksheet’s data, not Excel formatting, formulas, or multiple tabs. When Excel warns that some workbook features may be lost, that is expected: the CSV is a text-based export of the active sheet’s values. Choose the worksheet containing the contacts before saving. If the file has international names or symbols, UTF-8 is a sensible choice because it is designed to preserve a broad range of characters; if a particular Outlook build rejects the file, try exporting a fresh CSV in a supported format.

Import in new Outlook or Outlook on the web

In new Outlook for Windows and Outlook on the web, the contact-import route is through People. The exact placement of controls can change as Microsoft updates the interface, but the current flow is generally:

Open Outlook and select People from the navigation area. In Outlook on the web, you may need to open the app launcher or navigation menu to find People.
Choose Manage contacts, then select Import contacts.
Choose the CSV file from your computer and confirm the import. If Outlook asks which account or destination to use, select the account whose Contacts list should receive the entries.
Wait for the import to finish, then search People for a name or email address from the file.

This route adds records to the selected account’s contacts; it does not attach the CSV to an email or create a separate address book file. If you cannot see the import command, confirm that you are in People rather than Mail and that you are signed in to the intended account. Work or school accounts can also have organization policies that affect available features.

Import in classic Outlook for Windows

In classic Outlook for Microsoft 365 on Windows, the Import/Export wizard provides more explicit destination and duplicate options. Open File > Open & Export > Import/Export. In the wizard, select Import from another program or file, choose Comma Separated Values, and browse to the CSV. Select how to handle duplicate contacts if the wizard offers the choices: replace duplicates, allow duplicates, or do not import duplicates. The wording can vary slightly by build.

Next, select the destination Contacts folder. If Outlook has more than one account or data store, take a moment to confirm that the folder belongs to the mailbox you intend to update. Continue through the wizard and, if needed, choose Map Custom Fields to match the CSV columns with Outlook contact fields. Finish the wizard, then check the destination folder.

The mapping step matters when the headings in your file are unfamiliar or when a value lands in the wrong place. For instance, map the CSV’s Email Address column to Outlook’s E-mail Address field, rather than relying on a similarly named field. You can review or adjust the mapping before completing the import. A small test CSV with two or three contacts is useful if the full file contains many columns or unusual data.

Import on a Mac

Outlook for Mac has changed its contact tools across releases, so check the interface you are actually using. In some classic Outlook for Mac versions, choose File > Import and select the option for contacts or messages from a text file, then follow the prompts to select the CSV. In newer Outlook for Mac interfaces, look in People > Manage contacts for Import contacts, similar to new Outlook and the web version. If a command is absent, update Outlook if appropriate or use Outlook on the web with the same account.

After import, verify that the contacts appear under the intended account, not only in a local or different account’s contact list. Menu names and availability can differ by Outlook release and account type. If you are using Excel for Mac to create the file, export the contact sheet as CSV and then inspect the saved file’s name and location before selecting it in Outlook.

Check field mapping and the destination

A successful import message does not guarantee that every detail went into the field you expected. Open several imported contacts and check names, email addresses, phone numbers, company names, and any custom information. Also check the total list for a few recognizable entries. A display name may look correct even when first name and last name were combined or placed in the wrong fields.

Contacts belong to a particular account or data store. A contact imported into a personal Outlook.com account will not automatically appear in a separate work or school mailbox. Conversely, contacts saved in a local data file may not sync to your phone or other devices. To check the destination, open the relevant People or Contacts list and confirm the account or folder before importing; after import, verify from another signed-in device if cross-device syncing is important.

Common CSV import problems

The file is missing from the picker: Confirm that you saved an actual .csv file, know its folder, and are not trying to select the original .xlsx workbook.
Names or symbols look garbled: Re-export from the source as UTF-8 CSV if available. Check the CSV in a text editor or spreadsheet before importing, especially when it contains accented letters or non-Latin scripts.
Data appears in the wrong fields: Review the column headings and use Map Custom Fields in classic Outlook. In interfaces without a mapping screen, simplify headings to common contact labels and test with a few rows.
Some contacts are missing: Look for blank rows, malformed records, or an unintended active worksheet when the CSV was created. Search for a missing contact by email address as well as by display name.
Contacts appear twice: Check the duplicate-handling setting in the classic wizard before repeating the import. Other versions may not offer the same choices, so inspect the destination first and avoid rerunning a full import without checking what was added.

Commas inside a field, such as a company name or address, are normally represented in a properly created CSV using CSV quoting rules. Avoid editing the file by replacing separators manually; that can split one value into extra columns and shift every field to the right. If a file was assembled by hand or exported from an unfamiliar system, open it in Excel and confirm that its columns line up before importing.

CSV versus other ways to move contacts

CSV is useful when you want a portable table, need to inspect or edit contact details in a spreadsheet, or are moving a list from another service. It is also easy to make a limited export containing only the columns you need. Its main limitation is that it does not preserve every Outlook-specific feature or the full structure of a mailbox; it is best treated as a data-transfer format for contact fields.

If both systems support vCard files, vCard may be convenient for a small number of individual contacts, but CSV is often easier for a large list. For moving email, calendar items, or a broader Outlook profile, use a migration or export method designed for those items rather than expecting a contact CSV to carry them. Importing through the web version can also be a practical alternative when the desktop menu differs, provided you sign in to the same destination account.

Privacy and safe handling

A contact CSV can contain personal information such as names, direct phone numbers, and email addresses. Save it somewhere you control, avoid putting it in a publicly shared folder, and remove temporary copies when they are no longer needed, subject to any workplace retention rules. Before importing a list supplied by another person or service, confirm that it is intended for your account and that you are comfortable adding those records.

There is no separate Outlook charge just for using a contact CSV import command, but access to Outlook itself and the account may depend on your Microsoft plan, organization, or device. If the command is unavailable in a managed work account, ask the administrator rather than trying to bypass policy. Keep the source file until you have checked the result, but treat it as sensitive data while it is stored.

Frequently Asked Questions

Can I import a CSV file into Outlook on the web?
Yes. Open People, choose Manage contacts > Import contacts, select the CSV, and confirm. Check that you are signed in to the account where you want the contacts saved.

Can Outlook import a CSV of email messages?
Not through the contacts import process. That feature is for contact records. Use a migration or message-import method appropriate to the source format if you need to move email.

Can I import a CSV without creating duplicate contacts?
Classic Outlook for Windows offers duplicate choices in its Import/Export wizard. Other Outlook versions may not provide the same control, so check the destination first and test with a small file before importing a full list.

Why are my CSV columns going into the wrong Outlook fields?
Outlook may not recognize nonstandard headings or may interpret a column differently than you expect. Use Map Custom Fields in classic Outlook, or rename headings to common contact labels and test the revised file.

Will imported contacts sync to my phone?
Usually, if you imported them into the contacts for the same Microsoft account that is configured on your phone and contact syncing is enabled. Contacts in a local data file or a different account may not sync.

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.