View Underlying Data
View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view.
The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.
Important: View Data column order has changed in Tableau 2020.2 and later: When you open a data source from a previous version of Tableau in Tableau 2020.2 or later, the column order may be different. Columns may be displayed differently in the View Data window, and the column order may be different when you export it to CSV format. This change in how column order is handled in the View Data window is required to support relationships and logical tables. If you use scripts that depend on a customized column order, we recommend using the Tableau Extensions API for View Data to download underlying data to CSV format.
View Data from the data source
The View Data icon is available on the Data Source page and on the Data pane on a sheet. Viewing data from the data source before or during analysis can be useful to give you a sense of the scope of each table, its fields and their values, and general impressions about the data.
Data Source page
In the Data Source page, hover over a table or sheet in the left pane to display the View Data icon .
The View Data window displays the data for that table.
Be aware that the two icons at the top of the data grid in the Data Source page toggle the data grid presentation between “Preview the data source” and “Manage metadata” and neither are View Data.
In a worksheet, the View Data icon is located at the top of the Data pane, below the data source list and to the right of the Search box.
The View Data window displays a tab for every table in the data source. Tables that are joined or unioned make up a single tab, as they are represented as a single logical table in the data model.
View Data for a mark
Tableau visualizations are, essentially, created by aggregating measures based on the structure of the dimensions in the view and displaying the results as a mark. You can use View Data to reveal the underlying data represented in that mark.
Click on a mark to display its the tooltip. In the tooltip menu, click the View Data icon . You can also select multiple marks simultaneously and see their combined View Data results.
The View Data window displays multiple tabs:
- The summary tab which shows the dimensions that define the view and the aggregated measure or measures that make up the mark.
- A tab for each table that has a measure present in the view, showing all fields from that table.
- If “Show all fields” is checked, each tab will also show all dimensions that define the view, regardless of which table they’re from.
- Some calculations used in the view may get their own tab as well:
- Calculations that do not belong with a table in the Data pane, such aggregate calculations or calculations that span tables.
- LOD calculations (
INCLUDEonly), even if they reside in a table in the Data pane. (Ad-hoc LOD calculations are not shown in View Data.)
- All relevant fields used in the calculation will be displayed, regardless of their original table, as well as the value of the calculation itself.
View Data from the Analysis menu
To see the underlying data for the entire view, in the Analysis menu, select View Data. The View Data window is displayed with similar results for viewing data for a mark, but instead it displays all of the data in use in the view.
Copy or Export All from the View Data dialog
You can copy the data out in the View Data window for use in a spreadsheet or another Tableau workbook (really, anywhere you can paste text).
- Select the rows or columns of interest (or the empty square to the left of the first column header to select the entire display) and click the Copy button, then paste the data into a spreadsheet, another Tableau workbook, or another destination of your choice.
- Click the Export All button to export the current tab as a .csv file. Export All is not limited to 10,000 rows like the View Data window display.
If you are a workbook author and want to ensure your audience can’t copy out the underlying data, you may want to consider turning off the command buttons in the tooltips(Link opens in a new window) or denying workbook permissions(Link opens in a new window) to the summary or full data.
Why can’t I see the View Data icon?
If you are in Tableau Desktop and cannot find the View Data icon for a mark, check that tooltips are enabled and the tooltip menu command buttons are not turned off. Alternatively, right click on a mark and select View Data from the menu. This method will work even if tooltips or command buttons aren’t enabled.
If you are looking at a published viz and cannot find the View Data icon for a mark, it may be that tooltips are not present, the command buttons have been turned off, or you may not have the necessary permissions.