How to Extract Email Addresses from Google Sheets

← Back to Email Extractor

Why Extract Emails from Google Sheets?

Google Sheets is a common landing spot for email addresses: exported CRM data, Google Form responses, imported contact lists, or manually built prospect tables. When your sheet mixes email addresses with other data — names, phone numbers, company info — extracting just the addresses efficiently requires the right method.

Method 1: Download as CSV or XLSX and Upload (Simplest)

The fastest approach for most users — no formulas or scripting required.

1. Open your Google Sheet.
2. Click File → Download → Microsoft Excel (.xlsx) or Comma-separated values (.csv).
3. Save the file to your computer.
4. Go to extract-emails.com and upload the file (drag & drop or click to select).
5. The tool reads all cells across all sheets, finds every email address, and deduplicates the results automatically.
6. Copy or download your clean email list as TXT or CSV.

Works for: Sheets with emails in any column, mixed with other data, across multiple tabs. The XLSX download includes all sheets; CSV exports only the active sheet.

Method 2: Copy and Paste Directly

If you only need a quick extraction from a small sheet, copy-paste is even faster than downloading.

1. In Google Sheets, press Ctrl+A (or Cmd+A) to select all cells.
2. Copy with Ctrl+C.
3. Paste into extract-emails.com.
4. Click Extract Emails — the tool parses the tab-separated text and finds every email address.

This works well for sheets up to a few thousand rows. For very large sheets, use the download method above.

Method 3: REGEXEXTRACT Formula (In-Sheet Approach)

If you want to extract email addresses directly within Google Sheets — for example, to pull addresses out of a “Notes” column that contains mixed text — use the REGEXEXTRACT function.

=IFERROR(REGEXEXTRACT(A2, "[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,}"), "")

Place this formula in an empty column, and it extracts the first email address found in cell A2. Drag it down to apply to all rows. To collect all unique addresses:

=UNIQUE(FILTER(B2:B1000, B2:B1000 <> ""))

Where column B contains your REGEXEXTRACT results. This formula approach is powerful but only extracts the first email per cell — for cells with multiple addresses, use Method 1 or 4.

Method 4: Google Apps Script (Automated, All Sheets)

For fully automated extraction across an entire spreadsheet, including all sheets and all occurrences per cell:

function extractAllEmails() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var pattern = /[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,}/g;
  var found = new Set();

  ss.getSheets().forEach(function(sheet) {
    var data = sheet.getDataRange().getValues();
    data.forEach(function(row) {
      row.forEach(function(cell) {
        var str = String(cell);
        var matches = str.match(pattern);
        if (matches) matches.forEach(function(e) { found.add(e.toLowerCase()); });
      });
    });
  });

  var result = Array.from(found).sort();
  var out = ss.getSheetByName('Extracted Emails') ||
            ss.insertSheet('Extracted Emails');
  out.clearContents();
  out.getRange(1,1).setValue('Email');
  result.forEach(function(e, i) { out.getRange(i+2, 1).setValue(e); });
  SpreadsheetApp.getUi().alert('Done: ' + result.length + ' unique emails extracted.');
}

1. In your Google Sheet, click Extensions → Apps Script.
2. Paste the script above and click Run. Approve permissions.
3. A new sheet called “Extracted Emails” is created with all unique addresses.
4. Download this sheet as CSV and upload to extract-emails.com if you need additional deduplication or filtering.

Tips

• Multiple email addresses per cell: Only Methods 1 and 4 reliably extract all emails from cells containing multiple addresses.
• Form responses: Google Forms write responses to a Sheet. Use Method 1 (download) for a one-time export, or Method 4 for an automated recurring extraction.
• Large datasets: Sheets with 10,000+ rows process best via download + upload. The XLSX format is handled very efficiently by extract-emails.com.
• Privacy: When using extract-emails.com, all processing happens locally in your browser — your spreadsheet data is never sent to a server.

FAQ

• Does it work with multiple sheets in one file? Yes — when you download as XLSX, all sheets are included and extract-emails.com reads all of them.
• Can it extract emails from Google Sheets formulas? Only the values are extracted, not the formulas themselves. If a formula displays an email address, that value is captured.
• What if emails are inside longer text strings? The regex-based extractor (both the tool and the REGEXEXTRACT formula) finds email addresses embedded in any text, including full sentences.