A structured CSV (or Excel, JSON, or XML) file containing one row per email, with columns for From, To, CC, BCC, Subject, Date, and Body. Attachments optionally extracted to a separate folder. Everything processed on your Mac — Google Takeout is the only internet step.
Why convert Gmail to CSV
Once Gmail is a CSV, you can do things that are impossible inside Gmail itself:
- Analyze senders and recipients — pivot by domain, find everyone who emailed you in 2024, rank correspondents by volume.
- E-discovery and legal hold — produce a defensible, tabulated export for review.
- Migration planning — before switching providers, audit what is actually in your mailbox.
- Research corpora — feed years of email into NLP, sentiment analysis, or academic datasets.
- Personal archiving — a single CSV of every email you sent last year is a more useful record than a mailbox.
Not sure what MBOX is or why Google uses it? Read the MBOX format reference →
Step 1 — Open Google Takeout
Go to takeout.google.com and sign in with the Google account whose Gmail you want to export. Takeout is Google's official self-service data portability tool — it is free, unlimited, and the cleanest way to get your Gmail out.
Step 2 — Select only Mail
By default Takeout includes everything — Photos, Drive, YouTube, Chrome history, and 40+ other products. You almost certainly do not want all of that.
- Click Deselect all at the top of the product list.
- Scroll down to Mail and check only that box.
- Click All Mail data included if you want to narrow to specific labels. You can select labels like Inbox, Sent, a specific custom label, or combine several.
Selecting specific labels is useful if you only need a subset — for example, exporting just a project-specific label rather than your entire archive.
Step 3 — Choose export format
Scroll to the bottom of the product list and click Next step. You will see delivery options:
- Delivery method — "Send download link via email" is the simplest. Takeout emails you when the archive is ready.
- Frequency — "Export once". The recurring option is for scheduled backups.
- File type & size — leave as
.zip. For file size, 2 GB is a good default; larger archives get split across multiple ZIPs.
Click Create export. Google queues the job and emails you when it finishes.
Step 4 — Wait for Google to prepare the archive
This is the slowest step and the only one you cannot speed up:
- A small Gmail account (< 5 GB): typically 30 minutes to 2 hours.
- A medium account (5–30 GB): typically 2–6 hours.
- A large account (30+ GB, many years of history): sometimes 12–24 hours.
You can close the tab and leave your Mac. Google sends a download email when it is done. The link is valid for 7 days, and you can re-request the archive if you miss that window.
Step 5 — Download and unzip the archive
Click the download link in the email. Safari or your default browser will save the file to ~/Downloads. Double-click the .zip to extract. Inside, the folder structure looks like:
Takeout/
└── Mail/
├── All mail Including Spam and Trash.mbox
└── (or one .mbox per label, if you picked specific labels)That .mbox file is what you convert.
Step 6 — Open MBOX to CSV Data Extractor
Install MBOX to CSV Data Extractor from the Mac App Store. It is free for MBOX files under 50 MB; a one-time $9.99 in-app purchase unlocks unlimited file size. No subscription.
Launch the app. You can either:
- Drag the
.mboxfile from Finder directly into the app window, or - Click the file picker and navigate to
~/Downloads/Takeout/Mail/.
Step 7 — Convert to CSV (or Excel, JSON, XML)
- Pick your output format. For spreadsheet analysis, use CSV (universal) or Excel (.xlsx, with formatted columns).
- Optionally enable Extract attachments to save every attachment to a folder.
- Optionally set Split output with a record-per-file limit (useful for very large archives).
- Click Convert and choose a destination folder.
The app streams the MBOX file, so even a 10 GB Gmail archive is processed without loading everything into memory. Your CSV or Excel file appears in the destination folder and is ready to open in Numbers, Excel, Google Sheets, or any text editor.
Tips for very large Gmail archives
- Split the output. A single CSV with a million rows will open, but it is painful. Set "records per file" to 50,000 or 100,000 and the app produces a set of easier-to-handle files.
- Prefer Excel (.xlsx) for < 1M rows. Excel has a hard 1,048,576-row limit per sheet. Above that, CSV is required.
- Use label-specific exports. If you only need a subset of your mailbox, export only the relevant labels from Takeout rather than your entire archive. Smaller MBOX = faster conversion = smaller CSV.
- Disable attachment extraction for metadata-only analysis. If you only need sender/subject/date stats, skipping attachments speeds conversion significantly.
- Keep the original MBOX. If you ever need to re-convert with different settings, you will not want to request a fresh Takeout archive.
FAQ
How long does Google Takeout take to export Gmail?
It depends on account size. A small account is ready within 30 minutes. A 30+ GB account can take 6–24 hours. Google emails you when the archive is ready.
What does the Google Takeout Gmail archive contain?
A single .mbox file (or several, if you split by label) containing every email in the labels you selected. Each message includes full headers, the body (HTML and plain text), and inline attachments Base64-encoded. If you selected "All Mail", the archive contains every email in your account including Spam and Trash.
Can I convert only specific Gmail labels to CSV?
Yes. In Google Takeout, under Mail options, choose "Select labels" and pick only the labels you want. Google produces a separate .mbox file per label.
My Gmail archive is 15 GB. Will it work?
Yes. MBOX to CSV Data Extractor uses streaming parsing — it does not load the entire file into memory. Multi-gigabyte Gmail archives are a supported use case. You can also split the output into multiple files with a configurable record count.
Will my Gmail data be uploaded anywhere during conversion?
No. The MBOX file and all extracted data stay on your Mac. The app has no network component. You can disconnect from the internet before converting if you want to verify this — see MBOX to CSV vs online converters for why this matters.
What fields end up in the CSV?
By default: From, To, CC, BCC, Subject, Date, and Body. Dates are standardized. HTML is stripped so the Body column is plain text. MIME and Base64 encoded characters are decoded automatically. You can customize which fields are included in the app's settings.
Can I also extract attachments from the Gmail archive?
Yes. Enable the "Extract attachments" option before converting. The app saves every attachment to a dedicated folder alongside the CSV, with filenames that reference the source message.
Related
Ready to convert your Gmail archive?
Free for MBOX files under 50 MB. 100% offline — your emails never leave your Mac.
Download on the App Store