Outlook Export Emails to Excel With Date

Updated 4 November 2026 · Standard formula, shown below

Yes, you can export Outlook emails to Excel with their dates intact, and the cleanest way is to use Outlook’s built-in Export to a file wizard, which writes the Received date into a dedicated column. This article explains the standard export path, how to get the date format you want, what to do when dates look wrong, and a few alternatives if the built-in tool does not fit your workflow.

What the Built-In Export Actually Does

Outlook (Microsoft 365, Outlook 2019, 2021, and older versions) includes an export feature that copies folders to a comma-separated values (CSV) file. That CSV file opens directly in Excel, and each email becomes one row. The columns include Subject, From, To, Sent, and Received. The Received column holds the date and time the message arrived in your mailbox, which is what most people mean by “the date” of an email.

The export does not create an Excel .xlsx file directly; it creates a .csv file. Excel opens it without any conversion steps, so for most purposes the difference is invisible. The important detail is that the date is exported as text in whatever format your Windows regional settings use, which is why you sometimes see dates like 02/03/2024 and other times see 2024-02-03.

Step-by-Step: Export a Folder to CSV

Open Outlook and go to the File tab.
Choose Open & Export, then click Import/Export. (In Outlook 2010 and 2013, the path is File > Options > Advanced > Export, but the wizard is the same.)
Select “Export to a file” and click Next.
Choose “Comma Separated Values” and click Next.
Pick the folder you want to export. You can select a mail folder, a contact folder, or a calendar folder. For emails, choose the folder that holds the messages, such as Inbox or a subfolder. Click Next.
Browse to a location, type a file name, and click Next.
Click Finish. Outlook exports the entire folder, including subfolders if you checked the option at the bottom of the folder selection screen.

After the export finishes, open the .csv file in Excel. The Received column will contain the date and time for each message. If you only want a date without the time, you can change the cell formatting in Excel or use a formula to strip the time portion.

Why the Date Column Sometimes Looks Wrong

The most common complaint after exporting is that the date appears as a long number like 45234.789. That is not an error; it is Excel’s serial date format. Excel stores dates internally as the number of days since January 1, 1900, and the decimal part represents the time of day. The CSV file contains the date as text, but Excel may interpret it and convert it to its internal serial number, then display it in a default format that looks like a number.

To fix it, select the column, right-click, choose Format Cells, then pick a date format such as dd/mm/yyyy or yyyy-mm-dd. If the column still shows numbers after formatting, the cell values are probably being treated as text. In that case, select the column, use Data > Text to Columns, and choose Delimited, then just click Finish. That forces Excel to convert text dates into real date values.

How to Get the Date in a Specific Format

If you need the date in a particular format, such as ISO 8601 (2024-02-03) for sorting or for other software, you have two options. First, you can change your Windows regional date format before exporting. Outlook uses the short date format from Windows settings when it writes the CSV. Go to Windows Settings > Time & Language > Region, and change the short date format. After that, re-run the export.

Second, you can keep the export as-is and reformat in Excel. If the Received column contains real dates, you can apply a custom number format like yyyy-mm-dd hh:mm. If the column contains text, use a formula such as =DATEVALUE(A2) to convert it, then format the result. This approach gives you full control without touching Windows settings.

Common Problems and Fixes

Only the current view is exported. The export wizard exports all items in the folder, not just the ones visible in the current view. If you applied a filter, the export ignores it. To export a subset, create a new folder, move or copy the messages there, and export that folder.
Date column is blank for some rows. This can happen if the email is a draft or a calendar item that lacks a received timestamp. Drafts have no Received date because they were never sent.
The CSV file opens with garbled characters. Outlook exports in the system ANSI encoding, which can break accented characters. Save the CSV as UTF-8 using Excel’s Save As, or use the Import/Export wizard from a non-English Outlook version.
Export is slow for large folders. Exporting 10,000 emails can take several minutes. Close other programs and be patient. If it seems stuck, wait; the wizard does not show progress.
Date and time are separated. If you want the date and time in separate columns, use Excel formulas: =INT(A2) for the date and =MOD(A2,1) for the time, then format accordingly.

Alternatives: Power Query, VBA, and Third-Party Tools

If you need to export emails repeatedly, the built-in wizard becomes tedious. A more efficient approach is to use Power Query in Excel to pull data directly from your Outlook folder. In Excel, go to Data > Get Data > From Other Sources > From Microsoft Exchange, then enter your email address. Power Query can list emails from your mailbox and refresh on demand. This method gives you the Received date as a real date/time value, and you can transform it before loading it into a worksheet.

Another option is a small VBA macro inside Outlook that loops through a folder and writes selected fields to a CSV or Excel file. This gives you full control over which columns to include and how to format the date. A simple macro can export Subject, Received, From, and To in a few seconds, and you can run it with a single click.

Third-party add-ins exist that export Outlook data to Excel with more options, such as exporting attachments or filtering by date range. These tools are not free, but they can save time if you do this regularly. For a one-time export, the built-in wizard is usually enough.

What the Date Actually Represents

When you export an email, the Received date is the moment the message arrived in your mailbox, not the date it was sent. For most purposes, that is the date you want. The Sent date, which is in the Sent column, reflects when the sender’s email client transmitted the message. These two can differ by seconds, minutes, or even hours if the sending server delayed delivery. If you are analyzing response times, use the Received date for the incoming message and the Sent date for your reply.

Frequently Asked Questions

Can I export only emails from a specific date range?

Not directly with the built-in wizard. It exports the entire folder. To export a date range, create a new folder, use Advanced Find (Ctrl+Shift+F) to locate messages in that range, move them to the new folder, and export that folder. Alternatively, use Power Query and filter the date column after importing.

Why does my CSV show dates as numbers like 45234?

Excel converts the text date from the CSV into its internal serial date format. The number 45234 represents the number of days since January 1, 1900. Format the column as a date to display it normally. If formatting does not work, use Text to Columns to force conversion.

Does the export include attachments?

No. The CSV export only includes text fields like Subject, From, To, and Received. Attachments are not exported. To save attachments, you need to save each one manually or use a VBA macro that loops through messages and saves attachments to a folder.

Can I export from Outlook on the web (OWA)?

Outlook on the web does not have the same export wizard. You can use the built-in “Export” option in some versions of OWA that exports contacts and calendar, but not email folders. For emails, use the desktop Outlook application or a third-party service that connects to your mailbox via IMAP or Microsoft Graph.

How do I keep the date format as DD/MM/YYYY instead of MM/DD/YYYY?

Change your Windows short date format to DD/MM/YYYY before exporting. Outlook uses that format when writing the CSV. If you already exported, use Excel’s Text to Columns to convert the text to a date, then apply a custom format of dd/mm/yyyy.

Is there a limit to how many emails I can export?

The built-in wizard does not have a hard limit, but very large folders (tens of thousands of items) can cause Outlook to run slowly or appear to hang. For extremely large exports, consider using Power Query or a VBA macro that processes messages in batches.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.