# Export User List to CSV

**URL:** <https://forums.plex.tv/t/export-user-list-to-csv/801221>\
**Category:** General Discussions\
**Created:** [July 18, 2022, 6:26pm UTC](https://forums.plex.tv/t/export-user-list-to-csv/801221 "2022-07-18T18:26:07Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![badincite](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/badincite/32/195792_2.png) [@badincite](https://forums.plex.tv/u/badincite)\
**Post date:** [July 18, 2022, 6:26pm UTC](https://forums.plex.tv/t/export-user-list-to-csv/801221/1 "2022-07-18T18:26:07Z")

</div>

What’s the easiest way to get a user list exported into a spreadsheet?  
[https://plex.tv/pms/friends/all?X-Plex-Token=](https://plex.tv/pms/friends/all?X-Plex-Token=) is in a xml format that isn’t easily convertible,

---

<div class="post-metadata">

**Author:** ![SwiftPanda16](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/swiftpanda16/32/81839_2.png) [@SwiftPanda16](https://forums.plex.tv/u/SwiftPanda16)\
**Post date:** [July 18, 2022, 6:39pm UTC](https://forums.plex.tv/t/export-user-list-to-csv/801221/2 "2022-07-18T18:39:57Z")

</div>

Excel can open XML files and create a table.

---

<div class="post-metadata">

**Author:** ![anon5074910](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@anon5074910](https://forums.plex.tv/u/anon5074910)\
**Post date:** [July 18, 2022, 6:49pm UTC](https://forums.plex.tv/t/export-user-list-to-csv/801221/3 "2022-07-18T18:49:55Z")

</div>

As an alternative if its just accounts your looking for couldn’t you just query the db directly ? Example below …

```auto
"/usr/lib/plexmediaserver/Plex Media Server" --sqlite com.plexapp.plugins.library.db
.mode column
SELECT * from accounts;

```

---

<div class="post-metadata">

**Author:** ![badincite](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/badincite/32/195792_2.png) [@badincite](https://forums.plex.tv/u/badincite)\
**Post date:** [July 18, 2022, 8:26pm UTC](https://forums.plex.tv/t/export-user-list-to-csv/801221/4 "2022-07-18T20:26:31Z")

</div>

Well dang… learned something new.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [October 16, 2022, 8:26pm UTC](https://forums.plex.tv/t/export-user-list-to-csv/801221/5 "2022-10-16T20:26:55Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.