Map Extract
Free tool

Convert MBOX to XLSM

Write a mailbox export as an .xlsm workbook, the macro-enabled flavour of modern Excel. It holds one Messages sheet with a row for every email, and is meant for teams whose reporting template, shared workbook or VBA routine is built around .xlsm files.

Runs in your browser. Nothing you enter is uploaded.

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.

Input
Enquiries week 45.mbox
Include the message body column: on
Result
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

  1. Choose the mailbox

    An MBOX export, or EML and MSG files, which are read the same way.

  2. Keep or drop the body

    Include the message body column adds each email's text, up to 32,000 characters per message.

  3. Check the listing

    Date, sender and subject for the first 50 messages confirm what was read.

  4. 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

Top