Form responses to email list: Google Forms, Typeform, Jotform and Tally exports, one row per person
In short: Reads a responses export from Google Forms, Typeform, Jotform, Tally or Microsoft Forms, finds the email question by its answers, merges repeat submissions, reads a consent or newsletter question, and sets test submissions aside. Limit: Consent can only be read when the form asked a consent or newsletter question.
To get an email list from form responses, download the responses as CSV or Excel (Google Forms: Responses > Download responses; Typeform: Results > Download) and upload the file here. The email question is found by its answers, repeat submissions become one row with a count, a consent question is read, and test submissions are set aside.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. See pricing
Sample result
7 form responses became 4 people to reply to, 3 of them said yes to the newsletter.
- Respondents
- 4 people
- Responses read
- 7
- Said yes
- 3
What this means for you
Repeat submissions merge; the consent question is read; test submissions are set aside.
- Email question found by its answers
- Repeat submissions merged
- Consent question read
- Test submissions set aside
- Forms
- Consent
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
How do I turn form responses into an email list?
- Download the responses: Google Forms (Responses tab > three dots > Download responses, or the linked Sheet as CSV), Typeform (Results > Responses > Download), Jotform (Submissions > Download as CSV), Tally (Submissions > Download CSV) or Microsoft Forms (Open results in Excel).
- Upload the file here, or paste it.
- Choose: keep only people who said yes to the consent or newsletter question, read other email questions too, and set test submissions aside.
- Download the email list, and the set-aside file with the reason for each address.
Example
- You enter
- A Google Forms responses export with 7 rows:
ana.silva@example.comtwice in different case, a test submission (test@test.com), one response with no address, a newsletter question and a colleague's-email question. - You get
- 4 respondents in the list, Ana as one row with 2 submissions; 3 said yes to the newsletter question; the test submission set aside with the reason
Looks like a test submission. The colleague's address is left out until you tick the option. - Limits
- Runs in your browser with no row cap; an uploaded file can be up to 25 MB.
How do I export email addresses from Google Forms?
Open the form, go to the Responses tab, click the three dots and choose Download responses (.csv), or open the linked Google Sheet and use File > Download > CSV. The address is in the Email Address column when the form collects emails, or in the column named after your email question.
Form exports name each column after the question, so the tool doesn't rely on the header alone. It picks the column whose answers are addresses, ignores "Confirm your email" repeats, and tells you which column it read.
Can I add form respondents to my mailing list?
Only the ones who agreed. Someone who filled in a contact or registration form asked for a reply about that, which isn't the same as agreeing to a newsletter. If the form asked, for example "Would you like our monthly newsletter?", the tool finds that question and can keep only the yes answers.
The FTC's CAN-SPAM guide covers the US and the ICO's guidance the UK. A form without a consent question can still be used for replies about what people asked for.
Why are there duplicate emails in my form responses?
People submit twice when they aren't sure the first went through, change an answer, or sign up for a second session. The tool merges responses by address (case doesn't matter), counts submissions, keeps the first and last timestamp, and counts a yes to the consent question on any of them.
Is this faster than cleaning the responses in Google Sheets?
| This tool | Google Sheets | |
|---|---|---|
| Finding the email column | Found by its answers | Scroll to the question |
| Repeat submissions | One row with a count | =UNIQUE() loses the counts |
| Consent question | Read, yes-only option | Filter by each answer wording |
| Test submissions | Set aside with a reason | Find them by eye |
Who uses this tool, and for what?
- Small businesses
- Reply to everyone who filled in a quote or contact form, without copying addresses out of a sheet.
- Event and course hosts
- Build the reminder list from a Google Forms registration and keep only people who asked for updates.
- Researchers and nonprofits
- Pull the follow-up list from a survey where respondents left an address to hear the results.
- Marketers
- Move Typeform or Tally signups into an email tool with consent and submission count as fields.
What can’t this tool tell you?
- Consent can only be read when the form asked a consent or newsletter question.
- The test-submission filter catches obvious ones (test@, "test" as the name), not every made-up address.
- It can't tell which addresses still have a working inbox.
- Each run reads one export; paste several with the header kept once to combine forms.
Common questions
- How do I download Typeform responses as CSV?
- In Typeform, open the form, go to Results > Responses, select all and choose Download, then CSV or Excel. Upload that file here.
- Does it work with a Google Sheet linked to a form?
- Yes. Download the sheet as CSV or .xlsx, or copy the cells and paste them in.
- What if my form has two email questions?
- The one with the most addresses is read. Tick the option to also read the others, such as a colleague's or a friend's address; the email_question column shows where each came from.
- Does it work with Microsoft Forms?
- Yes. Open results in Excel and upload the workbook. Anonymous responses have no address and are counted separately.
- Is my form data uploaded?
- No. The file is read in your browser. Nothing is sent unless you choose to check the addresses afterwards.
Sources
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
One plan, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.