# Is it possible to export Admin User Notes?

**URL:** https://meta.discourse.org/t/is-it-possible-to-export-admin-user-notes/413008
**Category:** Data & reporting
**Created:** [September 22, 2026, 1:02pm UTC](https://meta.discourse.org/t/is-it-possible-to-export-admin-user-notes/413008 "2026-09-22T13:02:15Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![Moin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/moin/32/554653_2.png) [@Moin](https://meta.discourse.org/u/Moin)
#### Post date: [September 22, 2026, 3:06pm UTC](https://meta.discourse.org/t/is-it-possible-to-export-admin-user-notes/413008/3 "2026-09-22T15:06:32Z")

</div>

You can export the results of a [data explorer](https://meta.discourse.org/t/32566?silent=true) query as a CSV file (or JSON).

I adjusted the query shared in [Analyzing Moderation and Flagging Activity Reports](https://meta.discourse.org/t/analyzing-moderation-and-flagging-activity-reports/352174#p-1710617-user-notes-24) to return all notes tied to a specific user instead of a time span. I also removed most columns from the original because I don’t think the author of the note should be included in your case.

```sql
-- [params]
-- user_id :user_id

WITH user_notes AS (

    SELECT 
        REPLACE(key, 'notes:', '')::int AS user_id,
        notes.value->>'raw' AS user_note
    FROM plugin_store_rows,
    LATERAL json_array_elements(value::json) notes
    WHERE plugin_name = 'user_notes'
    ORDER BY 2 DESC 
)

SELECT un.user_note
FROM user_notes un
JOIN users u ON u.id = un.user_id
WHERE un.user_id = :user_id

```

---

_[View the full topic](https://meta.discourse.org/t/is-it-possible-to-export-admin-user-notes/413008)._