How to Extract Emails from Google Forms Responses
On this page
Export and import options vary by plan, permissions and product version. Check the platform’s current help documentation if a menu or format differs. Use only contact data you are authorized to process; an extracted address is not proof of marketing consent.
Why Extract from Google Forms Responses?
Google Forms is a widely used tool for surveys, event registrations, contact forms, application forms, order forms, feedback collection and sign-up sheets. Responses are stored in the form itself and can be linked to a Google Sheet. When respondents provide their email addresses, those addresses are stored alongside their other answers.
Extracting email addresses from Google Forms responses is useful in several scenarios.
Building a contact list from multiple forms. If you have run several Google Forms over time (event RSVPs, newsletter sign-ups, feedback surveys, class registrations), email addresses are scattered across separate forms and linked spreadsheets. Extracting from all of them produces a single deduplicated list.
Moving contacts to an email platform or CRM. While Google Forms can be connected to other platforms through add-ons and automation tools, those connections may not have been set up from the beginning, or may have missed responses. Exporting and extracting captures every email address.
Combining form responses with other sources. If contacts come in through Google Forms, a website, email correspondence and paper sign-up sheets, extracting from all sources and deduplicating produces one complete list.
Archiving before deletion. Before deleting old forms or cleaning up a Google Drive, you may want to extract all email addresses from historical responses.
Two Ways to Get the Data
Google Forms responses can be accessed in two ways, and either one works with Email Extractor.
Option A: Export the linked Google Sheet
When you create a Google Form, you can link it to a Google Sheet that receives responses automatically (or create the link later). This is the most common setup.
- Open your Google Form.
- Click the Responses tab.
- Click the green Google Sheets icon to open the linked sheet (or create one if it does not exist yet).
- In Google Sheets, go to File > Download > Comma-separated values (.csv).
- The CSV file downloads to your computer.
If the form collects email addresses through a dedicated email question, they will appear in a column in the sheet. If the form is configured to "Collect email addresses" (a Google Forms setting that records the respondent's Google account email), those appear in a column labelled "Email Address."
Option B: Download responses directly from the form
- Open your Google Form.
- Click the Responses tab.
- Click the three-dot menu and select Download responses (.csv).
- The CSV file downloads to your computer.
This produces the same data as the linked sheet, formatted as a CSV file.
How to Extract the Email Addresses
- Go to bulkemailextractor.com.
- Select "Text and files."
- Upload the CSV file (or files, if you are extracting from multiple forms). Up to 25 MB per file, 100 MB per batch.
- Click "Extract emails."
- Review the results. Duplicates are removed automatically. If the same person submitted multiple forms, their address appears only once.
- Download as TXT for a plain list, CSV for a single-column spreadsheet, or CSV with sources to see which form's export each address came from.
Two Sources of Email Addresses in Google Forms
Google Forms can capture email addresses in two different ways, and it is worth understanding both.
The "Collect email addresses" setting
Google Forms has a built-in setting called "Collect email addresses." When enabled, the form requires respondents to sign in with their Google account (or enter their email manually, depending on the configuration). This email appears in the responses as a system-captured field.
An email question in the form
You can also add a standard question asking for an email address (a short-answer question with email validation). This captures whatever the respondent types, which may be different from their Google account email.
If both are enabled, the response sheet will have two email columns: the system-captured Google account email and the answer to the email question. Email Extractor scans all columns and extracts every email address found. If the same address appears in both columns for the same respondent, deduplication ensures it appears only once in the results.
Working with the Results
Track which form each contact came from
If you export from multiple Google Forms and upload all the CSV files in a single extraction, downloading as CSV with sources shows which form's export file each address appeared in. This helps you distinguish event registrants from survey respondents from newsletter sign-ups.
Combine with other form tools
If you use Google Forms alongside other form builders (Typeform, JotForm, Microsoft Forms), export from each and upload all the files in one extraction. Deduplication handles contacts who submitted forms on multiple platforms.
Handle the Google Sheets link
If you prefer working in Google Sheets before exporting, you can filter, sort or clean the data in the linked sheet first. For example, you might filter to show only responses from a certain date range, or remove test submissions before downloading as CSV.
If you have already extracted email addresses from a Google Sheet using the separate guide, the process described here produces the same results. See Extract emails from Google Sheets.
Things to Know
Column headers are not extracted
CSV column headers like "Email Address" or "What is your email?" are text, not email addresses, so they do not appear in the extracted results.
Other response data is not preserved
Email Extractor outputs email addresses only. Respondent names, survey answers, timestamps and other form fields are not carried over. If you need those fields, work with the original CSV file or Google Sheet directly.
Responses without an email address
If the email question is optional, some responses will not include an email address. Those responses will not contribute to the extracted list. Similarly, if "Collect email addresses" is not enabled and no email question exists, the responses will not contain email addresses at all.
Consent for follow-up
A form submission is consent to the communication the form described, not a blanket marketing opt-in. If the form said "Sign up for our newsletter," the respondent consented to the newsletter. If the form said "RSVP for this event," the respondent consented to event-related communication. Using the addresses for other purposes requires separate consent. See Email consent types explained.
Google Workspace vs. personal accounts
In a Google Workspace organisation, forms may be restricted to internal respondents only. The "Collect email addresses" feature in this case records the respondent's Workspace email. If the form is open to external respondents, it records whatever email the respondent provides.
