Moving a contact list into Outlook should be a five-minute job. Unfortunately, spreadsheets have a mischievous streak. One innocent-looking column can turn phone numbers into scientific notation, place last names in the company field, or introduce Outlook to 700 copies of the same customer.
The good news is that importing contacts from Excel into Outlook is straightforward once the spreadsheet is organized, saved in the correct CSV format, and matched to the right Outlook version. This guide explains the entire process for new Outlook, classic Outlook for Windows, Outlook on the web, and Outlook.com. It also covers field mapping, duplicate prevention, UTF-8 encoding, common errors, and practical lessons from real-world contact migrations.
Can Outlook Import an Excel Contact List?
Outlook does not normally import an Excel workbook in its native .xlsx format. Instead, you prepare the contact information in Excel and save the relevant worksheet as a CSV file.
CSV stands for comma-separated values. The format stores each contact as a row and each category of information as a field. For example, a basic contact file might contain columns for first name, last name, email address, company, business phone, and mobile phone.
A CSV file is less glamorous than a full Excel workbook. It cannot keep formulas, multiple worksheets, formatting, charts, or that elaborate color-coded legend someone created during a particularly enthusiastic Monday morning. Its simplicity, however, makes it useful for transferring contact data between programs.
What happens to the original Excel workbook?
Saving a worksheet as CSV does not need to replace your original workbook. Keep the original .xlsx file as a master copy and create a separate CSV version for Outlook. That gives you a safe backup if you later discover that “Accounting Phone” was actually a fax number from 2014.
Step 1: Prepare the Contact List in Excel
Most failed imports begin before Outlook is even opened. A well-structured spreadsheet eliminates many missing-field, formatting, and duplicate problems.
Use one row for each contact
Every person or business should occupy one row. Do not place two email addresses, two people, or an entire family reunion in a single cell unless the information genuinely belongs to one contact record.
Place field names in the first row
The first row should contain clear column headings. Outlook uses these headings to determine what the data represents. Useful headings include:
- First Name
- Middle Name
- Last Name
- E-mail Address
- Company
- Job Title
- Business Phone
- Mobile Phone
- Business Street
- Business City
- Business State
- Business Postal Code
- Business Country/Region
You do not need to use every possible Outlook contact field. Include only the columns that contain useful information. Empty columns are not dangerous, but carrying 47 blank fields around is the spreadsheet equivalent of packing six umbrellas for a weekend trip.
Use recognizable Outlook-style headings
Classic Outlook can map custom headings during the import process. New Outlook and Outlook on the web use a more streamlined importer, so recognizable headings generally produce cleaner results.
For example, change vague headings such as Mail, Cell, or Organization to E-mail Address, Mobile Phone, and Company. If possible, export a small sample CSV from Outlook and use its headings as your template.
Clean the data before importing
Review the worksheet for unnecessary spaces, blank rows, duplicate records, misspelled domains, and inconsistent phone numbers. Pay special attention to email addresses containing spaces or missing the portion after the @ symbol.
Phone-number columns should usually be formatted as text in Excel. Otherwise, leading zeros may disappear, international plus signs may be lost, and long numbers may be displayed in scientific notation. Outlook is an email application, not a detective agency; it will not reconstruct digits that Excel has already removed.
Replace formulas with values
If a column uses formulas to combine names or create email addresses, copy the finished cells and paste them as values before creating the CSV file. CSV files cannot preserve normal Excel formulas or workbook relationships.
Step 2: Save the Excel Worksheet as a CSV File
- Open the workbook in Excel.
- Select the worksheet containing the contact list.
- Choose File and then Save As or Save a Copy.
- Select a separate folder for the import file.
- Open the file-type menu.
- Choose CSV UTF-8 (Comma delimited) (*.csv) when available.
- Enter a descriptive filename, such as Outlook-Contacts-August-2026.csv.
- Select Save.
Excel may warn that CSV cannot preserve multiple worksheets or certain workbook features. This warning is expected. Only the active worksheet is written to the CSV file; the original Excel workbook remains available if you saved the CSV as a separate file.
Why UTF-8 matters
UTF-8 encoding helps Outlook display accented letters and non-English characters correctly. It is especially important for names and addresses containing Vietnamese, Spanish, French, Greek, Arabic, Cyrillic, Japanese, or other characters outside basic English text.
Without UTF-8, a perfectly respectable name can arrive in Outlook looking as though it lost a disagreement with a broken printer. When Excel offers CSV UTF-8, use it.
Step 3: Test the CSV File Before the Full Import
Create a temporary CSV containing five to ten representative contacts. Include examples with a company name, international phone number, accented character, postal address, and more than one email field if those situations occur in the full list.
Import the test file and inspect the results. Confirm that:
- First and last names appear in the correct fields.
- Email addresses are complete and usable.
- Phone numbers retain their leading zeros and country codes.
- Company names and job titles are not reversed.
- International characters display correctly.
- Addresses are divided into suitable fields.
A small test import may feel like an unnecessary detour, but deleting eight bad contacts is far more pleasant than cleaning up 8,000 of them.
How to Import a CSV File Into New Outlook
Use these steps in the new Outlook application for Windows:
- Open new Outlook.
- Select People from the navigation bar.
- If People is hidden, select More apps, open People, and optionally pin it to the navigation bar.
- Select the account that should receive the contacts when Outlook displays multiple accounts.
- Choose Import contacts from the ribbon. In some layouts, the command may appear under Manage contacts.
- Select Browse.
- Choose the UTF-8 CSV file and select Open.
- Review any sample contacts displayed by the importer.
- Select Import.
After the process finishes, remain in People and search for several imported names. Check records from the beginning, middle, and end of the spreadsheet rather than inspecting only the first entry.
Select the correct account
New Outlook can display contacts from multiple connected accounts. Confirm the selected account before importing. Otherwise, the list may be imported successfully but saved under a different mailbox, creating the impression that Outlook swallowed the file and refused to discuss it.
How to Import Contacts Into Outlook on the Web or Outlook.com
The web-based process works well when you use Outlook.com, a Microsoft 365 work or school account, or a computer that does not have classic Outlook installed.
- Sign in to Outlook in a web browser.
- Select the People icon.
- Choose Manage contacts.
- Select Import contacts.
- Choose Browse and select the CSV file.
- Review the displayed sample for encoding or formatting problems.
- Select Import.
Contacts imported into a cloud-based Outlook account normally synchronize to other Outlook applications signed in to that account. Synchronization may not be instant, so refresh the contact list or allow a little time before declaring the operation a failure.
How to Import Contacts Into Classic Outlook for Windows
Classic Outlook offers the most detailed import controls, including destination-folder selection, duplicate-handling options, and custom field mapping.
- Open classic Outlook.
- Select File.
- Choose Open & Export.
- Select Import/Export.
- Choose Import from another program or file and select Next.
- Select Comma Separated Values and choose Next.
- Select Browse and locate the CSV file.
- Choose how Outlook should handle duplicates.
- Select the correct Contacts destination folder.
- Use Map Custom Fields when the spreadsheet headings do not match Outlook fields.
- Select Finish.
Choose a duplicate-handling option
Classic Outlook commonly provides three choices:
- Replace duplicates with items imported: Imported information replaces matching existing records.
- Allow duplicates to be created: Outlook keeps both the existing record and the imported record.
- Do not import duplicate items: Existing contacts remain, and matching imported records are skipped.
There is no universally correct option. Use replacement when the spreadsheet is the authoritative, updated list. Skip duplicates when existing Outlook records contain valuable notes or manually maintained details. Allow duplicates only when you intend to compare and merge records lateror when you enjoy digital housekeeping far more than most people do.
How to Map Custom Fields in Classic Outlook
Field mapping tells Outlook where each spreadsheet column belongs. It is useful when your file uses headings such as Customer, Direct Line, or Territory instead of Outlook’s standard field names.
- Proceed through the Import/Export Wizard until the final import screen.
- Make sure the import action is selected.
- Choose Map Custom Fields.
- Review the source fields on the left and Outlook destination fields on the right.
- Drag each source field onto the appropriate Outlook field.
- Remove any incorrect mappings.
- Select OK, and then complete the import.
Map Given Name to First Name, for example, or Cell Number to Mobile Phone. Do not map an internal customer ID to a phone field merely because both contain numbers. Outlook will accept many questionable decisions without complaint.
Common Outlook Contact Import Problems
The CSV file is not accepted
Confirm that the filename ends in .csv, not .xlsx, .xls, or .txt. Reopen the original workbook and save a fresh CSV UTF-8 copy rather than repeatedly editing a damaged import file.
All information appears in one column
This usually indicates a delimiter or file-format problem. Some regional settings use semicolons instead of commas as list separators. Open the file in a plain-text editor and inspect the separators, or create a new CSV using a compatible comma-delimited format.
Names or addresses contain strange characters
Save the file again using UTF-8 encoding. Cancel the import if the preview already shows unreadable characters; importing first and repairing hundreds of records later is rarely the heroic choice.
Fields are missing or misplaced
Keep column headings in the first row and use Outlook-style names. In classic Outlook, use Map Custom Fields. In the streamlined web or new Outlook importer, adjust the CSV headings before uploading.
No contacts appear after import
Open the CSV in Excel and confirm that it contains actual data below the header row. Then verify that you imported it into the intended account and contact folder. Search People by a distinctive surname or company name.
Too many duplicates appear
Stop repeating the import until the cause is understood. Review the duplicate option, remove repeated rows from Excel, and test with a smaller file. Classic Outlook does not provide a magical one-click cleanup tool for every duplicate scenario, so prevention is considerably easier than repair.
A large contact list fails
Split the spreadsheet into smaller CSV files and import the batches separately. Keep the same headings in every file, label the batches clearly, and record which ones have been completed.
Imported Contacts Versus the Company Address Book
Contacts imported from CSV are generally added to the contact list associated with the selected account. They do not automatically become entries in an organization’s Global Address List.
The Global Address List is usually managed through Microsoft Exchange or Microsoft 365 administration. Adding employees or shared directory records across an organization may require an administrator, directory synchronization, or another managed process. Importing a spreadsheet into your own People list is not a shortcut for rewriting the company directoryprobably for the best.
Best Practices for a Safe, Clean Import
- Keep an untouched copy of the original Excel workbook.
- Export or back up existing Outlook contacts before a major import.
- Use CSV UTF-8 whenever it is available.
- Preserve the first-row column headings.
- Remove blank rows and obvious duplicates.
- Format phone numbers and postal codes as text.
- Test five to ten representative contacts first.
- Import into the correct account and Contacts folder.
- Review a sample immediately after importing.
- Store temporary CSV files securely and delete them when they are no longer needed.
Contact files can contain names, personal phone numbers, email addresses, job information, and physical addresses. Treat them as sensitive business data rather than harmless spreadsheet clutter.
Conclusion
To import contacts from Excel into Outlook, first organize the spreadsheet with one contact per row and clear headings in the first row. Save the active worksheet as a CSV UTF-8 file, test a small batch, and then use the People section or classic Import/Export Wizard to complete the transfer.
New Outlook and Outlook on the web provide a fast, simplified upload process. Classic Outlook offers greater control over duplicates, destination folders, and custom field mapping. Whichever version you use, the quality of the spreadsheet determines the quality of the result. Outlook can move data quickly, but it cannot determine that “Bob, maybe sales?” should be the regional vice president.
Practical Experience: Lessons From Real Outlook Contact Imports
The most important lesson from handling Outlook contact imports is that the clicking part is rarely the difficult part. The import command may take less than a minute. Preparing the data can take much longer, particularly when the spreadsheet has been edited by several people over many years.
One common situation involves a business contact list containing full names in a single column. Some rows read “Maria Lopez,” others read “Lopez, Maria,” and a few include titles such as “Dr. Samuel Reed Jr.” Automatically separating that column can create errors. A safer approach is to preserve the original full-name column, create separate first-name and last-name columns, and review unusual names manually. Human names stubbornly refuse to follow spreadsheet rules.
Phone numbers are another frequent source of trouble. In one type of migration, international numbers may appear correctly in the source worksheet but lose their plus signs or leading zeros after Excel interprets them as numeric values. Formatting the column as text before entering or pasting the numbers usually prevents this problem. A test import should include at least one international number and one extension.
Duplicate records often reveal deeper data-quality issues. Two rows may represent the same person but use different email addresses, company names, or spellings. Automated duplicate removal based only on names can delete legitimate contacts, while comparison based only on email addresses may overlook a customer who recently changed employers. For important lists, it is better to create a review column in Excel and identify likely duplicates before importing.
Another useful practice is to add a temporary category or identifying value to the import file when the chosen Outlook fields support it. A label such as “August 2026 CRM Migration” can make recently imported records easier to audit. When that is not practical, keep a dated copy of the exact CSV file and document the number of rows imported.
Large migrations are easier to manage in batches. Dividing 10,000 contacts into smaller files by region, department, customer type, or alphabetical range makes errors easier to isolate. Filenames such as Contacts-A-F.csv and Contacts-G-L.csv are far more useful than final-final-contacts-USE-THIS-2.csv, a filename that has never inspired confidence.
It is also worth checking where the imported contacts will live. Users with several Microsoft 365, Outlook.com, Gmail, or Exchange accounts may accidentally import a list into the wrong account. The operation succeeds, but the contacts do not appear where expected. Selecting the target account first and searching for a distinctive test contact immediately afterward prevents unnecessary troubleshooting.
Finally, do not treat the CSV file as a permanent contact-management system. It is a transfer format. Keep the original Excel workbook or source database as the controlled master, protect it appropriately, and document any changes made during preparation. Once the Outlook import has been verified, securely remove temporary copies from shared folders, downloads, and email attachments.
The smoothest Outlook imports follow a simple pattern: clean the source, preserve a backup, create a UTF-8 CSV, test a representative sample, import into the correct account, and verify the results. That process is not flashy, but neither is spending Friday afternoon deleting 4,000 duplicate contacts.
