Export User Data Via CSV

  • Updated

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

  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. 

 

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.

Learn more

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