In the User Management section of your portal, you can export all your users and their profile information to a CSV.
Create a User Data CSV Export
-
Navigate to
Settings > Users & rights > User Management.
-
Click Export to CSV.
-
You will receive an email with a download link.
Note
If you do not receive an email, please check your SPAM folder.
4. Click the download link and then click Download.
By default, the following fields are available in the CSV export:
-
First name
- Last name
- User ID
-
Username
-
Email Address
-
Last Login Date
- Account Status
-
Country
-
Phone Number
-
Job
-
Company Name
-
Department
-
Number of Logins
-
Permission Profile
- Assigned User Groups
- Created Date
- Deactivation Date
- SSO Only
-
Website
Please contact Support if you would like the following additional fields to appear in your export.
-
Department code
-
Address
-
Postal code
-
City
-
Twitter account
-
Linkedin account
-
State
-
Fax
-
Opening hours
-
Office Number
-
Cellphone number
-
Second address details
Note
All available user data will be exported. The CSV export will not reflect any filters applied in User Management.
Troubleshooting
The generated CSV is a semicolon-delimited file. Depending on the settings of your computer, the file might open misformatted. If so, see below for alternative ways of opening the file.
- Numbers:
- For Mac users, open the downloaded CSV file in Numbers.
- Google Sheets:
- Navigate to Google Sheets.
- Create a new blank spreadsheet, then click File > Import.
- In the Upload tab, select the downloaded CSV file from your computer.
- Click the Separator type dropdown and select Custom.
- Enter; in the Custom separator field, then click Import data.
- Excel:
- Before opening in Excel, first open the downloaded CSV in a text editor, such as TextEdit on a Mac or Notepad on Windows.
- Add one extra text line at the beginning of the file and enter sep=;.
- Save the file and reopen it in Excel.