Exports

Every report table has CSV, Excel and PDF buttons in its title bar, next to the row count. An export contains the rows as you see them: with the filters you switched on and in the order you sorted them.

The three formats

Format	Best for	What you get
CSV	other tools, scripts, imports	Plain text, one row per line. A cell that would start a spreadsheet formula gets a leading apostrophe, so opening the file in Excel cannot run a formula.
Excel	analysis, sharing, evidence	One sheet named “Data” with real numbers, dates and yes/no values, a bold header row that stays in place while you scroll, and a filter on every column.
PDF	printing, attaching to a review	A4 landscape, the header repeated on every page, page numbers. The first 2,000 rows; a note on the page says when the report has more (the Excel file has them all). Very long cell texts are shortened.

An export holds every field of the report’s rows, which can be more than the table shows. Lists are written as a; b, and dates in the ISO format (for example 2026-10-29).

Your export settings

Each user sets these under Settings > Export:

• CSV separator: comma, semicolon or tab. Excel with German or other European regional settings expects a semicolon.
• Add a UTF-8 marker (BOM) to CSV files: without it, Excel can show accented characters wrongly when you double-click the file.
• File name: a pattern with the placeholders {report}, {date}, {time} and {tenant}.
• Pseudonymise personal data: replaces e-mail addresses and user principal names with codes such as user-3f9a1c0b2e, and people’s names with person-.... The same value gets the same code within one file, so you can still count and group. Names of groups, devices, apps and policies stay readable. Each export uses new codes, so two files cannot be joined on them.

See Exporting data for the steps.

Automated exports

To pull report data on a schedule instead of by hand, use the report API. It returns the same rows as JSON.