In the User Management section of your portal, you can export all your users and their profile information to a CSV.
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.
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.
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.
Comments
0 comments
Please sign in to leave a comment.