How to export emails from Gmail to Google Sheets?

How to export emails from Gmail to Google Sheets?

- Published: - 3 minutes read

It can be really helpful to export emails from Gmail to a Google Sheets spreadsheet. This will let you much more with your emails data, such as exporting latest orders, expenses or receipts, backup and much more.

In this short article, I’ll show you how to export Gmail to Google Sheets using a gmail export plugin. It lets you download a CSV file right from your Gmail inbox. Then you can insert it into Google Sheets.

Let’s do it together step by step.

Step 1. Install the gmail export plugin

To install the Gmail export plugin, open Google Chrome and download the Chrome extension Mailmeteor for Gmail.

Mailmeteor for Gmail - Chrome Webstore Listing page

While Google offers a Takeout feature, this extension is much better as it lets you export search your emails and export the results in one click. It has been developed by Mailmeteor, which is famous for its mail merge solution that has been recommended by Google.

Step 2. Open Gmail

Once the Gmail export plugin is installed, open your Gmail and search for some emails. For example, you can search for all emails received in the last 30 days:

Search for emails received in the last 30 days in Gmail

Step 3. Export the emails

Once you’ve find the emails you want, click on the Export button:

Export emails button in Gmail inbox

If you don’t see the Export button, go back to Step 1 and make sure that you’ve installed the Gmail export plugin for Google Chrome.

Step 4. Download your emails

Shortly after, the export is ready and you’ll receive an email with a download link to export your emails data. Follow the link and save the .CSV file on your desktop.

Download emails export from Gmail

Step 5. Import the CSV in Google Sheets

Now, open a new Google Sheets spreadsheet and import the .CSV file. Here’s how to do it:

  1. Sign in to Google Sheets
  2. Create a new spreadsheet
  3. In the menu, click on “File” > “Import
  4. In the Import dialog, select “Upload” > “Browser” and select your .CSV file
  5. Start the import process by clicking on “Import data”.

Soon after, your spreadsheet is filled with the data from the .CSV file. You can now start working on it.

Emails exported from Gmail to Google Sheets

FAQ

How many emails can I export?

The Gmail export plugin lets you download up to 50,000 emails per search. Plenty enough for most use cases.

How long does it take?

It depends on the size of your export. It will take a few second to export dozens or hundreds of emails. It might take a few minutes up to 1 hour for very large downloads.

How much does it cost?

The Gmail export plugin is totally free. It’s been made available by Mailmeteor, the #1 email marketing platform for Gmail.

How does Mailmeteor protect my data?

Like all Mailmeteor products, the Gmail export plugin has been designed with privacy in mind. Your emails are not shared with anyone and the download link automatically expires after 7 days. Learn more on how we take care of the security of our products.

Can I export attachments?

The Gmail export plugin doesn’t support attachments yet. Feel free to fill out this feedback form to let us know your use case.

Can I use Excel instead of Google Sheets?

Sure! The Gmail export plugin creates a .CSV file that you can easily import in Excel. It works the same as in Google Sheets.

This article was written by Corentin Brossault, Mailmeteor's CTO & co-founder. When he's not busy coding the next big thing, you might catch him sharing the latest updates and insights on Twitter.

Published in:

One giant leap for your inbox

Sign up for tips and industry insights to level up your emailing skills.

Explore more from Mailmeteor

Articles, examples, tutorials, and inspiration from our emailing experts.