Convert MSG to Excel and CSV by Exporting Outlook .msg Files

A .msg file is how Outlook saves a single email to disk, and at some point you end up with a folder of them: forwarded orders, signed quotes, support threads, anything someone dragged out of their mailbox. The job is almost always the same. Get the sender, the date, the subject, and a field or two from the body into a spreadsheet so you can sort, filter, and total it. Double-clicking the file opens it in Outlook, not Excel, and there is no obvious export. Here is what a .msg file actually is, why Excel cannot read it on its own, and the practical ways to turn one or a thousand of them into a usable spreadsheet.

How do I convert a MSG file to Excel?

To convert a MSG file to Excel, run it through a converter that reads the Outlook message format and writes each field to its own column, then save as CSV or XLSX. Pick which parts become columns (sender, recipient, date, subject, body, and any custom value), and each email comes out as one row. Excel opens that file as a normal spreadsheet with the data already sorted into cells you can filter and total.

This is the approach that holds up at any volume. A browser-based MSG to Excel converter does it without installing a desktop app or routing through Outlook, and you can mix .msg and .eml files in the same job. For the wider picture of moving mailbox data into a sheet, our guide to getting email data into Excel also covers connecting a live Gmail or IMAP account.

Why won't a MSG file open in Excel directly?

A .msg file will not open in Excel as a table because it is a Microsoft compound binary file, not a row of data. Outlook stores the headers, the plain-text body, an HTML version, and any attachments together in one structured container built for the mail client to read. Excel has no way to decode that, so forcing it open shows binary noise or a single unreadable cell. The information is all in there; it just needs a parser that understands the Outlook format to map each field into its own column.

How do I open a MSG file in Excel?

The reliable way to open a MSG file in Excel is to convert it to CSV or XLSX first, then open that file. You cannot point Excel at the .msg itself and get columns. Outlook's own Insert > Object > Create from File will embed the message as an icon inside a worksheet, but that is a copy of the email, not its data in cells. To get sortable fields you convert the file, which decodes the message and lays each value out as a column.

Can you open a MSG file without Outlook?

Yes, you can open a .msg file without Outlook using a free MSG viewer or by converting it, because the format is documented and not locked to a single app. A viewer renders the message so you can read it. To get the contents as spreadsheet data rather than just reading them, you convert the file to CSV or Excel, and a browser-based MSG converter does that with no Outlook install at all. That matters when the .msg files came from someone else and you do not have Outlook set up.

How do I convert a MSG file to CSV?

To convert a MSG file to CSV, upload it to a converter, choose the fields you want as columns, and export to CSV. CSV is plain text, so the result opens in Excel, Google Sheets, or any database without extra steps. The manual alternative is to open each message in Outlook, copy the details, and paste them into a sheet by hand, which is fine for one email and painful past a handful. A converter reads the message structure and writes the row for you.

How do I convert multiple MSG files to Excel at once?

To convert multiple MSG files to Excel at once, use a desktop batch converter such as BitRecover or Aid4Mail, which take a whole folder in one run. MailParse parses one uploaded .msg file at a time, so it suits a handful of files or mail that is still arriving, which it parses automatically from a connected Gmail or IMAP mailbox. This is where the manual Outlook route falls apart: copying and pasting a few thousand saved messages is hours of work and a transcription error on every other line. Our walkthrough on converting files to CSV in bulk compares the batch options.

What data can you extract from a MSG file?

You can extract every standard email field from a .msg file: the sender, recipients, date, subject, and message body, plus a list of any attachments by filename. Beyond the headers, a parser can find named values inside the body, such as an invoice number, order ID, tracking number, or total, and give each its own column. So the spreadsheet holds exactly the fields you pick, not a dump of the whole raw message. If a .msg carries a PDF invoice, you can convert that PDF attachment to Excel separately once it is saved.

Is there a free way to convert MSG to Excel?

You can read a .msg file for free in a viewer or in Outlook, but turning a folder of them into a clean spreadsheet takes a converter, and the manual free routes do not scale. Copy and paste works for one or two messages; past that the time and the typos outweigh any saving, and the desktop tools that promise it usually export only the sender, subject, and date, not values from the body. A converter that names the fields you care about is the difference between glancing at one email and building a usable spreadsheet from the whole folder.

The short version: a .msg file is an Outlook message saved as a compound binary, so Excel cannot read it as a table on its own. To get a spreadsheet, convert each file so its fields map to columns. For a single message a quick copy works; for a folder of them, or when you want specific values like an order total or tracking number pulled out automatically, the MSG to Excel converter reads your files and hands back one clean spreadsheet. If you are comparing tools, our guide to the best email parser walks through what matters, and the explainer on .eml versus .msg files is worth a read if your exports are a mix of both formats. If the files will not open at all on the machine you are working from, start with how to open a MSG file without Outlook.