Why convert MBOX to CSV?
Converting MBOX to CSV gives you a spreadsheet you can sort, filter, and analyze in Excel or Google Sheets. Common uses are auditing a mailing list archive, counting messages per sender, or reviewing a Gmail Takeout export without opening an email client.
How to convert MBOX to CSV
Python (mailbox module) FREE
Write a short Python 3 script using the built-in mailbox module to iterate over messages and write From, To, Subject, and Date fields to a .csv using the csv module.
About these formats
.MBOX
Mbox Mailbox (email container)
An MBOX file is a mailbox - a single plain-text file that holds many email messages stored one after another. Google Takeout exports Gmail as .mbox, and Thunderbird and Apple Mail use the…
Open .MBOX details →
.CSV
Comma-Separated Values
A CSV file stores tabular data as plain text - one row per line, values separated by commas (or semicolons in European locales). Any spreadsheet opens it: Excel, Google Sheets, LibreOffice…
Open .CSV details →Quality & what to watch
- Only metadata transfers cleanly - From, To, Subject, Date fit as CSV columns; message bodies and attachments do not.
- A Gmail Takeout .mbox can be several gigabytes; the Python mailbox module reads the file sequentially without loading everything into memory at once.
- Avoid uploading an .mbox to online converters - it contains your complete email history and is highly sensitive personal data.
