Saving a mailbox as XLS
Open the mailbox
Choose an MBOX file from Gmail Takeout, Thunderbird or Apple Mail; EML and MSG files are accepted too.
Decide on the body column
Include the message body column is ticked by default. Untick it for a smaller file containing only the header details.
Check the preview
The date, sender and subject of the first 50 messages are listed so you can confirm the right mailbox loaded.
Download
Download Excel 97 (XLS) saves the workbook with a single Messages sheet. A Message index (CSV) is offered as well.
Example: an enquiries mailbox for an older CRM
A family-run kitchen fitter (fictional) still uses a CRM installed many years ago whose import screen accepts only .xls. It exports the enquiries label from Google Workspace and converts it here with the body column left out, because the CRM only needs date, sender and subject.
Each message becomes one row on the Messages sheet with the date in UTC, the sender's name and address, recipients, subject, attachment count and names, size and Message-ID.
Enquiries.mbox Include the message body column: off
Date (UTC) From name From address Subject 2026-02-03 09:12:00 Priya Shah priya@northgate-dental.example Re: Reminder texts for Northgate 2026-03-16 15:02:00 Tom Reed tom@harbourcafe.example Booking widget question Saved as: Enquiries.xls
XLS compared with XLSX
| XLS (Excel 97-2003) | XLSX (Excel 2007 and later) | |
|---|---|---|
| Rows per sheet | 65,536 | 1,048,576 |
| Columns per sheet | 256 | 16,384 |
| File structure | Binary compound file | Zipped XML |
| Opened by | Every Excel version, most spreadsheet apps, many legacy importers | Excel 2007 onwards, Google Sheets, LibreOffice, Numbers |
Big mailboxes and the row limit
Because an XLS sheet stops at 65,536 rows, a mailbox with more messages than that will not fit in one file. Split it first with the MBOX splitter, by year or by message count, and convert each piece. Long bodies are another source of bloat; leaving the body column out keeps an XLS small enough for older programs to open quickly.
Dates are written as text in the form 2026-02-03 09:12:00, in UTC. That avoids the day and month swapping that happens when older software reads a date in the wrong regional format, and it still sorts correctly.
Questions people ask
How do I convert MBOX to XLS?
Open the .mbox file on this page, choose whether to include the body column and press Download Excel 97 (XLS). The workbook has one sheet called Messages with a row for each email. It opens in any version of Excel, including 2003 and earlier, and in most spreadsheet programs.
What is the difference between XLS and XLSX?
XLS is the binary Excel format used up to Excel 2003; XLSX is the zipped XML format introduced in Excel 2007. XLSX holds many more rows and columns and is better supported today. XLS remains useful only for older programs and import tools that do not understand XLSX.
What if my mailbox has more than 65,536 messages?
One XLS sheet cannot hold them all. Split the mailbox first, for example one file per year with the MBOX splitter, then convert each part to XLS. Alternatively use XLSX, which allows over a million rows on a sheet.
Does the XLS include attachments or contacts?
No. It has one Messages sheet listing each email's attachment count and file names. For a workbook with separate Contacts and Attachments sheets, use the MBOX to Excel (XLSX) converter; to save the attached files themselves, use the email attachment extractor.
Where your data goes
The mailbox is parsed and the XLS is written by a spreadsheet library running in your browser. Your emails are not sent anywhere, and the workbook goes straight to your downloads.
Checked against the tool on