Exporting the content of a chart

You can export the data contained in charts in Comma-Separated Values (CSV) or Tab-Separated Values (TSV) format using the Export chart window. The export, like the chart, contains only the first 1000 lines of data.

Before you begin

Make sure that you are granted the appropriate permissions. See Setting permissions to manage dashboard templates.

About this task

You can also use the provided REST API to export the content of a chart. See Using the REST API.

Procedure

To export the content of a chart:

  1. Click the overflow menu menu of the chart and select Export to... to open the Export Chart window.
  2. Choose an export format: CSV or TSV.
  3. Modify the File name, by default set to the name of the chart in the dashboard, as required. Enter a name that cannot be empty, and does not exceed 120 characters. Special characters are limited to hyphens (-), underscores (_), dots (.), and spaces.
  4. Select the Include title and description checkbox if you want them included in the exported file as comments.
    The Title, by default set to the name of the chart in the dashboard, and the Description, by default set to the description of the chart, are written in the first two lines of the exported file, preceded by #. However, when reading the CSV or TSV file, not all tools accept comments.
  5. Update the Title and Description as required. The Title must not exceed 120 characters.
  6. Click Export to generate the file.
  7. Open the exported file in applications like Microsoft Excel or Apple Numbers to view it as a spreadsheet.