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.

Tip:

Reporting on your Labels can be done in any number of ways through our CSV exports. Each export includes all your Labels per post. For a few advanced tips on Labels reporting in Excel, head over to our expert section in this article.

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.

Tips for Labels analysis through Excel

If you've exported your Dashboard as a CSV file and would like to run a series of common analyses on your Labels, we've got a few examples of what you can achieve with a series of relatively simple Excel formulas.

To add the name of a unique value, such as your Label names, to the top of a column, you can follow these steps in Excel:

  1. Add a new row at the top of your excel file.
  2. Select the cell at the top of your first label column, in the row you just created.
  3. Set the cell value to the following: =UNIQUE(O3:O), where O is the column your cell is in, and 3 is the row number for right below your column names. Press Enter.
  4. Copy the cell from step 3 to all cells at the top of any label column.
  5. Your columns are now named after the label in the column.
  6. Optional: You can hide the first row to which the formula from step 3 was added by right clicking on the row number at the far left, and choosing 'Hide row' from the context menu.

If you would like to report on the number of times a certain Label has been used, you can follow these steps in Excel:

  1. Add a new row under your column names row.
  2. Select the cell at the top of your first label column, in the row you just created.
  3. Set the cell value to the following: =COUNTIF(O3:O; "*"), where O is the column your cell is in, and 3 is the row number right below your current cell. Press Enter.
  4. Copy the cell from step 3 to all cells at the top of any label column.
  5. At the top of your columns you can now see the total number of times the label in that column was used.
  6. Optional: You can sort your columns from most used to least used by selecting all cells of all label columns, and choosing Sort under the Data tab. Set sorting from Left to right under the Settings, and choose to sort 'Largest to Smallest' for the row in which your total label numbers are displayed.

To add all Labels together in one cell, separated by commas, you can follow these steps in Excel:

  1. Add a new column to your Excel file, to the right of the N column.
  2. Select the cell in the new column that is in the row of the first post in your report.
  3. Set the cell value to the following: =TEXTJOIN(",",TRUE,P4:$4), where P is the column immediately right to your current cell, and 4 is your current row. Press Enter.
  4. Copy the cell from step 3 to all cells in the same column.
  5. All labels are now added together per post, separated by commas, in the cells you added the formula from step 3 to.

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?
3 out of 3 found this helpful