How to Export Outlook Email Information to Excel

To put Outlook email information into Excel, use classic Outlook for Windows: export a mail folder as CSV when the wizard offers it, or copy a message-list view into a blank worksheet. A CSV is a text table that Excel can import; it is not a complete email backup.

The steps below cover classic Outlook for Microsoft 365, Outlook 2024, and Outlook 2021. Do not apply their File-menu route to new Outlook, Outlook on the web, or Outlook for Mac. Start with a small sample and check the fields you actually need before processing your whole mailbox.

Choose the Right Result First

• Subjects, senders, and other available fields: try CSV export from one folder.
• A custom list of visible columns: copy a classic Outlook list view into Excel, one folder at a time.
• Messages with their attachments for backup: use Outlook’s PST export instructions. Excel cannot restore a mailbox from a spreadsheet.

Neither spreadsheet method deletes the source messages or frees mailbox storage. To move old mail out of the mailbox instead, see how to archive old emails in Outlook. Keep them until you have separately verified any backup. Exported files can contain private correspondence; save them somewhere appropriate for that information.

Export a Mail Folder as CSV in Classic Outlook

1. Open File > Open & Export > Import/Export. The Import and Export Wizard opens.
2. Select Export to a file, then Next.
3. Choose Comma Separated Values and continue. If that option or your mail folder is unavailable, cancel and use the list-view method below.
4. Select the mail folder under the correct account, such as Inbox or Sent Items. Do not select Contacts when you want messages.
5. Choose Browse, select a location, and give the file a descriptive name, such as sent-items-review.csv. Confirm it and choose Next.
6. Review the selected export action. If Map Custom Fields is offered, inspect the available fields rather than assuming a particular date field exists. Choose Finish to create the file.

Open & Export > Import/Export, select Export to a file, choose Comma Separated Values, select the mail folder, browse to a location and name the file, review and finish” class=”wp-image-163069″ style=”width:650px;height:auto”/>

Check the result before repeating for other folders. In a Microsoft Q&A discussion with staff-reported testing, the requester found that CSV export omitted received date/time. Inspect your file’s headings and sample records for the dates and addresses you need.

Copy a Custom Message List Into Excel

This alternative exports the information shown in the view. It does not copy the entire message body or attachment contents.

1. Open the mail folder in classic Outlook. Note your current view so you can restore it afterward.
2. Select View > Change View > Single or Preview. You need a list with columns rather than the default Compact layout.
3. Open View > View Settings > Columns. Add the columns you need, such as From, To, Subject, and Received. Use Select available columns from if the field is not in the first list, then confirm the dialogs.
4. Click a message row and select a small group of messages. Press Ctrl + C.
5. Open a blank Excel workbook, click an empty cell such as A1, and press Ctrl + V. Check which fields appeared and whether the dates contain the detail you need.

Microsoft documents switching views and choosing columns. The Q&A discussion above also describes copying the list to Excel. From and To can be display names rather than SMTP addresses. Verify them before using the sheet as an address list.

Once the sample is satisfactory, repeat with manageable selections. Use Ctrl + A only while focus is in the message list and you intend to select its full contents. Repeat for each required folder, adding a Folder column in Excel if you need to distinguish their origins. Return to your previous Outlook view when finished.

Import and Save the Spreadsheet

1. For a CSV, open Excel and select Data > From Text/CSV. Choose the exported file.
2. Check the preview: the separator should split the intended columns, and names should display correctly. Choose the appropriate delimiter and encoding if detection is wrong.
3. Select Load, or Transform Data when you need to control column types first.
4. Compare several records with Outlook. Check the oldest and newest required messages, date interpretation, sender information, and any text you plan to analyze.
5. Save a separate Excel Workbook (.xlsx) through File > Save As. Keep the untouched export for comparison.

Microsoft’s CSV import guide explains the preview and load choices. If you need CSV files to launch Excel when double-clicked, see our CSV default-app and import guide; changing the default app does not preserve exact values automatically.

Fix Missing or Misleading Data

There is no File or Import/Export route: check whether you opened new Outlook or a browser session. Use classic Outlook if it is installed and available to your account. Microsoft now documents PST export in new Outlook too, but a PST is a different result from an Excel table.

Dates are missing or show only a weekday/time: compare the original message details. Cell formatting cannot recreate values that were never copied. Try a small sample with a different view, or ask your administrator for a suitable reporting export if exact timestamps or resolved addresses are essential.

The programs freeze: cancel the attempt if possible and retry fewer messages. The Q&A requester reported freezes with a large copy operation; a successful small sample is not proof that a whole mailbox will fit the same workflow.

Everything is in one column or characters are garbled: reimport the untouched CSV and correct its separator or encoding in the preview. Avoid replacing every comma in a text editor; a comma can be part of legitimate content.

You need attachments or a restorable archive: use a verified email backup instead. PST export makes a copy and includes message attachments; check Microsoft’s cached-mail limitations before relying on it as a full mailbox backup.

Finish by checking the records against Outlook and keeping the original messages. Use Excel for the table you need, and a separate backup workflow for retaining the emails themselves.