Exporting Data from Reports

Every report displays an Excel icon to allow exporting the data into an XLSX file. And a printer icon to print it.

Report writers can add an option to a report to allow downloading a CSV (comma separated values) file instead. CSV files typically download faster when a report contains thousands of rows, and are generally easier to work with when the goal is to put the data into a spreadsheet, another database, or a fancy charting/graphing program.

The CSV option is added to a report in the Additional Display Formats section. A report with this option enabled displays "Click here for CSV Output" just above the data table when it is run. If you add this element to a report, we recommend clicking the Edit pencil in the CSV box and checking the "Headers in First Row" option.