Example: feeding a weekly enquiries report
An office manager at a lettings agency (fictional) keeps a macro in her personal workbook that tidies an enquiries sheet and builds a weekly summary. The macro was written to open .xlsm files from a set folder. She exports the week's enquiries folder from Thunderbird, converts it here with the body column included, and saves the result in that folder.
The workbook has one sheet named Messages, with the same columns as the other spreadsheet exports on this site, so the macro's column references stay the same week to week.
Enquiries week 45.mbox Include the message body column: on
Download Excel macro (XLSM): Enquiries week 45.xlsm Sheet: Messages Columns: Date (UTC), From name, From address, To, Cc, Subject, Attachments, Attachment names, Size (bytes), Message ID, In reply to, Body
Creating the XLSM
Choose the mailbox
An MBOX export, or EML and MSG files, which are read the same way.
Keep or drop the body
Include the message body column adds each email's text, up to 32,000 characters per message.
Check the listing
Date, sender and subject for the first 50 messages confirm what was read.
Download the workbook
Press Download Excel macro (XLSM). The file is named after the mailbox. A CSV message index is also available.
When XLSM is the right choice
Use it when a process downstream is strict about the extension: a macro that loops over .xlsm files in a folder, a SharePoint library or shared drive rule that only accepts macro-enabled workbooks for a particular report, or a template that colleagues are used to opening. In each case the data has to arrive in the expected shape, and having the converter write the right file type saves a manual Save As step every time.
If you are building something new, a plain XLSX or CSV is easier to share, because some email systems and security policies block macro-enabled attachments regardless of whether they contain code. Recipients outside your organisation may never see an .xlsm you send them.
- The Messages sheet has one row per email; the Contacts and Attachments sheets of the XLSX converter are not part of this file.
- To run your own macro on the data, open your macro workbook and point it at this file, or copy the sheet in.
Questions people ask
What is an XLSM file?
An XLSM file is an Excel workbook in the Office Open XML format that is allowed to contain VBA macros. It looks and behaves like an XLSX in Excel. Files saved by this converter have the .xlsm extension and structure but contain only data, so there is no macro to enable when you open them.
Why would I convert MBOX to XLSM instead of XLSX?
Only when something you already use requires the .xlsm extension, such as a VBA routine that opens macro-enabled files from a folder, or a document library that expects them. In every other case XLSX is simpler to share, since some mail filters and security policies block macro-enabled attachments.
Will Excel show a security warning?
Excel's macro warnings are about code inside a workbook, and this file has none. What Excel does show depends on your organisation's settings, for example a protected view banner for files downloaded from the internet. That is normal for any downloaded spreadsheet and can be cleared once you trust the file.
Can I add my own macros to the file afterwards?
Yes. Open it in Excel for Windows or Mac, open the Visual Basic editor and add a module, then save. Because the file is already .xlsm, Excel keeps the macro when you save it, which it would not do with an .xlsx.
Where your data goes
Every message is read and the workbook built locally in your browser. No mailbox content is uploaded, and the XLSM file is created on your machine with data only and no code.
Checked against the tool on