Written by Jennifer Walsh. Reviewed for technical accuracy by Shubham Dixit, Independent Expert in Email Forensics and Data File Conversion.
Shubham is an independent external reviewer and not an employee of PCDOTS.
Quick answer. An MBOX file is one long mailbox file, not a table, so converting it to Excel means pulling each email into a row with columns for sender, recipient, subject and date. A free viewer or Thunderbird can export a CSV that Excel opens, while a tool does the same in bulk and skips the setup. What you get is a table of fields, not the full formatted emails.
On this page
What you actually get in Excel?
Set the right expectation first, because it saves disappointment later. An MBOX file stores a whole mailbox as one long run of plain text, with every message stacked one after another. Excel needs rows and columns. So converting MBOX to Excel does not move your emails across as emails, it extracts each message into a row, with columns for the fields that fit a table, the sender, the recipients, the subject and the date.
That is exactly what you want for sorting, filtering and analysis, a clean grid you can work with. What it is not is a copy of the rich emails. The body can drop into a cell as plain text, though it may be long and untidy, any HTML formatting is lost, and attachments do not travel into a spreadsheet at all, at most you get a filename. Keep that in mind and every method below makes sense.
Each stacked message becomes a row of fields you can sort and filter.
The headers tabulate cleanly. The body flattens, and attachments stay behind.
“An MBOX is just a flat file with every message concatenated, so turning it into a spreadsheet is really a field extraction, you read each message’s headers and drop them into columns. The headers, sender, recipients, subject and date, tabulate perfectly and are exactly what you want for analysis. The body and any attachments are the awkward part, a body flattens to plain text at best and an attachment cannot sit in a cell, so if those matter keep the original MBOX alongside your spreadsheet.” Shubham Dixit, Email Forensics reviewer (draft, pending approval)
The free way, Thunderbird to CSV
The most reliable free route uses Thunderbird, which is free, plus a free add-on. It exports every message’s fields to a CSV, and a CSV opens straight in Excel.
Set up Thunderbird and the add-on. Install Thunderbird if you do not have it, then add the free ImportExportTools NG extension.
Import the MBOX. Go to Tools, ImportExportTools NG, Import mbox file, and select your MBOX.
Export to CSV. Select the imported messages, then Tools, ImportExportTools NG, Export all messages to a CSV file, and choose where to save.
Open in Excel. In Excel choose File, Open and select the CSV, then Save As an Excel Workbook if you want a .xlsx. That is the whole job, free, for one or a few files.
A free viewer, or a quick script
Two more free options suit different people.
A free MBOX viewer. If you would rather not set up Thunderbird, a free MBOX viewer lists your messages in a table and can export or copy the fields to CSV. This is the kind of viewer many people search for by name, and PCDOTS has its own free MBOX file viewer for a quick look before you export.
A short script, for the technical. If you are comfortable with a little code, Python’s built in mailbox module reads an MBOX and you can write the headers straight to a CSV with the csv module in a dozen lines. It is the most flexible route when you want exactly the fields you choose and nothing else.
The bulk way, with a tool
The free routes are fine for a file or two. When you have many MBOX files, or very large ones, and do not want to install a client and add-on or babysit the process, a converter does the extraction in bulk. The PCDOTS MBOX Converter loads MBOX files or a whole folder, lets you choose the fields such as From, To, Cc and Subject, and exports a CSV that opens directly in Excel. Being straight about it, the output is the same kind of table the free method produces, a CSV, so the tool is not giving you a richer result, it is saving you the setup and handling scale, large files and batches, in one pass. There is a free version to try on your own file first.
The tool route, for many or very large MBOX files.
Here are the steps with the screens.
Step 1. Install and run the converter on Windows.
Step 2. Choose Open, Email Data Files, MBOX, and add your files or folder.
Step 3. Open the Export menu and select CSV.
Step 4. Choose a destination and click Save, then open the CSV in Excel.
If you specifically want the CSV format itself rather than an Excel workbook, our guide to convert MBOX to CSV covers that, and if you would rather read the mail in a client there is one on how to import MBOX to Thunderbird.
The methods compared
Match the route to how many files you have and whether you want to install anything.
| Method | Best for | Good to know |
|---|---|---|
| Thunderbird and ImportExportTools NG | One or a few files, free | Reliable, needs the client and add-on |
| Free viewer or Python script | A quick look or exact fields, free | Viewer for ease, script for control |
| MBOX Converter tool | Many or very large files | Same CSV output, no setup, bulk |
Frequently asked questions
Can I open an MBOX file directly in Excel?
No. MBOX stores a stack of email messages, while Excel needs structured rows and columns, so you first extract the message fields to a CSV, which Excel then opens.
How do I convert MBOX to Excel for free?
Import the MBOX into Thunderbird with the free ImportExportTools NG add-on and export all messages to a CSV, then open that CSV in Excel. A free MBOX viewer can export the fields too.
Do attachments and formatting come across?
No. A spreadsheet holds fields, so attachments do not transfer and HTML formatting is lost. You get sender, recipients, subject, date and, if you include it, the plain-text body.
What fields can I get in the spreadsheet?
The header fields tabulate cleanly, From, To, Cc, Subject and Date. A tool lets you pick which of these to include, and you can add the plain-text body as a column if you want it.
Can I convert many MBOX files at once?
Yes. Thunderbird can export a selection, and a converter can process a whole folder of MBOX files in one pass, which is easier for large batches.
Is the output Excel or CSV?
Both routes produce a CSV, which Excel opens directly. If you need a true .xlsx, open the CSV in Excel and use Save As to store it as an Excel Workbook.
You are pulling out a table, not the whole email
The single thing to hold onto is what this conversion really is. You are extracting each message into a row of fields, sender, recipient, subject and date, to sort and filter in Excel, and that table is genuinely useful. You are not carrying the formatted emails or their attachments into the spreadsheet, and no method can, because a cell is not built to hold them. So keep the original MBOX safe for the full messages, use Thunderbird or a free viewer for a file or two, and reach for a converter only when the count or the size makes the free route a chore. Either way, what lands in Excel is a clean table of your mail.
