The three sheets
| Sheet | One row per | Columns |
|---|---|---|
| Messages | Sending date in UTC, sender name and address, the To and Cc lists, subject, how many files are attached and their names, size in bytes, Message-ID and the ID it replies to, with the body added when ticked | |
| Contacts | Address | Email, Name, First name, Last name, Domain, Type, Sent to you, Received from you, Total messages, First seen, Last seen |
| Attachments | Attached file | Date (UTC), From, Subject, File name, Type, Size (bytes) |
Building the workbook
Load the mailbox
Choose an MBOX file, or EML and MSG files. Up to 100,000 messages.
Choose a workbook preset
Full workbook has all three sheets and the body text. Message index, no text has only the Messages sheet without bodies. Contacts and attachments drops the bodies but keeps all three sheets.
Adjust the sheets
Tick or untick the message text column, the Contacts sheet and the Attachments sheet independently.
Download
Download XLSX gives one workbook with bold header rows. CSV files (ZIP) gives each sheet as its own UTF-8 CSV.
Example: the Attachments sheet
For a five-message sales mailbox (fictional) the Attachments sheet lists the three files sent or received, so it is easy to see that the April invoice came from an automated sender and that the till screenshot went out with a reply. Inline images such as signature logos are not listed.
brightline-sales.mbox Preset: Full workbook
Date (UTC) From Subject File name Type Size (bytes) 2026-02-03 11:40:00 [email protected] Summary and pricing Brightline-summary.pdf application/pdf 26000 2026-04-01 06:00:00 [email protected] Your April invoice invoice-0426.pdf application/pdf 4500 2026-04-02 09:15:00 [email protected] Re: Booking widget question till-setup.png image/png 28000
Getting answers out of the workbook
Because each sheet is a clean table with a header row, Excel's filters and pivot tables work straight away. A pivot on the Messages sheet by month and From address shows who you were talking to over time. Sorting the Contacts sheet by Last seen shows which customers or prospects have gone quiet, which is often the most useful list a sales mailbox can give you.
On the Contacts sheet, Sent to you counts messages that person sent, and Received from you counts messages you sent them in To or Cc. The Type column separates business addresses, free mail and shared inboxes such as info@, so you can filter to company contacts before importing them anywhere.
Questions people ask
How do I convert an MBOX file to Excel?
Open the .mbox file here and press Download XLSX. You get a workbook with a Messages sheet, plus Contacts and Attachments sheets unless you untick them. It opens in Excel, Google Sheets, Numbers and LibreOffice Calc. Messages are read in your browser and the workbook is built there.
What is the difference between this and MBOX to CSV?
MBOX to CSV produces one table, one row per message, in comma, semicolon or tab format. This converter produces a workbook with up to three related sheets, including a contacts summary and an attachment list, and can also give each sheet as a separate CSV in a ZIP.
Is my own address included in the Contacts sheet?
In this workbook every address found in the From, To, Cc, Bcc and Reply-To fields is included, so yours will usually be at the top with the most messages. Delete that row, or use the mailbox contact extractor, which detects your own address and leaves it out.
Can Excel cope with a very large mailbox?
An XLSX sheet can hold just over a million rows, so the message count is rarely the problem. File size is: body text makes a workbook large and slow to open. For big mailboxes choose Message index, no text, or Contacts and attachments, which leave out the bodies.
Where your data goes
The workbook is assembled in your browser from the mailbox you open. Messages, contacts and attachment details are not uploaded, and the XLSX or ZIP of CSV files is saved directly on your computer.
Checked against the tool on