Export User Data Via CSV

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

  1. Navigate to settings_menu.pngSettings > Users & rights > User Management.

  2. Click Export to CSV.

  3. 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.

  1. Numbers:
    • For Mac users, open the downloaded CSV file in Numbers.
  2. 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.
  3. 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.

Updated

Was this article helpful?

0 out of 0 found this helpful

We're sorry to hear that!

Find out more in our community

Have more questions? Find out more in our community