Output reports as CSV file

You can execute or schedule most standard reports as a comma-separated values (CSV) file, which allows data to be saved in a tabular format that can be used with most any spreadsheet program, such as Microsoft Excel or Google Spreadsheets.

Note the following attributes of a report output as a CSV file:

  • The report always includes the column headers as the first row.
  • The report maintains the defined grouping in the report and provides the grouped data and detailed data in the report output.
  • Depending on how the report is configured:
    • If the report contains multiple tables, only one table as defined by your administrator (in the CSV_Export_Table_Name parameter) is output as in CSV.
    • The report provides the columns in the order defined by your administrator (in the CSV_Export_Column_Names_Order parameter). Hidden columns are not included in the CSV report.
  • The report provides all “measures” (numeric values) as unformatted. The user must format the numeric values as needed.