# Exporting group members emails as csv

**URL:** <https://meta.discourse.org/t/exporting-group-members-emails-as-csv/43756>\
**Category:** Product Support\
**Created:** [2016 年 5 月 5 日午後 9:11 UTC](https://meta.discourse.org/t/exporting-group-members-emails-as-csv/43756 "2016-05-05T21:11:55Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![techAPJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/techapj/32/342990_2.png) [@techAPJ](https://meta.discourse.org/u/techAPJ)\
**Post date:** [2016 年 5 月 6 日午前 9:03 UTC](https://meta.discourse.org/t/exporting-group-members-emails-as-csv/43756/3 "2016-05-06T09:03:31Z")

</div>

Hi @phi,

Yes, this can be done by running a query from `/admin/plugins/explorer` once you have [`discourse-data-explorer`](https://github.com/discourse/discourse-data-explorer) plugin installed.

Here is the query you are looking for:

```
-- [params]
-- group_id :group

WITH user_groups AS (
    SELECT gu.user_id
    FROM groups g
    JOIN group_users gu ON gu.group_id = g.id
    WHERE g.id = :group
    GROUP BY gu.user_id
)
SELECT u.email
FROM users u
INNER JOIN user_groups ug ON u.id = ug.user_id
WHERE u.id > 0
ORDER BY u.id DESC

```

The group name will be entered in `group` field, and once you run the query you will have the option to export the result, which will only contain user emails from the group you specified.

 ![](https://global.discourse-cdn.com/meta/original/3X/5/a/5ab2c63ddfef29d9cb55ef96e038b9e1d8a56402.png)

I hope this helps.

---

_[View the full topic](https://meta.discourse.org/t/exporting-group-members-emails-as-csv/43756)._