Stackpane Stackpane
Download

Import & Export

Export all users as JSON or CSV and import user data for backup and migration.

Overview

Stackpane supports exporting your entire user base as JSON or CSV files for backup, analysis, or migration purposes. You can also import users from these formats to populate environments.

Exporting Users

Export as JSON

  1. Click the export button in the Authentication toolbar.
  2. Select Export as JSON.
  3. Choose a save location in the file dialog.

The JSON export includes comprehensive user data:

  • User ID
  • Email address
  • Display name
  • Disabled status
  • Email verification status
  • Authentication providers
  • Creation date
  • Last sign-in date
  • Provider-specific metadata (Firebase custom claims, Supabase user metadata, Cognito attributes)

Export as CSV

  1. Click the export button in the Authentication toolbar.
  2. Select Export as CSV.
  3. Choose a save location in the file dialog.

The CSV export includes the same fields as JSON, with provider-specific metadata serialized as a JSON string in a single column.

How Export Works

Stackpane fetches all user pages from your authentication provider and combines them into a single export file. For large user bases, this may take a moment. A progress indicator shows the export status.

Importing Users

For importing users, see the Bulk Operations page which covers CSV and JSON import with preview and batched creation.

Use Cases

Backup

Regularly export your user base as a precaution before making bulk changes or deploying major updates.

Analysis

Export as CSV and open in a spreadsheet to analyze user trends, provider distribution, or sign-in patterns.

Migration

Export from one project and import into another when migrating between projects or environments.

Auditing

Export user data for compliance audits that require a snapshot of all user accounts and their properties.

Tips

  • Export before performing bulk operations as a safety net
  • Use JSON format for data that needs to be re-imported later (it preserves types better than CSV)
  • CSV is better for analysis in spreadsheets and external tools
  • Custom claims in CSV exports are stored as JSON strings and need to be parsed if used programmatically