Export Data from Stories

Users can easily export data for any chart, calendar, map, or table within Stories with just a few clicks.

Note: Summary tables are an accessibility feature, and as a result, users cannot currently export from them.

To export data from content within a Story, click the kebob menu in the top right-hand corner of any visualization or table.

For charts in Stories

Select "Export Data".

Users can export all data or a filtered subset of the data when selecting the Export Data from the Story content.

The "Filtered data" option in the export modal will only be available when 

1. Data is filtered using the Quick Filter Bar (QFB) on a chart, map, calendar, or table in the Story

2. The story page is filtered using the Global Filter Bar (GFB).

Once an export format is selected, your download will begin!

For tables in Stories

When users select “All data”, the export will include:

• All columns shown in the Column Side Panel are included.

When users select “Filtered data”, the export will include:

• All columns that are shown in the Column Side Panel

• Data filtered down by any Quick Filter Bar filters, Global Filter Bar filters.

There are various export outputs options including:

CSV

CSV for Excel

CSV for Excel (Europe)

RDF

RSS

TSV for Excel

XLSX*

XML

*A few important notes about the XLSX option:

It is only available for tables in Stories, it is not available for visualizations in Stories.

It exports your data but can also include formatting, such as groupings, column and row styling, and totals. This added structure can make it easier to interpret the data but means that the file might have extra rows to support these features.

We limit the XLSX export to roughly 5000 data points. This means, for flat/ungrouped tables, the limit is 5000 rows. For grouped and totaled tables, it is 5000 data points because it includes things like headers, groupings, detail rows, and totals in the count.

The date of export is appended to the title of the export from Stories. For users who consistently download data from Stories, this allows them to quickly see what version of the data they exported.

The format for the file name follows: File_Name_YYYYMMDD

Note: If you select XML, RDF, and RSS formats for export, the date will not be appended.