Converting to ODS
Choose the mailbox file
MBOX exports from Gmail Takeout, Thunderbird and Apple Mail are supported, and EML or MSG files can be used instead.
Include or leave out the body
The body column is included by default. Leaving it out gives a compact index of dates, senders, recipients and subjects.
Confirm the messages
A table lists the date, sender and subject of the first 50 messages read.
Download the spreadsheet
Download OpenDocument (ODS) saves the file named after the mailbox. A CSV index of the messages is offered as a second option.
Example: a parish council clerk's correspondence
A part-time clerk (fictional) works on a council laptop with LibreOffice and needs a register of the year's planning correspondence for the members. The planning folder was exported from Thunderbird as an MBOX.
Converting it with the body column included gives an ODS that opens directly in Calc. Freeze the header row, filter the From address column by applicant and the register is ready to attach to the agenda.
Planning 2025-26.mbox Include the message body column: on
Download OpenDocument (ODS): Planning 2025-26.ods Sheet: Messages One row per email: Date (UTC), From name, From address, To, Cc, Subject, Attachments, Attachment names, Size (bytes), Message ID, In reply to, Body
Why OpenDocument
ODS is part of the OpenDocument Format, an international standard (ISO/IEC 26300) not tied to one company's software. The UK government adopted ODF as its standard for sharing and collaborating on editable documents, so councils, schools, charities and suppliers to public bodies often meet it. LibreOffice, Collabora, OnlyOffice and Google Sheets open ODS files, and so does Microsoft Excel.
For a small business the main reason is simpler: if you use LibreOffice rather than Microsoft 365, an ODS opens natively with no conversion prompt, formatting is preserved when you save, and you avoid the round trip through CSV that loses column widths and turns long numbers into scientific notation.
Which spreadsheet export to choose
| You work in | Choose |
|---|---|
| LibreOffice Calc or another ODF suite | ODS |
| Excel 2007 or later, Google Sheets | XLSX, which adds Contacts and Attachments sheets |
| Excel 2003 or a legacy importer | XLS |
| A CRM import or a database | CSV |
| A VBA routine expecting macro-enabled files | XLSM |
Questions people ask
How do I open an MBOX file in LibreOffice?
LibreOffice cannot read MBOX directly. Convert it here to ODS and open the result in LibreOffice Calc, where every email is a row you can sort and filter. If you want the messages as a readable document rather than a table, convert to ODT and open it in LibreOffice Writer.
Can Excel open ODS files?
Yes. Current versions of Excel open and save ODS, although some advanced formatting can differ between programs. For a table of emails with plain text cells this makes no practical difference. If the people you share with all use Excel, XLSX is still the more natural choice.
Is ODS better than CSV for emails?
For people reading the data, usually yes. An ODS keeps the cells as text, so Message-IDs and long numbers are not reformatted, and multi-line bodies stay in one cell without quoting issues. CSV is better when the file is going into another system, such as a CRM import, rather than being read in a spreadsheet.
Does the ODS include a contacts list?
No, it has one Messages sheet. To get a list of people with message counts, use the mailbox contact extractor, which can export CSV or XLSX; LibreOffice opens both. The MBOX to Excel converter also builds Contacts and Attachments sheets alongside the messages.
Where your data goes
Reading the mailbox and writing the ODS both happen inside your browser with a spreadsheet library delivered with the page. No email is uploaded, and the file is saved on your own device.
Checked against the tool on