Example: the first rows of a sales mailbox
With the Full text preset, the CSV for a small sales mailbox (fictional) starts like this. Fields containing commas or line breaks, such as the To list and the body, are wrapped in double quotes so spreadsheet programs keep them in one cell.
The file begins with a UTF-8 byte order mark, which is what makes Excel show accented names and the pound sign correctly when you double-click it.
brightline-sales.mbox (5 messages) Preset: Full text
Date (UTC),From name,From address,To,Cc,Subject,Attachments,Attachment names,Size (bytes),Message ID,In reply to,Body 2026-02-03 09:12:00,Priya Shah,[email protected],Sam Patel <[email protected]>,,Re: Reminder texts for Northgate,0,,331,[email protected],,"Thanks Sam, yes please send the summary. Priya" 2026-02-03 11:40:00,Sam Patel,[email protected],Priya Shah <[email protected]>,,Summary and pricing,1,Brightline-summary.pdf,35223,[email protected],,"Hi Priya, attached is the one page summary. Sam"
Exporting a mailbox to CSV
Load the mailbox
An MBOX file, or a set of EML and MSG files, which are treated the same way. Up to 100,000 messages.
Pick a preset
Overview, no bodies leaves the Body column out. Full text includes it. Semicolons (European Excel) and Tab separated keep the body but change the separator.
Preview
The first 100 rows appear in a table, with long cells shortened for display only.
Download
Download CSV (or TSV for the tab preset), or use the Excel (XLSX) or JSON buttons for the same rows in another format.
Choosing the separator
| Preset | Separator | Use it when |
|---|---|---|
| Overview, no bodies | Comma | You want a light index of the mailbox |
| Full text | Comma | UK or US Excel, Google Sheets, most CRMs and databases |
| Semicolons (European Excel) | Semicolon | Excel on a computer set to a European region, where the comma is the decimal mark |
| Tab separated | Tab | Pasting into other tools, or bodies full of commas and semicolons |
What people use a mailbox CSV for
For a small business, a CSV of the sales or enquiries inbox is a quick way to answer questions the mail program cannot: how many enquiries came in each month, which companies wrote most, how long ago a prospect last replied. Sort by the From address column and filter by subject, and an afternoon of scrolling becomes a pivot table.
It is also the usual route into a CRM. Most CRMs import CSV and can match rows to contacts by email address, so a mailbox export can give each contact a history of dated conversations. If what you need is a list of people rather than messages, the mailbox contact extractor is the better tool: it gives one row per person with message counts.
- Body text is capped at 32,000 characters per message, inside the limit of a single Excel cell.
- HTML-only messages have their text extracted for the Body column.
Questions people ask
How do I convert an MBOX file to CSV?
Open the .mbox file on this page, choose Full text or Overview, no bodies, and press Download CSV. You get one row per message with the date, sender, recipients, subject, attachments, size, Message-ID and, if chosen, the body. Open it in Excel or Google Sheets, or import it into a CRM.
Why do accents look wrong when I open the CSV?
If a CSV has no marker saying it is UTF-8, Excel may read it in an older character set, which garbles accented letters and symbols. The comma CSV from this tool starts with a UTF-8 byte order mark to prevent that. If you still see odd characters, import the file through Excel's Data, From Text/CSV option and choose UTF-8.
Can I include the email body in the CSV?
Yes, with the Full text preset, which adds a Body column. Line breaks inside the body are kept within the quoted cell, so each email still occupies one row. Very long messages are cut at 32,000 characters. Choose Overview, no bodies for a smaller file when you only need the headers.
Does the CSV include attachments?
It includes the number of attachments and their file names for each message, but not the files themselves. To save the attachments, use the email attachment extractor, which also produces its own CSV list of every file with the sender and subject it came with.
Where your data goes
The rows are produced in your browser from the mailbox file you choose. No message, address or body text is uploaded, and the CSV, TSV, Excel or JSON file is saved straight to your device.
Checked against the tool on