Exporting Data

Data can be exported from the User Administration app to the following formats: Excel XLSX and CSV. On all grid pages, you can find the export options by clicking the Export button  located on the top-right corner of the page: 

To export data:

1. If needed, filter or rearrange the grid content before exporting the data.
   Only rows that are filtered to show in the grid are exported, in their current order.

   • To filter the grid content, enter a search term in the Find field.
     The grid content is updated to only display rows that match your search.

   • To sort the grid content based on the content of a specific column, click the column header.
     Clicking the column header again reverses the sort direction.

Note: Row selections made using checkboxes have no impact on what is selected for export. All records filtered to the grid are exported.

2. Click the Export button on the top-right corner of the grid to open the export options.

3. Select Excel XLSX or CSV from the menu.

4. Depending on your browser settings, you will have the option to either open or save the file.

You can view and modify the content of XLSX file in Microsoft Excel if it is installed on your local computer.

The CSV option creates a generic Comma Separated Value file containing the records exactly as shown in the grid at the time of export. Note that a comma ( , ) is always used as the field delimiter, which may cause problems when opening the file on a computer configured for a language that uses a comma as a decimal point. In such cases you may need to edit the file and do a search-and-replace of all commas to semi-colons ( ; ) before trying to open/import the file in another app.