How to Export and Convert Email Archives to Excel


MBOX is a widely used format for email archives. This guide explains how to export your emails and convert them into a spreadsheet for analysis.


Why convert emails to a spreadsheet?


Email archives in spreadsheet form are useful for legal discovery and compliance, email migration planning, communication audits, analyzing email patterns and volumes, and archival indexing.


Exporting from Gmail via Google Takeout


  • Go to takeout.google.com.
  • Click "Deselect all" to clear all products.
  • Scroll down and check "Mail."
  • Click "All Mail data included" to choose specific labels if needed.
  • Click "Next step" and choose your export options.
  • Click "Create export" and wait for the download link.
  • Download and extract the archive. The MBOX file will be inside.

    • Exporting from Thunderbird


    Thunderbird stores emails as MBOX files by default. You can find them in your profile folder. On most systems, the path is something like: ~/.thunderbird/[profile]/Mail/Local Folders/


    Exporting from Apple Mail


  • Open Mail on macOS.
  • Select the mailbox you want to export in the sidebar.
  • Go to Mailbox > Export Mailbox.
  • Choose a save location.

    • Understanding the output


    The converter extracts: Date, From, To, Subject, CC, and Message ID. This gives you a complete index of your email archive that you can sort, filter, and search.


    Tips


  • Sort by Date to see emails in chronological order.
  • Filter by From to find all emails from a specific sender.
  • Use COUNTIF on the From column to see who sends the most email.
  • The Message ID column is useful for tracking specific email threads.
    • Back to MBOX Email converter