How to Export Emails from Gmail (to Sheets, Excel, CSV, or a Database)

The right way to export emails from Gmail depends entirely on what you're trying to do with them afterward. Backing up your whole account before you close it is a different job from pulling one label into a spreadsheet, which is different again from feeding every new invoice into a database you can filter. No single tool does all three well, and most articles pretend otherwise.

So here's the honest version. There are four real routes, and I'll tell you which one fits which job — including the ones where I don't build the tool.

1. Google Takeout — a one-time backup of your entire mailbox (free, MBOX format)
2. Marketplace add-ons — bulk export of a Gmail label into a spreadsheet (cloudHQ, Xtractor)
3. Quicktion — ongoing, structured export of incoming or hand-picked emails into Sheets, Notion, Airtable, Linear, or Trello
4. The Gmail API / Apps Script — a developer route for full control (free, code required)

Here's how they compare before I get into each one:

Route 1: Google Takeout (back up your whole mailbox)

If what you want is a copy of everything — every message, every label, the full archive — Google Takeout is the tool Google gives you for free. It's the correct answer for "I'm leaving this account and I want my email," or "I need an offline backup before I clean house."

Go to takeout.google.com, deselect everything, then select only Mail. You can export all of it or pick specific labels. Google packages the messages into an MBOX file and emails you a download link when it's ready, which can take anywhere from minutes to a day or two depending on how much mail you have.

The catch is the format. MBOX is a single file containing your raw messages, headers and all. It is not a spreadsheet. You can't open it and sort by sender or filter by date the way you'd want to. To read it you need an email client that imports MBOX (Thunderbird, Apple Mail) or a dedicated MBOX viewer. If your goal is "put my emails in rows and columns so I can work with them," Takeout is the wrong tool and you'll fight it the whole way.

Use Takeout when: you want a complete, archival backup and you're fine with an email-shaped file rather than a table.

Route 2: Marketplace add-ons (a label to a spreadsheet)

If you have a Gmail label — say, a few hundred receipts or every message from a client — and you want all of it dumped into a Google Sheet in one go, a dedicated bulk-export add-on is the fastest path. Two are worth naming, both with well over half a million installs on the Google Workspace Marketplace:

• Export Emails to Sheets by cloudHQ — point it at a label and it exports the matching emails into a spreadsheet, with an option to keep syncing new ones.
• Email Parser by Xtractor — similar idea, with parsing rules to pull specific values out of the body into their own columns.

Both are genuinely good at the one-time bulk job: "I have 800 emails under this label, get them into Sheets." That's a job neither Takeout nor a click-to-save tool does well, and I'd point you straight at these for it.

Two honest limits. First, they're Google Sheets only. If your team works in Notion, Airtable, Linear, or Trello, these don't help. Second, the free tiers cap how many rows you can export before you hit a paywall, and the body handling is basic — you tend to get plain text, not the formatted email with clickable links.

Use a Marketplace add-on when: you need a large, existing Gmail label exported into a spreadsheet in one shot.

Route 3: Quicktion (ongoing, structured export to five destinations)

The two routes above are about the past — the mail already sitting in your account. Quicktion is about the flow: the emails arriving now and the ones you decide, one by one, are worth keeping. I built it because "export" for most people isn't a single download, it's a habit. Receipts keep coming. Leads keep coming. You want each one landing somewhere structured without thinking about it.

I'll be straight about the boundary, because it's the thing that trips people up: Quicktion does not bulk-export a historical Gmail label. It processes emails as they arrive (via forwarding) or the moment you click save (via the Gmail add-on). If you need last year's 800 receipts pulled out in one pass, use a Marketplace add-on from Route 2. If you want every receipt from here on to file itself, that's this.

Where it earns its place:

Five destinations, not one. Sheets, Notion, Airtable, Linear, and Trello. Each gets its own forwarding address and its own field mapping. The add-ons above stop at Sheets.

Real field mapping. Subject, sender name, sender email, date, the full body, and attachments each go to the field you choose. The body is converted properly — Notion blocks with headings and lists, or rich-text cells in Sheets with links that stay clickable, not a wall of plain text.

AI extraction on Pro. This is the part a plain export can't do. On the Pro plan, AI Email Intelligence reads each email (and its attached PDFs and images) and pulls out the fields Gmail never had — invoice total, order number, due date, a one-line summary — into columns you define. A receipt stops being a blob of text and becomes vendor | amount | date | category.

Setup is about two minutes: create a destination, connect the account, confirm the auto-suggested mappings, and either forward emails in or click save from the Gmail sidebar. For the automatic version, a Gmail filter that forwards matching mail to your Quicktion address means new emails export themselves with no further action. There's a full walkthrough in the Gmail to Google Sheets guide.

