Skip to main content
You can bulk export user data out of Auth0. For a list of user profile fields that can be exported, read User Profile Structure.

​
Supported file formats

We support user data exports in JSON-compatible and CSV formats.
  • Our JSON-compatible export files are in NDJSON format due to the large size of the export files.
  • In CSV export files, we escape string data types in conformance with OWASP standards for CSV injection mitigation.
    • Double-quote characters are prepended with a double-quote character.
    • Each string is prepended with a single-quote character.
    • Each string is wrapped in double quotes.
    This does not apply to Auth0-generated dates in ISO 8601 format.

​
Prerequisites

  • You must have one of the following tenant member roles:
    • Admin
    • Editor - Users
    • Dashboard Viewer - Users

​
1. Submit export users job

To export user data using the Auth0 Dashboard:
  1. Go to Dashboard > User Management > Users.
  2. In the top right corner of the page, select Import/Export Users to go to the Import/Export Users page.
  3. Select Export Users to go to the Export Users page.
  4. In the Export Settings section:
    • Under Connection, open the drop-down menu and select the database connection where you want to export the user data.
    • Under Export Format, open the drop-down menu and select the format you want the data to be in (JSON or CSV).
  5. In the Export Fields section, choose the fields you want the export to include:
  6. Optionally, in the Export Fields section, check Export as Sample to limit the export to 10 users. This can be helpful to validate the structure of the export file.
  7. To submit the job, select Export Users.

​
2. Check job status and download the export

To check the status of a job:
  1. Go to Dashboard > User Management > Users.
  2. In the top right corner of the page, select Import/Export Users to go to the Import/Export Users page. Once you start at least one job, this page lists your submitted jobs.
  3. Next to each job, you can choose:
    • Check Status to monitor job progress.
    • Download export to retrieve the result.
    • More info to review errors or job metadata.
The download link is valid for 60 seconds. If this time period expires, you have 24 hours to call it again before the job expires.

​
Limits

  • All job-related data is automatically deleted after 24 hours.
  • Data exports in CSV format are limited to 30 fields.
  • Data exports in CSV format cannot include app_metadata or user_metadata as single objects. Instead, specify fields of metadata objects explicitly or export data in JSON-compatible format (which supports metadata as single objects):
    JSON-compatible format request body
    {
  "format": "json",
  "fields": [
    { "name": "user_metadata.example" }
  ]
}
    CSV format request body
    {
  "format": "csv",
  "fields": [
    { "name": "user_metadata.example.field_one" },
    { "name": "user_metadata.example.field_two" },
    { "name": "user_metadata.example.field_three" }
  ]
}