Install MBOX to CSV Data Extractor from the Mac App Store, drag your .mbox file into the app, choose Excel (.xlsx) as output, and click Convert. Open the result in Excel, Numbers, or Google Sheets.
Why Excel, not CSV
CSV and Excel both hold tabular data, but they behave differently once you open them:
- Typed columns. An
.xlsxfile stores dates as dates and numbers as numbers. A CSV is pure text — Excel guesses types on import, and often guesses wrong (phone numbers become scientific notation, dates lose their year, subjects starting with a minus become formulas). - Formatting survives. Column widths, header row, frozen panes, and number formats are saved inside the file. Open a CSV and you start from a plain grid every time.
- No import dialog. Double-click an
.xlsxand it just opens. A CSV triggers Excel's Text Import Wizard, which asks about delimiters and encoding you shouldn't have to think about. - Pivot tables and date filters work immediately. Dates stored as text cannot be grouped by month or filtered with Excel's built-in date filters.
For analyzing email archives — which is almost always a date-and-sender question — .xlsx is the better output unless you are hitting Excel's row limit.
Why Excel can't open MBOX directly
An MBOX file is a concatenation of raw email messages in a single text file. Opening one in Excel looks like this:
From [email protected] Mon Apr 22 09:12:00 2026
From: [email protected]
To: [email protected]
Subject: =?UTF-8?B?UmU6IFByb2plY3Q=?=
Date: Mon, 22 Apr 2026 09:12:00 +0000
Content-Type: multipart/mixed; boundary="--=_Part_001"
----=_Part_001
Content-Type: text/plain
Hi Bob — attaching the draft.
...Every line lands in column A. Headers, MIME boundaries, Base64-encoded attachments, and message bodies all pile together. Excel has no built-in parser that knows where one message ends and the next begins.
A dedicated converter reads the MBOX, parses each message, decodes the encoded parts, and writes clean rows. MBOX to CSV Data Extractor is a native Mac app that does exactly this, and writes output as .xlsx, CSV, JSON, XML, or plain text. More on the MBOX format →
How to convert MBOX to Excel on Mac
- Open MBOX to CSV Data Extractor. Install from the Mac App Store (free for files under 50 MB).
- Add your MBOX file. Drag it from Finder into the app window, or use the file picker.
- Choose Excel as output and optionally enable attachment extraction. Click Convert and pick a destination folder.
The app streams the file, so multi-gigabyte archives convert without loading everything into memory. Open the resulting .xlsx in Excel, Numbers, Google Sheets, or LibreOffice Calc.
What the Excel file looks like
Default columns, in order:
| Column | Type in Excel | Example |
|---|---|---|
| From | Text | [email protected] |
| To | Text | [email protected]; [email protected] |
| CC | Text | (often empty) |
| BCC | Text | (often empty) |
| Subject | Text | Re: Project update |
| Date | Date | 2026-04-22 09:12:00 |
| Body | Text (plain, HTML stripped) | Hi Bob — attaching the draft. |
You can disable any column in the app's settings before converting.
Excel-specific tips
- Freeze the header row —
View > Freeze Top Row— so column labels stay visible while scrolling through thousands of emails. - AutoFilter —
Data > Filter— lets you filter by sender domain, subject keyword, or date range without writing a single formula. - Pivot by month — build a pivot table with Date in Rows and count of Subject in Values. Excel automatically groups dates by year/quarter/month, giving you a volume-over-time view in seconds.
- Find top senders — pivot with From in Rows and count of Subject in Values, sort descending. This is often the single most-asked question about an archive.
- Keyword-count formula —
=SUMPRODUCT(--ISNUMBER(SEARCH("invoice", G:G)))counts how many bodies mention a word. Useful for quick content audits.
Handling very large archives
Excel has a hard limit of 1,048,576 rows per sheet. A medium mailbox is usually well under that; a multi-year Gmail archive can exceed it. Options:
- Split the output. Enable the app's "Split output" setting and specify, for example, 500,000 records per file. You get several
.xlsxfiles, each comfortably under Excel's limit. - Switch to CSV + Power Query. Export as CSV and load it into Excel via
Data > Get Data > From Text/CSV. Power Query handles files much larger than the sheet limit and feeds summaries back into regular worksheets. - Export to JSON. For programmatic analysis — Python, DuckDB, a database — JSON is usually easier to work with than a giant CSV.
FAQ
Can Excel open an MBOX file directly?
No. Excel has no native MBOX parser. If you open a .mbox file in Excel, you will see the raw plain-text contents — headers, separators, Base64-encoded attachments — all crammed into column A. To work with MBOX in Excel, convert it to .xlsx or .csv first.
Should I use .xlsx or .csv as the output?
Pick .xlsx if you plan to analyze the data in Excel, Numbers, or Google Sheets — you get typed columns, auto-applied column widths, and no import step. Pick .csv if your data has more than 1,048,576 emails (Excel's per-sheet row limit), if you need to feed it into a database, or if another tool expects plain CSV.
What columns are in the Excel output?
By default: From, To, CC, BCC, Subject, Date, and Body — one row per email. Dates are formatted as Excel date values. You can customize which columns to include in the app's settings.
Will the Date column work with Excel filters and pivots?
Yes. Date is written as a real Excel date value, not a string. You can use Excel's date filters (This Week, Last Month, Between), group pivot-table rows by year/quarter/month, and sort chronologically without any additional cleanup.
Can Excel handle a 10 GB Gmail archive?
Excel has a 1,048,576-row-per-sheet limit. A 10 GB archive may exceed that depending on message count. Either enable "Split output" to produce multiple .xlsx files under the row limit, or export to .csv and use Power Query or a scripting tool for analysis. See the Gmail Takeout guide for details.
Does the Excel output include HTML formatting?
No. HTML tags are stripped so the Body column is readable plain text. If you need the original HTML, export to JSON instead.
Are attachments included in the Excel file?
Attachments are saved to a separate folder, not embedded in the spreadsheet. The app exports attachments with filenames that reference the source message, keeping your .xlsx small and attachments individually accessible.
Related
Open your MBOX in Excel in under a minute
Free for MBOX files under 50 MB. Native .xlsx output, 100% offline.