The honest bridge to Excel and CSV

People search for "export Gmail to Excel" and "export Gmail to CSV," so let me be clear about how that actually works, because there's no direct button anywhere.

Google Sheets exports to both formats natively. Once your emails are in a Sheet — via Quicktion or a Marketplace add-on — you open File > Download and choose Microsoft Excel (.xlsx) or Comma-separated values (.csv). That's the real path to Excel and CSV: get the emails into Sheets as structured rows first, then download in the format you want. Anyone promising a one-click Gmail-to-Excel export is quietly doing this same two-step in the background.

Use Quicktion when: you want incoming or hand-picked emails to keep landing in a spreadsheet or database as clean, structured entries — with AI pulling out the fields that matter.

Route 4: The Gmail API / Apps Script (for developers)

If you write code, Google gives you the raw materials for free. Google Apps Script can reach both Gmail and Sheets, so a GmailApp.search() call plus a loop that appends rows will export whatever you can describe in a query. The Gmail API does the same from any language, with more control over batching and quotas.

This is the most flexible route and the most work. You handle the search logic, the parsing, the date formatting, the attachment uploads, the retries, and the maintenance when something changes. For a genuinely custom pipeline it's the right call. For "I just want my receipts in a sheet," the hours of building and babysitting usually cost more than they save. There's a fuller breakdown of the Apps Script tradeoffs in the Gmail to Google Sheets guide.

Use the API when: you have specific custom requirements and the skills to build and maintain a script.

So which one do you actually need?

Match the route to the job and this gets simple:

• A backup of everything before you close or clean an account → Google Takeout. Free, complete, MBOX.
• An existing Gmail label pulled into a spreadsheet in one pass → a Marketplace add-on (cloudHQ, Xtractor). Bulk, Sheets-only.
• Incoming or hand-picked emails filing themselves as structured data → Quicktion. Five destinations, real field mapping, AI extraction on Pro. Then download to Excel or CSV from Sheets if you need those formats.
• A custom pipeline you're willing to code and maintain → the Gmail API or Apps Script.

Most people who land here trying to "export Gmail to a spreadsheet" actually want the third one and don't know it yet — they think of it as a one-time export, but the receipts and leads keep arriving. If that's you, and once your data is in a database rather than a flat export, the natural next step is turning Gmail into something you can query.

Frequently asked questions

How do I export emails from Gmail?

It depends on what you want. For a one-time backup of your whole mailbox, use Google Takeout — it's free and gives you an MBOX file. To turn a Gmail label into spreadsheet rows, use a Marketplace add-on like cloudHQ or Email Parser by Xtractor. To keep exporting incoming or hand-picked emails into Sheets, Notion, Airtable, Linear, or Trello as structured data, use Quicktion. Developers can script it with the Gmail API.

How do I export Gmail emails to Excel?

There's no direct Gmail-to-Excel button. The reliable path is Gmail to Google Sheets first, then File > Download > Microsoft Excel (.xlsx) from inside Sheets. Tools like cloudHQ (bulk, per label) or Quicktion (ongoing, structured) get your emails into Sheets, and Sheets exports to Excel natively.

How do I export Gmail emails to a CSV file?

Get the emails into Google Sheets first, then use File > Download > Comma-separated values (.csv). Google Takeout exports to MBOX, not CSV, so it's the wrong tool if you need a spreadsheet. A Marketplace add-on or Quicktion writes emails to Sheets, and Sheets downloads as CSV in two clicks.

Can I export all my Gmail emails at once?

Yes, with Google Takeout. Choose Mail, optionally limit to specific labels, and Google builds a downloadable MBOX archive of every message. It's a full backup, not a spreadsheet — MBOX keeps the raw messages, not tidy rows you can filter and sort.

Is there a free way to export emails from Gmail?

Yes. Google Takeout is free for full-mailbox backups, and the Gmail API is free if you can write the code. Quicktion has a free plan (25 emails per month, one destination). Most Marketplace add-ons for bulk label export are free up to a limit, then paid.

How do I automatically export new Gmail emails to a spreadsheet?

Set up a Gmail filter that forwards matching emails to a Quicktion forwarding address, or install the Gmail add-on for one-click saves. Each email lands in your spreadsheet, Notion database, or Airtable base as a structured row with subject, sender, date, body, and attachments mapped to the right fields.

Get started

If your export is really an ongoing habit — receipts, leads, confirmations arriving week after week — Quicktion keeps each one landing in Sheets, Notion, Airtable, Linear, or Trello as a clean, structured entry, free for your first 25 emails a month. For a one-time backup, Google Takeout is the right free tool, and for a big existing label, reach for a Marketplace add-on.

Next up: how to turn Gmail into a database you can actually query.