Exporting Data - Amazon QuickSight

Exporting Data

Using the Amazon QuickSight console, you can export data from any type of chart or graph. The export contains only the data in the fields that are currently visible in the selected visualization. Any data that is filtered out is excluded from the export file. You can export data into the following formats:

  • A text file containing comma-separated values (CSV), available for all visual types.

  • A Microsoft Excel workbook file (.xslx), available for pivot tables and table charts only.

The following rules apply:

  • Exported files are downloaded to the default download directory configured in the browser that you're currently using.

  • The downloaded file is named for the visualization that you exported it from. To make the file name unique, it has a sequential timestamp (a Unix epoch data type) or a date in the format yyyy-MM-dd_THH_mm_ss.SSSZ.

  • For table charts, Amazon QuickSight supports exporting up to 1 million rows or 500 MB of data, whichever limit is reached first.

    For all other visuals, including pivot tables, the limits that apply to exporting are the same limits that apply to the visual type.

  • You can't export data from an insight, because insights consume the data, but don't contain the data.

  • QuickSight doesn't support exporting data from more than a single visualization at a time. To export data from additional visuals in the same analysis or dashboard, repeat this process for each visual. To export all the data from a dashboard or analysis, you need to connect to the original data source using valid credentials and a tool that allows you to extract data.

Use the following procedure to export data from a visualization in Amazon QuickSight. Before you begin, open the analysis or dashboard that contains the data that you want to export.

To export data from a visualization

  1. Choose the visualization that you want to export. Make sure that it is selected and highlighted.

  2. At top right on the visual, open the menu and choose one of the following:

    • To export to CSV, choose Export to CSV.

    • To export to XSLX, choose Export to Excel. This option is available only for pivot tables and table charts.

  3. Depending on your browser settings, one of the following happens:

    • The file automatically goes to your default Download location.

    • A dialog box appears so you can choose a file name and location.

    • A dialog box appears so you can choose to open the file with the default software or to save to.