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
- Install Rowcatch from the Chrome Web Store and click its toolbar button. It opens in its own tab.
- Click Sign in with Google. Google asks once to let Rowcatch read your Gmail, create spreadsheets in your Drive and see your email address.
- Click New, then Email details. The template fills in a search (
label:inbox newer_than:30d) and nine columns. - 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.
- 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.
- Click Preview on 20 emails. Rowcatch shows each column's value for real emails from your search. Nothing is written yet.
- 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.
- Click Check what will be exported. You see how many emails the run will write before any email is read.
- Click Export N emails now, then Open the spreadsheet.
Searches that work well
| You want | Type this in Which emails |
|---|---|
| Everything from one company | from:@example.com |
| A label you already use | label:clients |
| Emails with files attached this year | has:attachment after:2026/01/01 |
| One subject line | subject:"weekly report" |
| Everything, including archived mail | in:anywhere |
Google lists every search operator in Search operators you can use with Gmail.
What each column holds
| Column | What you get |
|---|---|
| Date | When the email arrived, as a date Sheets can sort |
| From name, From email | The sender, split in two columns |
| To | Every recipient |
| Subject | The subject line |
| Preview | The first line or so of the body, as Gmail shows it |
| Labels | Every Gmail label on the email, comma separated |
| Attachments | The names of the attached files |
| Link | Opens 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
- How to send new Gmail emails to Google Sheets automatically
- How to send contact form leads from Gmail to Google Sheets
- How to extract data from Gmail emails into Google Sheets
- How to log order confirmation emails in Google Sheets