Exporting data
Download a table
Section titled “Download a table”- Open the report and set it up the way you want: switch filters on, filter columns, sort.
- In the table’s title bar, next to the row count, click CSV, Excel or PDF.
- Your browser downloads the file.
The file contains the rows that pass your filters, in the order on screen, with every field of the report’s rows (sometimes more columns than the table shows). A large PDF takes a few seconds to build.
| Choose | When |
|---|---|
| Excel | You want to sort, filter or count further, or hand the list to someone. Numbers and dates are real values. |
| CSV | Another tool or script reads the file. |
| You want a printable record. A PDF holds at most 2,000 rows; for more, use Excel. |
See Exports for the details of each format.
Set up your exports
Section titled “Set up your exports”Under Settings > Export (these settings apply only to you):
- CSV separator: pick Semicolon if your Excel uses German or other European regional settings, otherwise Excel puts every row into one column.
- Add a UTF-8 marker (BOM) to CSV files: switch on if accents and umlauts look wrong when you double-click a CSV file.
- File name: build the name from
{report},{date},{time}and{tenant}. The Example line shows the result. - Pseudonymise personal data: replace e-mail addresses, user principal names and people’s names with codes, for example when you share an export outside IT. The same person gets the same code within one file.
- Many rows? Prefer Excel; it has no row limit and keeps the numbers as numbers.
- The same export every week? Ask your administrator for an API client, and let a script fetch the data as JSON on a schedule.
- Evidence for a review? Export the findings list with All selected, so OK rows show what was checked too.