# Export all users (from all time)

**URL:** https://meta.discourse.org/t/export-all-users-from-all-time/70972
**Category:** Support
**Created:** [September 28, 2017, 7:54pm UTC](https://meta.discourse.org/t/export-all-users-from-all-time/70972 "2017-09-28T19:54:39Z")
**Posts on this page:** 12
**Page:** 1

<div class="post-metadata">

### Author: ![Ultim8](https://avatars.discourse-cdn.com/v4/letter/u/ebca7d/32.png) [@Ultim8](https://meta.discourse.org/u/Ultim8)
#### Post date: [September 28, 2017, 7:54pm UTC](https://meta.discourse.org/t/export-all-users-from-all-time/70972/1 "2017-09-28T19:54:39Z")

</div>

Does anyone know of a way to export all users to csv?

We only seem to have the option to download the following:

![image](https://global.discourse-cdn.com/meta/original/3X/9/3/933cfe642d1d4a566c89162bd587fc7c856a646f.png)

Not ‘all users’

Trying to export a user list of 56067 names but only getting the first 27000 ☹

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [September 28, 2017, 7:55pm UTC](https://meta.discourse.org/t/export-all-users-from-all-time/70972/2 "2017-09-28T19:55:05Z")

</div>

All users should export, can you repro this @techapj?

---

<div class="post-metadata">

### Author: ![tobiaseigen](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tobiaseigen/32/539204_2.png) [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)
#### Post date: [September 28, 2017, 8:49pm UTC](https://meta.discourse.org/t/export-all-users-from-all-time/70972/3 "2017-09-28T20:49:13Z")

</div>

the UI is a bit off on this one - the CSV export will always be the entire list no matter which of these views you are looking at. I just tested it and this is the case.

---

<div class="post-metadata">

### Author: ![Ultim8](https://avatars.discourse-cdn.com/v4/letter/u/ebca7d/32.png) [@Ultim8](https://meta.discourse.org/u/Ultim8)
#### Post date: [September 28, 2017, 8:51pm UTC](https://meta.discourse.org/t/export-all-users-from-all-time/70972/4 "2017-09-28T20:51:34Z")

</div>

Thanks… I’ll go back to the forum admin to ask him to try again… its not my forum but one that we have spured off, so they are sharing the userlist with me for verification of new users on our breakaway forum.

---

<div class="post-metadata">

### Author: ![Ultim8](https://avatars.discourse-cdn.com/v4/letter/u/ebca7d/32.png) [@Ultim8](https://meta.discourse.org/u/Ultim8)
#### Post date: [September 28, 2017, 8:52pm UTC](https://meta.discourse.org/t/export-all-users-from-all-time/70972/5 "2017-09-28T20:52:14Z")

</div>

Which forum did you test it on?

More than 27000 users?

---

<div class="post-metadata">

### Author: ![tobiaseigen](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tobiaseigen/32/539204_2.png) [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)
#### Post date: [September 28, 2017, 8:53pm UTC](https://meta.discourse.org/t/export-all-users-from-all-time/70972/6 "2017-09-28T20:53:15Z")

</div>

nope - my community is significantly smaller than that. 🙂

---

<div class="post-metadata">

### Author: ![Ultim8](https://avatars.discourse-cdn.com/v4/letter/u/ebca7d/32.png) [@Ultim8](https://meta.discourse.org/u/Ultim8)
#### Post date: [September 28, 2017, 8:54pm UTC](https://meta.discourse.org/t/export-all-users-from-all-time/70972/7 "2017-09-28T20:54:34Z")

</div>

Can an admin try on this forum please… I see it has 29000+ users so will be be a decent test.

---

<div class="post-metadata">

### Author: ![dax](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/dax/32/244677_2.png) [@dax](https://meta.discourse.org/u/dax)
#### Post date: [September 28, 2017, 10:04pm UTC](https://meta.discourse.org/t/export-all-users-from-all-time/70972/8 "2017-09-28T22:04:51Z")

</div>

I tried it on my forum (10.000 users) and it work without problems.

BTW the worst thing that can happen is that data exports fail. Sometimes happens (maybe because sidekiq is engaged in other jobs), but there is nothing to be scared, just try again after a few minutes and wait the PM from @system.

---

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [September 29, 2017, 1:15pm UTC](https://meta.discourse.org/t/export-all-users-from-all-time/70972/9 "2017-09-29T13:15:56Z")

</div>

Could it be that whatever you’re looking at the list with is truncating it?

I’m doing an import with almost 800k users. I can test next week.

---

<div class="post-metadata">

### Author: ![Ultim8](https://avatars.discourse-cdn.com/v4/letter/u/ebca7d/32.png) [@Ultim8](https://meta.discourse.org/u/Ultim8)
#### Post date: [September 29, 2017, 4:22pm UTC](https://meta.discourse.org/t/export-all-users-from-all-time/70972/10 "2017-09-29T16:22:11Z")

</div>

5th attempt lucky… we have the full list now.

Guess it was timing out mid export or something?

Now the next question… how can I setup my Discourse forum to cross reference a csv list of 56k users?

Desired result - When a user signs up to my forum, if they have chosen a name on the other forum, place them in a group , else place them in a different group.

In both cases, set that group as primary.

Thanks in advance.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [September 29, 2017, 6:13pm UTC](https://meta.discourse.org/t/export-all-users-from-all-time/70972/11 "2017-09-29T18:13:46Z")

</div>

No idea but that has nothing to do with this topic.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [September 29, 2017, 6:13pm UTC](https://meta.discourse.org/t/export-all-users-from-all-time/70972/12 "2017-09-29T18:13:48Z")

</div>


