Convert MBOX to CSV or Excel: The Fastest Ways
Last updated August 2026
Try it now: extract email data to Excel, CSV, or JSON
Connect a mailbox to pull .eml/.msg in bulk, or paste a raw email to test the converter now.
Create a free account to download. No credit card required.
Stuck with an MBOX file you cannot open?
MailParse turns email into clean rows of the fields you choose, sender, date, totals, order numbers, then exports to Excel, CSV, or JSON. Connect Gmail and skip the MBOX entirely, or follow the methods below.
If you exported your mail from Gmail, Thunderbird, or Apple Mail, you ended up with an MBOX file. Double-click it and nothing useful happens, because an MBOX is not a spreadsheet. It is a single text archive that holds dozens or thousands of messages stacked end to end. To work with that mail in Excel, you have to convert it first. Below are the methods that actually work, what each one costs, and how to pull only the fields you care about instead of a giant dump of every message.
What is an MBOX file?
An MBOX file is a single archive that stores many email messages in one plain-text file, one after another. Gmail's Takeout export, Mozilla Thunderbird, and Apple Mail all save mail in this format. Each message keeps its headers, the sender, recipient, subject, and date, along with its body, separated by a line that begins with the word From followed by a space. Because everything sits in one file, an MBOX is easy to move and back up, but a spreadsheet cannot read it as rows and columns.
Can Excel open an MBOX file?
No. Excel cannot open an MBOX file directly, because MBOX is an email storage format, not a table of rows and columns. If you rename the file to .txt and open it, you see raw headers and encoded message bodies crammed into cells, not clean data. To get usable columns such as sender, date, and subject, you first convert the MBOX into a CSV, which Excel opens natively.
How do I convert an MBOX file to CSV or Excel?
There are four reliable ways to convert an MBOX file to CSV or Excel: export it from Thunderbird with a free add-on, run it through an online or desktop converter, connect the original mailbox to a parser and pull only the fields you need, or write a short script. The right one depends on whether you want every message dumped to a sheet or just a few specific fields, how many emails you have, and how comfortable you are with software. Here is how they compare.
| Method | Cost | Skill needed | Pulls only chosen fields | Best for |
|---|---|---|---|---|
| Thunderbird add-on (ImportExportTools NG) | Free | Moderate, install and import | No, dumps whole messages | A one-time export of every message to a sheet |
| Online or desktop MBOX converter | Varies, many paid | Low | No, fixed columns | Quick conversion when privacy of the upload is not a concern |
| Connect the mailbox to MailParse | Free tier, paid plans by volume | Low, point and click | Yes, name the fields you want | Pulling order numbers, totals, or dates from many emails |
| Write a script (Python mailbox module) | Free | High, you code it | Yes, if you build the logic | Developers with a repeatable, custom job |
Most converters give you one row per message with the sender, subject, date, and body. If you only need a few values, such as an invoice total or a tracking number that sits inside the body, connecting the mailbox and naming those fields saves you a second round of cleanup in Excel.
Method 1: Export to CSV in Thunderbird (free)
The free route is Mozilla Thunderbird with the ImportExportTools NG add-on. It imports your MBOX and exports the folder as a CSV that Excel opens. The steps are short:
- Install Thunderbird, then add ImportExportTools NG from the add-ons menu.
- Right-click a local folder, choose ImportExportTools NG, then Import mbox file, and select your MBOX.
- Right-click the same folder again, choose ImportExportTools NG, then Export all messages in the folder, and pick the Spreadsheet (CSV) option.
- Open the resulting CSV in Excel.
This works and costs nothing, but it gives you a full dump: one row per message with the headers and the whole body in a cell. For a few hundred messages that is fine. For large archives, or when you only want a couple of values out of each email, it leaves a lot of manual trimming in the spreadsheet.
Method 2: Connect Gmail and pull only the fields you need
If the MBOX came from a Gmail Takeout export and you still have the account, skip the file altogether. Connect Gmail to MailParse, choose a label or a search, and name the fields you want, such as sender, date, order number, or invoice total. MailParse reads each message and writes one clean row per email to Excel, CSV, or JSON, so you get a structured sheet instead of a copy of your inbox. See the extract data from Gmail guide for the full walkthrough, or send the result straight to a sheet with the email to Google Sheets workflow.
The difference from a plain converter is what lands in the sheet. A converter gives you every field of every message. A connected parser gives you only the columns you asked for, pulled from the subject and the body, which is usually what you wanted in the first place.
Method 3: Convert the messages as EML files in bulk
When the MBOX comes from Thunderbird or Apple Mail and there is no live account to connect, export the individual messages as EML files first, then convert them in bulk. In Thunderbird with ImportExportTools NG, choose Export all messages in the folder, then the EML format. In Apple Mail, drag the messages out of the message list into a folder to save them as EML. From there, run the EML files through the EML to CSV converter to get one row per email, or send them to the EML to Excel converter for an XLSX workbook. This path keeps your data on your own machine and still produces a clean spreadsheet. If you were hoping Excel would just open those files directly, opening an EML file in Excel explains why it will not and what the workaround looks like.
How do I convert Gmail Takeout to Excel?
Google Takeout exports Gmail as an MBOX file, which Excel cannot open, so you have two practical routes. The cleanest is to connect the same Gmail account to a parser, choose the fields, and export Gmail emails to Excel directly, which skips the MBOX entirely. The alternative is to import the Takeout MBOX into Thunderbird and export it to CSV, then open that in Excel. If you have not run the export yet, it is worth reading what Takeout actually gives you first, including the 7 day expiry on the archive.
How do I convert MBOX to CSV on a Mac?
Apple Mail stores mailboxes in MBOX format, and the same approach works on a Mac. Install Thunderbird for macOS, import the MBOX with ImportExportTools NG, and export the folder as CSV, or drag the messages out of Apple Mail as EML files and convert those. There is no built-in Apple Mail button that exports to a spreadsheet, so a converter or parser is the step that turns the mail into columns.
What program opens MBOX files?
Email clients such as Mozilla Thunderbird and Apple Mail open MBOX files so you can read the messages, and Thunderbird can also import an MBOX you received from elsewhere. A viewer alone will not give you a spreadsheet, though. To turn the mail into rows and columns you still need a converter or a parser, because reading the messages and extracting their data into Excel are two different jobs.
Which method should I use?
If you just need every message in a sheet once, Thunderbird's free CSV export is enough. If you need specific values out of many emails on an ongoing basis, connect the mailbox and let the parser pull just those fields. If your data lives inside attachments rather than the message text, those need their own tools: PDF bank statements your bank emailed you convert best with a bank statement to Excel converter, emailed purchase receipts read more cleanly through a receipt to Excel tool, and supplier invoices attached as PDFs come out as line items with an invoice to Excel extractor. Developers who would rather get structured output than a spreadsheet can return the same fields as email to JSON and feed them straight into another system.