Downloading data from Tableau Reader is possible, allowing you to extract information from displayed tables directly into an Excel format for further analysis. This process focuses specifically on exporting a 'Crosstab' view of the data.
Exporting Crosstab Data from Tableau Reader
Tableau Reader provides a straightforward method to export the data displayed in a table visualization. This is particularly useful when you need to work with the summarized, aggregated data shown in the table itself, rather than the underlying row-level details.
Step-by-Step Guide to Exporting to Excel
Follow these steps to export data from a table within a Tableau Reader workbook:
- Filter the Table: Begin by applying any necessary filters within Tableau Reader to display only the specific data you wish to export in the table. Ensure the table visual reflects your desired subset of data.
- Click the Table: Left-click directly on the table visualization within the dashboard or sheet. This action selects the table, making it the active element for export.
- Navigate the Menu: Go to the main menu at the top of the Tableau Reader window.
- Click on Worksheet.
- Hover your mouse over Export.
- Click on Crosstab to Excel.
- Data Appears in Excel: An Excel spreadsheet will automatically open on your computer. This sheet will contain the data exactly as it appeared in the selected table within Tableau Reader, formatted as a crosstab.
This exported data is now available in a standard spreadsheet format, ready for you to save, analyze, or manipulate using Microsoft Excel or compatible software.
Understanding the Export
It's important to note that this method exports the data as a crosstab. This means the data is structured with measures summarized across dimensions, mirroring the layout of the table in Tableau Reader. This is different from exporting the full underlying data for each mark, which is a capability typically found in Tableau Desktop, not Reader.
By following these simple steps, you can easily extract the summarized table data you need from any Tableau Reader workbook.
