Convert MBOX to Excel, CSV or Google Sheets

How to convert MBOX to CSV

1. Open the file. Drop your .mbox on the homepage. It can be a Google Takeout export, a Thunderbird folder or an Apple Mail mailbox.
2. Filter if you want a subset. Search by sender or subject, set a date range, or tick Has attachment. The export follows what you can see.
3. Click Export → CSV. Choose this message, the current view or the whole mailbox. Tick include message text if you want the body of each email as well as the headers.
4. Open it. Double-click the CSV to open it in Excel or Numbers. In Google Sheets, use File → Import → Upload.

What's in the spreadsheet

Column	Contents
date	When the message was sent
from	Sender name and address
to	Recipients
subject	Subject line
size_bytes	Size of the message
attachments	Attachment file names
body	Optional. The plain-text message, up to 32,000 characters per message (that's Excel's limit for one cell).

The file is saved as UTF-8 with a byte-order mark, so accents, emoji and non-Latin scripts show up correctly when Excel opens it, instead of turning into garbled characters.

Want a list of email addresses instead?

Choose CSV and tick emails only. You get one row per unique address, with how many messages that address sent and how many were sent to it. Sort by the count and you can see who a mailbox actually corresponds with. It's a quick way to rebuild a contact list from a Gmail backup.

Can I get an .xlsx file?

The export is CSV, which Excel opens as a normal spreadsheet. If you need .xlsx, open the CSV in Excel and use File → Save As → Excel Workbook.

What's free

Exporting a single message is free. Exporting the current view or the whole mailbox is part of the one-time $29 unlock, with no subscription. You can open and filter the file first and see exactly what you'll get before paying.

Video: convert MBOX to Excel and Google Sheets

Convert MBOX to Excel, Google Sheets (CSV), PDF and EML on YouTube

Common questions

Related guides