Important Notice

The content in this space is currently being migrated to the cloud. Any content edits must be made by a Knowledge Base admin until migration is complete.
To request content edits, please submit a request to the Strategic Operations Training Team and include the page URL and details on required edits.
A member of the Strategic Operations Training Team will reach out for clarity if needed.

Tableau: Downloading Tableau Data

Tableau allows users to configure data and save it locally. This page outlines how to download data from Tableau in different formats. Some Tableau dashboards contain multiple tabs that represent each worksheet in the dashboard. Data is only downloaded from the active worksheet. This does not apply to Views which contain the same data elements but organized differently.

Select the Download option, located on the Tool Bar. The Tool Bar is displayed at either the top or bottom of the screen.

Select the file format for the data export. Refer to the additional instructions below for each specific file format. 

The additional instructions in the table below vary based on the option selected in the step above.

File Format

Output

Additional Steps

Image

Png. image file of the selected visualization.

N/A

DataUnderlying data in the Tableau workbook as a CSV file.
  1. Select Full Data.
  2. Check off the Show all columns box.
  3. Click on Download all rows as a text file.

Crosstab Allows for the export of a particular Tableau visual to an Excel or CSV file.
  1. Click into the Tableau visual that you would like to download into Excel. If you have selected a visual, Tableau will default to having that sheet selected in the next step.
  2. Select the sheet you wish to download.
  3. Select CSV. 
  4. Select Download.

Selecting Excel format can result in merged cells in Excel, which can pose challenges for data analysts.

PDFVisual(s) will be opened in a PDF file.
  1. Select the view(s) you would like to export.
  2. Adjust the scaling, paper size, and orientation as necessary.
  3. Select Download.

PowerPointVisual(s) will be opened in a PowerPoint file. Each visual selected will have a separate slide.
  1. Select the view(s) you would like to export.
  2. Select Download.

Tableau WorkbookEntire Tableau Workbook will be downloaded.
  1. Select the Tableau version you would like the workbook exported to. For most users, this will be the current version. Check for accuracy on this statement.
  2. Select Download.