Export Gmail Emails to Excel and CSV, Download Gmail Emails, and Back Up a Gmail Mailbox
Pick a label, get every message back as rows: date, sender, subject, body, and the fields inside the body.
Google will hand you your Gmail, but not in a shape a spreadsheet understands. Google Takeout exports mail as MBOX, a single concatenated text file that Excel cannot open and that most people end up hunting for a viewer to read. Per-message downloads give you .eml files that need a desktop mail client. Neither produces the thing people actually ask for when they say they want to export Gmail emails: a list they can sort, filter, count, and hand to somebody. Connect the mailbox here and take a label as Excel, CSV or JSON instead.
Last updated August 2026
Connect a mailbox to pull .eml/.msg in bulk, or paste a raw email to test the converter now.
Create a free account to download. No credit card required.
Gmail has no built-in export to Excel or CSV. Google's own route is Google Takeout, which returns your mail as an MBOX file with each message's labels preserved in an X-Gmail-Labels header, delivered as a link that expires in about 7 days and can be downloaded 5 times. Individual messages come out as .eml through More > Download message or More > Forward as attachment. MailParse connects to the Gmail or Google Workspace mailbox directly and returns the label you point it at as a spreadsheet: one row per message, with the body parsed into named columns instead of one cell.
- MBOX
- The only format Takeout gives you for mail
- 7 days
- Google states a Takeout archive expires in about a week
- One file
- A whole label exports as a single sheet
- XLSX/CSV/JSON
- Formats Excel, Sheets and scripts read
Ask ten people what they mean by "export Gmail emails" and you get three different jobs. Some want a backup: an account is closing, someone is leaving, or a lawyer asked for a preserved copy, and the requirement is that the mail survives as mail. Some want a list: how many enquiries came in last quarter, from whom, on what dates, so it can be counted in a pivot table. And some want the data inside the messages: the order numbers, totals, ticket references and lead details that arrive in the same shape a hundred times a month. Google built for the first job. It tolerates the second badly and does not address the third at all.
The official route is Google Takeout at takeout.google.com. Deselect everything, select Mail, and choose whether you want all mail or specific labels. Google then queues the job and delivers the archive one of five ways: a download link by email, or straight into Google Drive, Dropbox, Microsoft OneDrive or Box. Google says the process can take anywhere from a few minutes to a few days, and that most people get the link the same day they ask. It also states that an archive expires in about 7 days and that each archive can be downloaded 5 times, which catches out anyone who requests one on a Friday and gets to it a fortnight later.
What arrives is an MBOX file, sometimes several if you set a smaller maximum archive size. MBOX is one plain text file with every message concatenated inside it, and Gmail's labels are preserved in a custom X-Gmail-Labels header on each message, which most mail clients quietly ignore. Double-click it on Windows and nothing sensible happens. Excel will not open it. To read it you install a mail client that imports MBOX, or you go looking for a viewer, and either way you have swapped the problem of getting the mail out for the problem of getting into the file it came in.
For a single message, Gmail is much more direct. Open the message, click More, then Download message, and you get an .eml file, though Google notes plainly that you need a desktop mail client to open it. To grab several at once, tick the messages in the list, click More, then Forward as attachment, and each one rides along as an .eml. That is a workable way to pull twenty order confirmations out of an inbox, and it is the route to use if you want to feed saved files into a converter rather than connect an account.
MailParse takes the file format out of the middle. Connect the Gmail or Google Workspace account, or any mailbox over IMAP, choose the label and a date range, and download the result as Excel, CSV or JSON. Every message becomes a row carrying its date, sender, recipients and subject, and the body is parsed rather than dumped: if the messages are shipping notices, the tracking number and carrier come back as their own columns; if the body contains an HTML table of line items, each table row becomes a spreadsheet row you can total.
Two limits worth stating before you start, because both are real. This does not split an MBOX archive, so if Takeout has already run and the MBOX is what you have, that file needs a mail client or a dedicated MBOX tool first. And it reads the message body, its HTML tables and attachment filenames, but does not open the data locked inside an attached PDF or spreadsheet. If your requirement is a legally faithful archive of mail as mail, keep Takeout's MBOX or, in Google Workspace, use Google Vault, which exports in mbox or PST.
What a spreadsheet export gives you that Takeout does not
Takeout was built to move your mail out of Google. This is built to produce a file somebody can work in on the day they ask for it.
No MBOX file to wrestle with
Takeout only offers MBOX for Mail, and MBOX is a single concatenated text file that Excel and Google Sheets cannot open. Skipping it entirely removes the step where most Gmail exports stall: finding something that will read the archive you just waited for.
The body becomes columns, not one cell
Any flat export puts the whole message body in a single field. If every message carries an order number, a delivery date and a total, you get those as separate columns instead, which is the difference between a file you can pivot and a file you have to read line by line.
HTML tables come back as rows
Order confirmations, booking notices and automated reports are usually HTML tables. Flattened to text they turn into a run of characters. Parsed properly, a message containing eight line items produces eight rows you can sum.
Labels and date ranges, not all-or-nothing
Point at one label for one quarter rather than exporting the entire account. Narrower exports finish faster, are easier to check, and avoid handing somebody years of correspondence they never asked for.
No waiting for a queued job
Google warns a Takeout archive can take from a few minutes to a few days and expires in about 7 days once it exists. A label export here finishes while you wait, and can be repeated next month without re-requesting anything.
It repeats without a script
The Apps Script route works until the person who wrote it leaves or the quota changes. Setting a label and a field list once is something anyone on the team can run again next quarter.
How to export Gmail emails to Excel
Four steps, and none of them involve opening an MBOX file.
Connect the mailbox or upload the files
Connect a Gmail or Google Workspace account, or any mailbox over IMAP with a host, username and app password. If you already saved messages using More then Download message, or received them through Forward as attachment, upload those .eml files instead.
Choose the label and the range
Pick the label you want exported, Inbox, Sent, or a label you created for the project, and narrow it by date if a single quarter is all the question needs.
Name the columns you want
Date, from, to and subject come as standard. Add the values that live inside the body by naming them, such as order_number, invoice_total, tracking_number or due_date, and they are found across differing sender layouts.
Download as Excel, CSV or JSON
Take XLSX to open straight in Excel, CSV to import into anything including Google Sheets, or JSON if the destination is a script, a database or an API. The whole label arrives as one file.
Who exports a Gmail mailbox, and what they do with it
Four requests that come up constantly, and the format each one actually needs.
Offboarding and account closure
Someone leaves and their Google Workspace mailbox has to be preserved before the license is released. Keep an MBOX or a Vault export for the faithful archive, and take a spreadsheet alongside it so the team can search what was in there without importing anything.
Reporting on a shared or team inbox
Sales, support and purchasing addresses get asked how many requests came in, from whom, and how fast they were answered. A label exported to Excel with date, sender and subject columns answers that in one pivot table.
Turning recurring notifications into a dataset
Order confirmations, payment alerts, booking notices and monitoring reports carry the same fields in every message. Exporting them as parsed columns turns a year of mail into something you can chart instead of something you have to read.
Records requests, audit and handover
When an auditor or an incoming account manager asks for the correspondence on a customer, a dated spreadsheet of every message with subject and sender is faster to hand over and far easier to review than mailbox access.
Why not just use Google Takeout
It skips the format problem
Takeout hands back MBOX, which Excel and Sheets cannot open. XLSX, CSV and JSON open everywhere on the first try.
Minutes, not a queued job that expires
Google states a Takeout archive can take from minutes to days, expires in about 7 days, and allows 5 downloads. A label export finishes while you wait and can be repeated any time.
A list, not an archive
Takeout preserves mail as mail. If the question is how many, from whom, and how much, you need rows and columns, and that is a different output.
Where Takeout wins
For a complete, faithful copy of every message including attachments and label metadata, Google's own export is the right tool. Use it for the archive, and use this for the data.
Five ways to get Gmail into a usable file
An honest comparison of the routes, including the two cases where you should not use us. If your messages are already saved to disk as files, the EML to Excel converter and the EML to CSV converter handle files rather than mailboxes.
| Method | What it gives you | Where it breaks |
|---|---|---|
| Google Takeout (Mail) | Every message in the labels you choose, as MBOX, with labels kept in an X-Gmail-Labels header | MBOX opens in a mail client, not in Excel; the archive expires in about 7 days and allows 5 downloads |
| Gmail: More > Download message | One .eml file per message, straight from the message you are reading | One at a time, and Google notes you need a desktop mail client to open the file |
| Gmail: More > Forward as attachment | Several messages at once as .eml attachments, with no download limit on how many you attach | Still .eml files rather than a spreadsheet, and you have to select the messages by hand |
| Google Vault (Workspace only) | A defensible, administrator-run export in mbox or PST across accounts | Needs Vault access and administrative rights; splits into zip files above 1 GB for PST and 10 GB for mbox |
| MailParse | A whole label as XLSX, CSV or JSON, with body fields and HTML table rows as columns | Not an MBOX or PST archive, does not split an existing MBOX file, and does not read data locked inside attached files |
Gmail and Google Takeout behavior described here reflects Google's published guidance as of August 2026: Takeout delivery by email link, Google Drive, Dropbox, Microsoft OneDrive or Box, an archive that Google states expires in about 7 days with a limit of 5 downloads, an export that can take from a few minutes to a few days, labels preserved in an X-Gmail-Labels header, the Gmail More > Download message and More > Forward as attachment routes that produce .eml files, and Google Vault exports named as mbox or PST that split into zip files above 1 GB for PST and 10 GB for mbox. Google ships changes regularly, so check your own account before you plan around it. Google, Gmail, Google Workspace, Google Drive and Google Sheets are trademarks of Google LLC. MailParse is not affiliated with Google.
Frequently asked questions
How do I export emails from Gmail?
Google's own route is Google Takeout: go to takeout.google.com, deselect everything, select Mail, choose all mail or specific labels, and request the archive. Google delivers it by email link or to Drive, Dropbox, OneDrive or Box. The output is an MBOX file. For a spreadsheet instead, connect the mailbox to a parser and export the label directly.
How do I export all my Gmail emails to Excel?
There is no built-in path. Gmail exports mail as MBOX through Takeout and as .eml per message, and Excel opens neither. The working route is to connect the Gmail account to a parser, choose the label and date range, and download XLSX or CSV with one row per message and the body split into named columns.
What format does Google Takeout export Gmail in?
MBOX. It is a single plain text file with every message concatenated inside it, and Gmail preserves each message's labels in a custom X-Gmail-Labels header that most mail clients ignore. If you set a smaller maximum archive size, Takeout splits the export across several files rather than changing the format.
How long does Google Takeout take to export Gmail?
Google states the process can take from a few minutes to a few days depending on how much is in the account, and that most people get the link to their archive the same day they request it. Google also states the archive expires in about 7 days and can be downloaded 5 times, so collect it promptly.
How do I save a Gmail email to my computer?
Open the message, click More, then Download message. Gmail saves it as an .eml file, and Google notes you need a desktop mail client to open it. To save several at once, tick them in the list, click More, then Forward as attachment, and each message travels as its own .eml.
How do I back up my Gmail emails?
For a true backup, run Google Takeout and keep the MBOX archive somewhere durable, remembering that the download link expires in about 7 days. Google Workspace administrators can run a Vault export instead, which produces mbox or PST. Keep the archive for preservation and export a spreadsheet separately if you also need to read what is inside.
How do I export Gmail to CSV?
Gmail has no CSV export for mail; the CSV option in Google Contacts covers contacts, not messages. To get messages as CSV, either connect the mailbox to a parser and export the label, or save the messages as .eml files first and convert those. Either way you choose the columns rather than accepting a fixed field set.
Can I export a single Gmail label?
Yes, and it is usually the better choice. Takeout lets you pick specific labels rather than all mail, which keeps the archive small and quick. Exporting to a spreadsheet works the same way: point at one label and narrow it by date, so you get the quarter somebody asked about instead of the whole account.
Does exporting Gmail include attachments?
A Takeout MBOX keeps attachments inside the archive, because MBOX stores the full message. A spreadsheet export does not embed files. MailParse records each attachment by filename, type and size next to its message so the audit trail survives, but it parses the message body and its HTML tables rather than the contents of an attached PDF.
How do I open an MBOX file from Google Takeout?
You need software that imports MBOX, typically a desktop mail client such as Thunderbird, or a dedicated MBOX viewer. Excel and Google Sheets will not open one. MailParse does not split an existing MBOX file either, so if the archive already exists, read it in a mail client and export the messages you need as .eml.
Can I export Gmail emails automatically every month?
Yes. Connect the mailbox once, set the label and the fields you want, and every new message that arrives is parsed into the same columns. Pulling the current month becomes a download rather than a project, which is the difference between a standing export and re-running Takeout each time.
Take the label, not the MBOX
Connect a Gmail, Google Workspace or IMAP mailbox and download a whole label as Excel, CSV or JSON, with the body parsed into columns rather than flattened into one cell.