Export a Dashboard to CSV or PDF

The content of your Dashboards can be exported to a CSV from inside Falcon, or to a PDF by using your browser’s native ‘Print to PDF’ functionality. These exports can be shared with third-party stakeholders that do not have access to Falcon. Furthermore, your CSV exports can function as the basis for further number crunching in your spreadsheet software of choice.

Export your Dashboard to a CSV file

The option to export to a CSV is available in all the Dashboards you've created in Falcon. You can either simply export your Dashboard as is, or you can create a custom export with certain metrics added or removed.

Each CSV export will download in your browser as a .zip file. Within the .zip file, you will find a separate CSV for each widget in your Dashboard. After extraction, the CSV files can be opened in any spreadsheet software, such as Microsoft Excel or Numbers on Mac.

Note:

Miscrosoft Excel will not always display special characters correctly. If your CSV file contains special characters, we recommend to open it in Excel through the Import menu found under File > Import. During the import process, you can set the character set to 'Unicode (UTF-8)', which will display the special characters correctly.

Mac Numbers and LibreOffice will handle special characters correctly by default. However, files opened in these two software packages will contain a first row with an Excel-specific command called 'sep='. This first row can be deleted without issue.

Export your entire Dashboard to CSV

Exporting an entire Dashboard to CSV can be done with the following instructions:

  1. Open your Dashboard in View mode.
  2. Click the Export icon in the top right and choose the option 'Export dashboard as CSV' from the dropdown menu.
  3. Falcon will compile your CSV file in the background. This may take several minutes for Dashboards with a lot of data. You can continue using Falcon in the meantime. Once your file is ready, it will start the download automatically.

Create a custom CSV export

Through a custom export, you can add extra metrics to any of your Widgets, or remove Widgets that you don't need in your CSV export. The effects are only applied to your CSV export file and will not be reflected in your Dashboard itself. Here's how you can customize the export:

  1. Open your Dashboard in View mode.
  2. Click the Export icon in the top right and choose the option 'Customised export' from the dropdown menu.
  3. You will see an overview of all Widgets in your Dashboard. Uncheck any of the checkboxes to the left of each Widget to exclude them from your export. Hover over any Widget card and click the + icon on the right side to add metrics to that widget.
  4. Once you're done with customizing your export, click the 'Export to CSV' button.
  5. Falcon will compile your CSV file in the background. This may take several minutes for Dashboards with a lot of data. You can continue using Falcon in the meantime. Once your file is ready, it will start the download automatically.

Print your Dashboard to a PDF file

Apart from CSV exports, your Dashboards can also be exported in the more visually pleasing PDF format. Here's how:

  1. Open the Dashboard that you want to export.
  2. Scroll all the way to the bottom to ensure the entire page is loaded.
  3. Choose the Print option in your browser’s menu or hit Cmd/Ctrl+P.
  4. Adjust the export settings as described per browser, below in this article.
  5. Click the Save/Print button.

Chrome

These are the recommended printing options for Chrome. Some of the settings can be found under the ‘More settings' option. We recommend keeping all default settings except for:

Destination
Save as PDF
Layout
Landscape
Paper size
A4
Headers and footers
Uncheck

For a portrait PDF, take the recommended settings but change the Layout option to Portrait and set the Scale to 80.

Firefox

These are the recommended printing options for Firefox. Some of the settings can be found under the ‘Show details' option. We recommend keeping all default settings except for:

Orientation
Landscape
Page Headers
Blank
Page Footers
Blank
Bottom left dropdown menu
Save as PDF

For a portrait PDF, take the recommended settings but change the Orientation option to Portrait.

Safari

These are the recommended printing options for Safari. Some of the settings can be found under the ‘Show details' option. We recommend keeping all default settings except for:

Paper size
A4
Orientation
Landscape
Print headers and footers
Uncheck
Bottom left dropdown menu
PDF

For a portrait PDF, take the recommended settings but change the Paper Size option to A3.

Edge

These are the recommended printing options for Edge. Some of the settings can be found under the ‘More settings' option. We recommend keeping all default settings except for:

Printer
Save as PDF
Layout
Landscape

For a portrait PDF, take the recommended settings but change the Layout option to Portrait and set the Scale to 75.

Was this article helpful?
2 out of 2 found this helpful