Google Takeout Gmail Export: What You Actually Get

Takeout is the answer everyone gives when somebody asks how to get their mail out of Gmail, and it is the right answer to a narrower question than most people are asking. If you want a complete copy of your mail preserved as mail, Takeout does that well and for free. If you wanted a list of who emailed you last quarter, or the order numbers out of two years of confirmations, Takeout hands you a file that makes the job harder, not easier. It is worth knowing which of those you are doing before you spend a day waiting for an archive.

What Google Takeout actually exports for Gmail

Go to takeout.google.com, click Deselect all, tick Mail, and you can either take everything or open the options and pick specific labels. That label selector is the single most useful control on the page, and most people scroll past it.

The output is MBOX. Not CSV, not XLSX, not PDF, not PST. MBOX is a plain text container: every message in the selection is concatenated into one file, each one beginning with a line that starts with the word From at the beginning of a line. It is an old, well-supported format, and its virtue is completeness. Headers, body, encoding, attachments, all of it survives intact, which is exactly what you want from an archive.

Gmail adds one thing on the way out. Because labels do not exist in standard mail, Gmail writes them into a custom header called X-Gmail-Labels on each message. Most mail clients ignore that header entirely, so if you import the archive into a desktop client, expect your careful label structure to arrive as one flat pile of messages. The information is in the file. Almost nothing reads it.

The four options Takeout asks you to choose

Before the job runs, Google asks four questions, and the defaults are not always what you want.

Delivery. Five choices: send a download link by email, or add the archive to Google Drive, Dropbox, Microsoft OneDrive or Box. Sending it to Drive is convenient right up to the point where a large mail archive eats the storage quota you were exporting in order to free up.

Frequency. Either a one-time archive, described by Google as a single archive of your selected data, or a scheduled export that automatically creates an archive every 2 months for one year. The scheduled option is genuinely useful for a rolling personal backup and almost nobody knows it exists.

File type. Zip or tgz. Google notes that zip files can be opened on almost any computer, and that you may need additional software to open tgz files on Windows. Take zip unless you have a reason not to.

Maximum archive size. You pick a ceiling, and if the data is larger than that, Google creates multiple archives instead of one. Choosing the largest available limit, up to 50GB, is what stops a big mailbox arriving as a dozen numbered files you then have to keep together.

What Takeout does not give you

Three gaps account for nearly every frustrated search that ends up on this page.

There is no spreadsheet output. Nothing in Takeout produces a table of messages with date, sender and subject as columns. The CSV export people half-remember belongs to Google Contacts, which exports contacts, not mail.

There is no field extraction. If your messages contain order numbers, invoice totals, ticket references or tracking numbers, those values stay buried in the body text of each message inside the MBOX. Getting them into columns is a separate job that Takeout does not attempt.

And there is no way to read the file with what you already have. Excel will not open MBOX. Google Sheets will not open MBOX. Windows and macOS will not preview it. You need a mail client that imports MBOX, such as Thunderbird, or a purpose-built viewer.

How long does Google Takeout take?

Google states the process can take anywhere from a few minutes to a few days depending on how much information is in the account, and that most people get the link to their archive the same day they request it. Large mailboxes with years of attachments sit at the slow end. There is no progress bar worth watching, so request it and go and do something else.

How long does a Google Takeout archive last?

About 7 days. Google says the archive expires after roughly that long and that you would need to create a new one with your most up-to-date information afterwards. It also limits each archive to 5 downloads. Between them, those two rules catch people out constantly: request an export on a Friday, come back after a fortnight, and you are starting over.

Can I export just one Gmail label?

Yes, and you usually should. In the Mail section, open the options and choose Select labels rather than including all messages. A single label for a single project produces a small archive that arrives quickly, downloads once, and contains only what somebody asked for. Exporting an entire account because you needed one folder is how a ten minute request becomes an afternoon.

Does Google Takeout include attachments?

Yes. MBOX stores complete messages, so attachments are encoded inside the file along with everything else. That is also why mail archives get large fast, and why the maximum archive size setting matters. What you cannot do is browse those attachments directly; they come out when a mail client parses the messages back into readable form.

How do I open an MBOX file from Google Takeout?

Install a desktop mail client that imports MBOX. Thunderbird is the usual recommendation because the import is straightforward and it runs on Windows, macOS and Linux. Point it at the file, let it index, and you get a browsable folder of messages. Expect labels to be flattened, since the X-Gmail-Labels header is not something most clients act on. Dedicated MBOX viewers exist too, and are the lighter option if you only need to read rather than keep.

Can I convert an MBOX file to Excel?

Not directly, and not with anything already on your machine. The realistic routes are to import the MBOX into a mail client and then export the messages you actually need as individual .eml files, or to skip the MBOX entirely and pull the messages from the mailbox itself. If your goal was always a spreadsheet, the second route saves a step: connecting the account and taking a label straight to Gmail emails exported to Excel avoids producing an archive you then have to take apart. Once messages are saved as files, the EML to Excel converter handles them in bulk.

Is there a way to export Gmail without Takeout?

For small numbers, yes, and it is quicker. Open a message, click More, then Download message, and Gmail saves it as an .eml file, though Google notes you need a desktop mail client to open it. To take several at once, tick them in the message list, click More, then Forward as attachment, and each message rides along as its own .eml with no limit on how many you attach. That is the practical way to pull thirty order confirmations out of an inbox without requesting anything.

Google Workspace administrators have a third option. Google Vault runs exports across accounts and produces files named as mbox or PST, splitting into zip files once an account exceeds 1 GB for PST or 10 GB for mbox. That is the route when the request is legal or compliance-driven rather than personal, and it needs administrative rights rather than just access to the mailbox.

Does Google Takeout delete my emails?

No. Takeout copies. Your mail stays exactly where it is, read state and labels untouched, and nothing about requesting an archive changes the account. Deleting a Google account is a separate process on a separate page, and Takeout is in fact the step Google recommends before you do it.

When Takeout is the right tool, and when it is not

Use Takeout when the requirement is preservation. Somebody is leaving, an account is closing, a personal backup is overdue, or you want a copy of everything before you change providers. MBOX is a good archive format precisely because it keeps everything and depends on nobody's software staying in business.

Reach for something else when the requirement is analysis. Counting enquiries by month, pulling totals out of recurring notifications, building a list of every message on one customer account, working out what people keep writing in about so you can weigh that feedback against the rest of your product signals: none of those get easier once the mail is inside an MBOX. They get harder, because you have added a format conversion to a job that was already about data.

The shortcut is to decide which one you are doing first. If the answer is a spreadsheet, connect the mailbox, choose the label, name the fields you want out of the body, and take the file. If the answer is an archive, run Takeout, pick your labels, choose zip and the largest size limit, and collect the link within the week.