Skip to main content
July 19, 2023
Question

How to export the user list from 1Password

  • July 19, 2023
  • 3 replies
  • 2077 views

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

July 25, 2023

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!

July 28, 2023

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

July 28, 2023

Glad you could make progress, @TungLe!