How to export Gmail emails to Google Sheets

By Jake Marsh · Updated

To export Gmail emails to Google Sheets, add the Rowcatch extension to Chrome, sign in with Google, click New and pick the Email details template. Type a Gmail search in Which emails, click Preview on 20 emails, then Create spreadsheet in step 4, Check what will be exported and Export N emails now. Each email becomes one row with its date, sender, recipients, subject, preview, labels, attachment names and a link back to Gmail.

Before you start

  • Google Chrome on a computer, and the Gmail account you want to export from.
  • Gmail doesn't have an export-to-spreadsheet button of its own, which is the job Rowcatch does.
  • Rowcatch reads email with read-only access. It can't send, delete, label or move anything.

Steps

  1. Install Rowcatch from the Chrome Web Store and click its toolbar button. It opens in its own tab.
  2. Click Sign in with Google. Google asks once to let Rowcatch read your Gmail, create spreadsheets in your Drive and see your email address.
  3. Click New, then Email details. The template fills in a search (label:inbox newer_than:30d) and nine columns.
  4. Change the search in step 1, Which emails. It takes anything you'd type in Gmail's search box. Click Find emails to see the matches; tick individual emails if you only want some of them, or tick none to export the whole search.
  5. Look over the columns in step 2. Rename a column, remove one, or click Add column for another field such as Cc, Reply-To, Attachment count or Another header.
  6. Click Preview on 20 emails. Rowcatch shows each column's value for real emails from your search. Nothing is written yet.
  7. Create the spreadsheet in step 4. Rowcatch suggests a name like "Email details (Rowcatch)"; change it if you want, then click Create spreadsheet. The sheet goes in your Google Drive.
  8. Click Check what will be exported. You see how many emails the run will write before any email is read.
  9. Click Export N emails now, then Open the spreadsheet.

Searches that work well

You wantType this in Which emails
Everything from one companyfrom:@example.com
A label you already uselabel:clients
Emails with files attached this yearhas:attachment after:2026/01/01
One subject linesubject:"weekly report"
Everything, including archived mailin:anywhere

Google lists every search operator in Search operators you can use with Gmail.

What each column holds

ColumnWhat you get
DateWhen the email arrived, as a date Sheets can sort
From name, From emailThe sender, split in two columns
ToEvery recipient
SubjectThe subject line
PreviewThe first line or so of the body, as Gmail shows it
LabelsEvery Gmail label on the email, comma separated
AttachmentsThe names of the attached files
LinkOpens that email in Gmail

Want values from inside the email, like an order number or a phone number? See how to extract data from Gmail into Google Sheets.

Large mailboxes

One export you start by hand writes up to 2,000 emails. If your search matches more, Rowcatch tells you so; click the button again after the run finishes and it carries on, because emails already in the sheet are skipped. To keep adding new emails without clicking, see how to send new Gmail emails to Google Sheets automatically.

What it costs

Rowcatch's free trial covers your first 100 exported emails or 7 days, whichever comes first, with every feature. After that, Starter is $39 a month, Pro $70 and Business $99, per Google account. Previews never count against the trial. Every plan and the install link are on the Rowcatch page.

Rowcatch: Email Parser to Google Sheets for Gmail

Export Gmail emails to Google Sheets with parsing rules, duplicate checks and scheduled sync 3 plans from $39 a month per Google account.


Questions

Can I export Gmail to Excel instead?

Yes, in two ways. The preview has a "Download this preview as CSV" link, and the full Google Sheet can be downloaded as an Excel file from File > Download in Sheets.

Does it export one row per email or per conversation?

One row per email by default. Under Duplicates in step 4, pick "One row per conversation (newest email)" to get a single row for each thread.

Can I add rows to a sheet I already have?

Rowcatch can only open spreadsheets it created, so create one in step 4. You can add your own columns and formulas next to the exported ones afterwards, and Rowcatch keeps them.

Does it export the full email body?

Yes, if you add a column with From set to Body text and Take set to All of it. Long bodies are cut off just under Google Sheets' cell limit.


More Rowcatch guides


More Chrome guides