Outlook Excel Import: Move Spreadsheet Data Safely

To import Excel data into Outlook, arrange the information in a worksheet with a header row, save the relevant sheet as a CSV file, then import that CSV into Outlook. For contacts, use People > Manage contacts > Import contacts in new Outlook or Outlook on the web; in classic Outlook for Windows, use File > Open & Export > Import/Export and choose the CSV import option.

What Outlook can import from Excel

Outlook does not treat an Excel workbook as a general-purpose data source that can be opened like an email attachment. The practical route is to prepare a spreadsheet for a specific Outlook destination and convert it to a supported format. For contact lists, that format is usually comma-separated values, or CSV. A CSV file contains rows and columns of plain text, so Outlook can read each row as a contact and match columns to contact fields.

This process is useful for moving a small business directory, membership list, customer contacts, or personal address book into Outlook. It does not import the workbook’s formulas, formatting, charts, multiple worksheets, or Excel features. It also does not send messages to the people in the sheet. If the goal is to send the same message to a list, mail merge is a different task; importing contacts first can make that list easier to maintain, but it is not required for every mail merge workflow.

Other Outlook information needs different preparation. Calendar appointments are commonly exchanged as iCalendar files with an .ics extension, rather than treated as ordinary contact rows. Tasks and other records may have their own field requirements and are not guaranteed to import cleanly just because they can be represented in spreadsheet columns. Decide whether the rows are contacts, appointments, or another kind of record before choosing a route.

Prepare the worksheet before exporting

A clean source sheet prevents many import problems. Use one row per person and one column per piece of information. Put descriptive column names in the first row, such as First Name, Last Name, Email Address, Company, Business Phone, and Mobile Phone. Avoid merged cells, blank rows within the list, decorative title lines above the headers, and subtotals. Those additions may look tidy in Excel but make it harder for an import tool to identify which row contains the field names.

Keep names, phone numbers, and email addresses in separate columns instead of combining them in one cell.
Remove columns you do not intend to import, and check for accidental spaces before or after values.
Format postal codes, phone numbers, and other values with leading zeroes as text when those zeroes matter.
Check that email addresses belong in the email field and that each row contains the intended person’s details.
Keep a copy of the original workbook; exporting to CSV does not preserve the workbook’s formulas or layout.

CSV is a plain-text format, so Excel saves the values rather than the workbook’s full presentation. If a cell contains a formula, the exported file generally carries the calculated value, not a reusable Excel formula. A CSV also represents a single worksheet at a time. Before saving, select the worksheet you want to export and confirm it contains the complete list. If the workbook has several tabs, export each one separately only if each is genuinely a separate set of records.

Save an Excel sheet as a CSV file

In Excel for Microsoft 365 on Windows, open the workbook, select the worksheet to export, and choose File > Save As. Choose a location, select CSV UTF-8 (Comma delimited) (*.csv) as the file type when available, and save. Excel may warn that some workbook features are not compatible with CSV. That warning is expected: CSV keeps the active sheet’s text-like data, not features such as formatting, formulas as formulas, or other worksheets. Keep the original .xlsx file so you can return to it.

CSV UTF-8 is a sensible choice when names or addresses contain characters such as é, ñ, or non-Latin scripts. If the recipient application displays those characters incorrectly, encoding may be the cause. The available CSV choices and save dialogs can differ in Excel for Mac and Excel for the web. On Mac, use Excel’s Save As or export options to create a CSV, then check the resulting file before importing. In Excel for the web, download or export the sheet using the options offered by that version; if CSV export is unavailable for the workbook or account, open a copy in desktop Excel.

Regional settings can affect the separator used in a CSV file. Although comma-delimited CSV is the usual choice for Outlook’s contact import, some computer settings produce semicolon-separated files. If Outlook puts an entire row into one field or cannot separate columns, inspect the saved file or export it with comma delimiters. Do not fix this by changing the original list blindly: first confirm which separator the file actually contains.

Import contacts in new Outlook or Outlook on the web

In new Outlook for Windows, open People, choose Manage contacts, and select Import contacts. Browse to the CSV file and follow the prompts to complete the import. Outlook on the web offers a similar contacts workflow through People > Manage contacts > Import contacts. The wording or placement can change as Microsoft updates the interface, and availability can depend on the account and product version. If the import option is missing, check that you are in the People or Contacts area and that you are using the correct Outlook account.

After the import, review the contacts in the destination account rather than assuming that a successful completion message means every column landed correctly. Open several records, including one with a full set of details and one with unusual characters or a long phone number. Confirm that the email address, names, company, and phone fields are in the right places. If you are importing into a work or school account, organizational policies may limit contact features or how data can be stored.

Import contacts in classic Outlook for Windows

Classic Outlook for Microsoft 365 on Windows has a desktop import wizard. Choose File > Open & Export > Import/Export, select Import from another program or file, and continue. Choose Comma Separated Values, browse to the CSV, and select how Outlook should handle duplicate contacts. When prompted for a destination, select the Contacts folder in the account where the new contacts belong. Check the selected destination carefully if Outlook has more than one mailbox or contact folder.

The wizard can offer a field-mapping step. Use Map Custom Fields to connect a column heading from the CSV to the matching Outlook contact field. For example, map Email Address to the email address field, rather than assuming Outlook will infer it from every possible heading. Drag or assign source fields to destination fields as needed, then confirm the mapping and finish the import. If a column is missing from the resulting contact, repeat the process with a small test CSV and verify its mapping before importing the full list.

