Skip to main content
Jul 19, 2023 6:49 AM UTC
Question

How to export the user list from 1Password

Hi everyone,

Can someone show me how to export all users within our 1Password to the csv file for audit purpose ? I can't find any docx about this.

Thank you in advance !!!


1Password Version: Not Provided
Extension Version: Not Provided
OS Version: Not Provided
Browser: Not Provided

3 replies

Jul 25, 2023 8:53 AM UTC

Hey TungLe!

There is no native option to do this with the CLI. You could use op user list --format json, and then some jq magic, such as:

op user list --format json | jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv'

to achieve this.

Let me know if this helps!

Jul 28, 2023 2:36 AM UTC

Thank you. Please close the ticket as I have solved it.

Jul 28, 2023 6:39 PM UTC

Glad you could make progress, @TungLe!