Export Outlook Emails to Excel: Bulk, by Date, to CSV

Last updated July 2026. Verified against the current classic Outlook and new Outlook for Windows.

Getting Outlook email data into a spreadsheet sounds like it should be a one-click job, and for plain message lists it almost is. Outlook ships with an Import/Export wizard that writes your messages to a CSV file you can open in Excel. The catch shows up the moment you need more than the envelope: a date range only, a whole mailbox at once, or the actual values buried inside the email body. This guide walks the built-in methods step by step, flags where each one stops working, and shows how to pull named fields when the wizard hands you raw text.

Ways to export Outlook emails to Excel, compared

Four routes get Outlook messages into a spreadsheet, and they differ mostly in whether they can reach inside the message body and whether they survive the move to the new Outlook. Here is an honest comparison, including where each one beats the others.

Behavior confirmed in July 2026. Microsoft continues to change the new Outlook, so check whether the wizard has returned before ruling it out.

Can you export Outlook emails to Excel?

Yes. The classic Outlook desktop app can export a mail folder to a CSV file through File > Open & Export > Import/Export, and Excel opens that CSV directly. Each email becomes a row, with columns for fields like Subject, From, To, Received date, and Body. You can also select messages and copy-paste them into a sheet, though that loses structure. For data sitting inside the message body, you will want a parser.

How do I export Outlook emails to Excel?

In classic Outlook, click File > Open & Export > Import/Export, choose "Export to a file," select "Comma Separated Values," pick the mail folder you want, choose where to save the CSV, then click Finish. Open the resulting file in Excel and each message lands on its own row. The wizard exports standard fields such as Subject, From, To, Cc, and the received date.

If you only need a quick list, there is a faster manual route: open the folder, press Ctrl+A to select the messages, then Ctrl+C and paste into Excel. That gives you the visible columns (From, Subject, Received) but not the body, and it does not scale past a few hundred rows. For anything ongoing, the Import/Export wizard is more reliable, and a parser is better still when you need the same export every day without clicking through the wizard each time.

How do I export Outlook emails to Excel with the date?

To export only emails from a date range, filter the folder before you export. Use Outlook's Advanced Find or the filter dialog, pick the Received field, choose a condition like "on or after," "on or before," or "between," and enter your dates. Then run File > Open & Export > Import/Export on the filtered view so the CSV contains just that window. The received date itself exports as one of the standard columns.

This is the cleanest way to pull, say, last quarter's order confirmations or one month of supplier emails without exporting the entire mailbox and trimming rows in Excel afterward. If you run the same date-bounded export on a schedule, point a parser at the folder with a date condition instead, so the spreadsheet refreshes itself rather than you repeating the filter and wizard every reporting cycle.

Can you export emails from the new Outlook to Excel?

Not directly. The Import/Export wizard that writes a CSV lives only in classic Outlook for Windows. The new Outlook and the web version do not currently include that export feature, which is the most common reason people find the menu missing. Your options are to switch back to classic Outlook temporarily, use the copy-paste method, or connect the mailbox to a parser that reads it over the standard Microsoft 365 connection.

The last option sidesteps the version problem entirely, because it does not depend on a menu inside the desktop app. If your organization has already moved everyone to the new Outlook, a tool that connects to the mailbox directly is usually the least painful path to a spreadsheet. Our extract data from Outlook emails page covers how that connection works.

How do I bulk export emails from Outlook to Excel?

For a whole folder at once, the Import/Export wizard is already a bulk export: it writes every message in the selected folder to a single CSV in one pass, no row limit to worry about. To export several folders, run the wizard once per folder, or move the messages into one folder first. For recurring bulk jobs, a VBA macro can loop the folder's items and write each field to a worksheet automatically.

VBA works but it is brittle: the macro hard-codes which part of each message maps to which column, so a sender who restyles their email can quietly break your output. If you are exporting thousands of messages on a regular cadence, or pulling values out of the body rather than just the header fields, a dedicated parser handles the volume without a script to maintain. The email parser API is built for exactly those high-volume, repeatable jobs.

Why does my Outlook export put the whole email in one cell?

Because the native export treats the message body as a single text field, so the entire body lands in one cell with the data still locked inside it. The wizard exports envelope fields (From, Subject, Received) into their own columns, but it has no idea that "Order #10482" or "Total: $312.40" inside the body should become separate columns. It copies the text verbatim and leaves the parsing to you.

That is the real wall most people hit. You wanted order numbers, amounts, and dates in tidy columns; you got a wall of body text in column F. Splitting it back out with Excel formulas or Text to Columns works until a sender changes their wording, then the formulas break. A parser solves this by reading the body and any HTML tables and writing the values you named into their own columns. Our walkthrough on how to extract a table from an email covers the table case specifically.

How do I export Outlook emails to Excel automatically?

To make the export run on its own, connect the mailbox to an email parser instead of running the wizard by hand. You connect Outlook or Microsoft 365 once, tell the parser which fields to capture, and every new matching email is read and appended to your spreadsheet automatically. No menu clicking, no macro, and it works the same whether you are on classic or new Outlook because it reads the mailbox over the connection, not through a desktop menu.

This is the difference between a one-off export and an ongoing feed. Manual exports are fine when you need a snapshot; automation matters when the same emails arrive every day and you want them in the sheet without thinking about it. You can send the output to Excel, CSV, or JSON, and Gmail users can do the same thing from the Gmail side.

What data can you pull from Outlook emails?

The native export gives you the standard header fields: sender, recipients, subject, and received date, plus the raw body as one block. A parser goes further and pulls the structured values written inside the message body: order numbers, invoice totals, due dates, tracking numbers, line items in an HTML table, or any field you name. It reads HTML emails and tables, not just plain text, and writes each value to its own column, along with the filenames of anything attached.

One boundary is worth knowing before you pick a tool. Email parsers read the message, not the documents attached to it. If the figures you are after are printed inside an attached PDF rather than typed into the email, that is a different job: a scanned invoice needs document extraction, and a PDF bank statement needs a step that will turn the statement into a spreadsheet before any of it reaches Excel.

So the ceiling depends on the method. If you only need a list of who emailed you and when, the Import/Export wizard is enough. If you need the numbers and details that live inside each message, turned into columns you can sort and total, that is parsing work. For the full picture of native Outlook methods versus a parser, see our breakdown of four ways to export emails to Excel, or convert saved messages directly with the MSG to Excel converter.

The short version: classic Outlook's Import/Export wizard exports a folder to CSV and Excel opens it, filtering by date first keeps the export tight, and a folder export is already a bulk export. The two walls are the new Outlook (no wizard) and the body landing in one cell. When you need named fields, a date-bounded feed, or an export that runs itself, connect the mailbox and let a parser do it. You can extract data from Outlook emails to Excel in a few clicks, or compare the options in our email parser buyer guide.