Zoom attendee report to email list: attendees and no-shows from a webinar CSV
In short: Reads a Zoom webinar attendee or registration report, which is several tables in one CSV (Host, Panelist, Attendee, Other Attended), or a meeting participants export. One row per address with attended yes or no, minutes in session added across rejoins, organization and job title. Limit: It can only read addresses Zoom recorded; unregistered guests have none.
To get emails from a Zoom webinar, open Reports > Webinar in the Zoom web portal, download the Attendee report CSV and upload it here. Every section is read, hosts and panelists are left out, people who rejoined become one row with their minutes added up, and registered no-shows can go to their own file for a replay email.
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
A Zoom webinar report read section by section: 3 attended, 2 no-shows, host left out.
- Attendees
- 3 attended
- Sections read
- 3
- Rejoins merged
- 1
What this means for you
Rejoins merge into one row with minutes added; no-shows can go to a replay list.
- Multi-section report read as is
- Hosts and panelists left out
- Minutes added across rejoins
- No-shows in their own file
- Zoom
- Webinar
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
How do I turn a Zoom attendee report into an email list?
- In the Zoom web portal, open Reports, choose Webinar (or Meeting for a meeting), pick the Attendee or Registration report for the session and download the CSV. For a meeting, Usage > Participants > Export also works.
- Upload the CSV here as it is; the summary lines at the top don't need deleting.
- Leave Leave out hosts and panelists ticked. Tick Keep only people who attended to put no-shows in a separate file.
- Download the attendee list for the thank-you email and the set-aside file for the replay email.
Example
- You enter
- A Zoom webinar attendee report with summary lines and Host, Panelist and Attendee sections; one attendee joined twice (23 and 34 minutes) and 2 registrants didn't attend.
- You get
- 5 attendees kept and the host and panelist set aside. The attendee who rejoined is one row with 57 minutes and 2 joins; 3 attended and 2 are marked
attended: nofor a replay email. - Limits
- Runs in your browser with no row cap; an uploaded file can be up to 25 MB.
Why won't my Zoom attendee report open properly in Excel?
Because it isn't one table. A webinar report starts with a few summary lines (Attendee Report, Topic,Webinar ID,...), then has a section for hosts, one for panelists, one for attendees and sometimes Other Attended, each with its own header row. Excel shows them stacked on one sheet, so sorting or filtering mixes headers with data.
The tool finds each section and its header, so the file can be uploaded straight from the download.
Why is the same attendee listed several times?
Zoom writes a row for each join. Someone whose connection dropped, or who switched from laptop to phone, has two or more rows, each with its own Join Time and Time in Session. The tool merges them by email, adds up the minutes, counts the joins and keeps the first join time.
If someone was connected on two devices at the same time, both sessions are added, so their total can be longer than the webinar.
How do I email the people who registered but didn't attend?
Tick Keep only people who attended. Registrants with Attended: No go to the set-aside file with the reason Registered, did not attend; send them the recording. A registration report on its own has no join times, so everyone in it is marked as not attended; use the attendee report for that split.
Webinar registration forms collect spare and mistyped addresses, since people type anything to get the link. Those bounce when the replay goes out; check the list free under the result first.
Is this faster than cleaning the Zoom CSV by hand?
| This tool | Excel | |
|---|---|---|
| Multi-section report | Every section read | Delete summary lines and extra headers |
| Rejoins | One row, minutes added | Pivot table by email |
| Hosts and panelists | Left out | Find and delete their rows |
| No-shows | Own file | Filter Attended = No, copy out |
Who uses this tool, and for what?
- Webinar marketers
- Split attendees from no-shows in one step and send each group the right follow-up.
- Sales teams
- Sort attendees by minutes in session and call the people who stayed to the end first.
- Course creators and coaches
- Track who came to each live session, merged across rejoins.
- Event teams
- Leave hosts and panelists out of the attendee list automatically.
What can’t this tool tell you?
- It can only read addresses Zoom recorded; unregistered guests have none.
- Minutes are added across joins, so overlapping sessions on two devices are counted twice.
- Registration answers beyond the standard fields are not carried into the download.
- It can't tell which addresses still have a working inbox.
Common questions
- How do I export attendee emails from Zoom?
- Reports > Usage reports > Webinar > Attendee report > generate, then download the CSV. Upload it here without editing it.
- Does it work for Zoom meetings, not webinars?
- Yes. A meeting's participants export (Usage > Participants > Export) is one table with one row per join; it is merged the same way.
- Why do some attendees have no email?
- Guests who joined a meeting without signing in, and attendees of a webinar without registration, have no address in the report. They are counted and left out.
- Can I see how long each person stayed?
- Yes. The minutes_in_session column adds up every join for that address, and joins counts how many times they came in.
- Is the report uploaded?
- No. The CSV 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.