Export Apple Mail to CSV on Mac

Why export Apple Mail to CSV

Apple Mail is great at reading email. It is not great at answering questions like "who sent me 50+ emails in 2025?" or "how many of my sent emails last year had attachments?" or "export every email from this client so I can import them into a CRM."

A CSV export turns your mailbox into a spreadsheet. Every sender, recipient, subject, and date becomes sortable, filterable, and pivot-able in Numbers, Excel, or any data tool.

Step 1 — Open Mail and pick a mailbox

Launch Mail from /Applications (or Spotlight). In the sidebar, click the mailbox you want to export:

• An account inbox (e.g. your Gmail or iCloud Inbox)
• Your Sent folder
• An Archive or custom folder
• A Smart Mailbox you've defined (works the same as a regular mailbox for export)

Step 2 — Mailbox > Export Mailbox

With the mailbox selected, go to the menu bar:

Mailbox  →  Export Mailbox…

If the option is grayed out, no mailbox is selected — click Inbox (or any folder) first. You can also Cmd-click multiple mailboxes in the sidebar to export several at once.

Step 3 — Pick a destination

A standard Save dialog appears. Pick any folder — Desktop, Downloads, an external drive, it all works. Click Choose.

Mail creates a folder (or files) named after each mailbox you selected, with .mbox at the end. A single-mailbox export produces one Inbox.mbox (or whatever the mailbox was called).

Step 4 — Understand the .mbox package

Here's the quirk: Apple Mail's .mbox is a macOS package, not a plain file. In Finder it shows up as a single item with an icon, but it's actually a folder with an extension that macOS treats as a single bundle.

To see what's inside, right-click the .mbox item and choose Show Package Contents. You'll find:

• A file called mbox (no extension) — this is the actual message store in standard MBOX format.
• Some .plist and Info.plist metadata that Apple Mail uses.
• An Attachments/ folder with cached attachments (depending on account settings).

MBOX to CSV Data Extractor accepts either the outer .mbox package or the inner mbox file — you don't have to crack it open yourself. But knowing the structure helps if you ever need to inspect the raw data.

Step 5 — Convert to CSV

1. Install MBOX to CSV Data Extractor from the Mac App Store (free for files under 50 MB).
2. Drag the .mbox package into the app window.
3. Pick CSV, Excel, JSON, XML, or TXT. Optionally enable attachment extraction.
4. Click Convert, pick a destination, done.

Tips and gotchas

• Let Mail finish syncing. If your mailbox is IMAP or iCloud, make sure Mail has fully downloaded messages before exporting. Click through the mailbox or force a sync (Mailbox > Get All New Mail) first — otherwise the export may miss attachments or even message bodies stored only on the server.
• Smart mailboxes are a shortcut. Create a smart mailbox like "From: [email protected], Date: 2025" to export only the slice you need. No need to dig through folders manually.
• Multi-mailbox exports. Select multiple mailboxes (Cmd-click in sidebar) and Export Mailbox creates one .mbox per selected item.
• Size sanity check. The exported .mbox package size roughly equals the sum of message sizes — including attachments, which are Base64-encoded and add ~33%. A 200 MB mailbox often becomes a 250 MB .mbox.
• Internal storage lives at ~/Library/Mail/. Advanced users can skip the export step entirely and convert files directly from there, but the exported bundle is cleaner and self-contained.

FAQ

Related

• What is an MBOX file? →
• Convert Gmail Takeout to CSV →
• Convert Thunderbird MBOX to CSV →
• Convert MBOX to Excel →