The classic desktop wizard is not the same as new Outlook’s People import screen. If File > Open & Export or Import/Export is absent, you may be using new Outlook, Outlook on the web, or an interface where that desktop feature is not available. Switch to classic Outlook if it is installed and permitted for your account, or use the CSV contact import in People instead. Outlook for Mac also has a different interface; do not rely on Windows ribbon paths being identical there.

Choose fields and handle duplicates

Column headings are useful labels, but they are not a guarantee that every Outlook version will map every heading automatically. Common Outlook contact fields include first name, last name, company, job title, email addresses, and business or mobile phone numbers. Less common spreadsheet columns may need manual mapping, may have no matching Outlook field, or may be better stored in a notes field. If a field has no suitable destination, decide whether to omit it or preserve it in a way that remains searchable and understandable.

Classic Outlook’s duplicate choices can include replacing duplicates with imported items, allowing duplicates, or not importing duplicate items. The right choice depends on the job. Replacing can update existing records but may overwrite information already in Outlook. Allowing duplicates can create a second copy of each person. Skipping duplicates avoids some repetition but may leave existing contacts unchanged. Review the options and, for an important address book, test with a small set before applying a choice to the whole file. New Outlook’s import controls may not expose the same choices, so check the contacts afterward for repeated entries.

A practical example is a club list with columns for First Name, Last Name, Email Address, and Membership Type. The first three columns have familiar contact destinations. Membership Type may not have a dedicated standard contact field, so it might be omitted or recorded in Notes if that information needs to travel with the contact. Putting all four values into a single Notes column would make the list harder to search and could prevent Outlook from recognizing the email address as an email address.

Importing calendar data is a different job

A spreadsheet row with a date and a title is not automatically a properly formed Outlook appointment. Calendar items can include a start time, end time, time zone, recurrence, location, and other details. A CSV contact import does not create calendar events. For exchanging calendar entries, Outlook commonly uses the iCalendar .ics format. If the data currently exists only in Excel, it may need to be converted into a correctly structured calendar file by an application or service that supports the required fields.

Classic Outlook for Windows includes an import option for iCalendar or vCalendar files, and Outlook versions with calendar import features may provide a calendar-specific route. The available controls differ by version and account. Before importing a large calendar, use a test file or a small number of events and inspect the dates, times, and time zone. A date-only spreadsheet can be ambiguous: it may represent an all-day event, a midnight start, or a local date that shifts when interpreted in another time zone.

If the task is simply to show spreadsheet information alongside a calendar, consider whether a calendar import is necessary. A shared spreadsheet, a published calendar supported by the organization, or manually creating a few important events may be safer than converting a large table without checking its time and recurrence rules.

Common problems and practical checks

All values appear in one column: the file may use a different delimiter than the importer expects. Re-export as comma-delimited CSV and check the regional list separator.
Accented characters look wrong: save as CSV UTF-8 when available, then import the new file rather than the earlier export.
Phone numbers lose leading zeroes: Excel may have treated them as numbers. Preserve such values as text in the source sheet and export again.
Fields appear in the wrong place: review the CSV headers and, in classic Outlook, use Map Custom Fields to check the source-to-destination assignments.
Contacts are repeated: compare the import’s duplicate behavior with the existing Contacts folder and remove test entries before retrying.
Nothing appears after import: check which account and folder received the contacts, and search for one distinctive name or email address.

For a large or valuable contact list, import a small sample first. A sample of five to ten records can reveal encoding, mapping, and duplicate issues without filling the address book with bad data. Once the sample is correct, remove those test records if needed, import the full CSV, and check representative entries again. Keep the original workbook and the exported CSV until you have confirmed the result.

Privacy and safe handling

Contact spreadsheets can contain personal information, so treat both the workbook and CSV as sensitive files. Save them only in locations permitted by your organization, avoid emailing them to yourself or uploading them to an unapproved conversion service, and delete temporary exports when they are no longer needed. A CSV is not protected by the workbook’s formatting or sheet-level controls; anyone who can open it can read its contents as plain text.

Also confirm that the destination account is correct before importing. A personal Microsoft account, a work mailbox, and a shared mailbox may have different access and retention rules. If the list belongs to an organization, follow its data-handling requirements and ask an administrator if contact import is disabled or if the records should be stored in a company-managed directory instead.

Frequently Asked Questions

Can I import an .xlsx file directly into Outlook?
For a reliable contacts import, save the worksheet as CSV and import that file. CSV is the common route across Outlook contact-import screens, while a workbook’s formulas, formatting, and multiple sheets are not carried over as contact data.

Where is Import/Export in Outlook?
In classic Outlook for Windows, look under File > Open & Export > Import/Export. New Outlook and Outlook on the web use the People area instead; look for Manage contacts and Import contacts. If neither route appears, check which Outlook version you have open.

Will importing a spreadsheet send an email to everyone?
No. It adds records to a Contacts folder; it does not compose or send messages. To send a shared message, use an appropriate mailing or mail-merge workflow and take care with recipient privacy.

Can Excel import a list of appointments into Outlook Calendar?
A contact CSV import will not create appointments. Calendar items need a calendar-compatible import route, commonly an .ics file, with event dates and times prepared correctly. Check the available calendar features in your Outlook version and verify a small sample before importing many events.

Why did Outlook put my data in the wrong fields?
Outlook may not have matched a spreadsheet heading to the intended contact field, or the file may have an unexpected delimiter. Check the CSV structure and, in classic Outlook, review Map Custom Fields. Then test the corrected file on a few records before importing the complete list.

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.