How to Copy Data from Tableau

Need to grab the data from a Tableau dashboard to use in a spreadsheet or another application? You're not alone. While Tableau is brilliant for interactive visualization, sometimes you need to pull the raw numbers out for a separate analysis, a PowerPoint slide, or to combine with data from another source. This tutorial will walk you through several easy ways to copy and export your data, from a quick copy-paste to downloading the full underlying dataset.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Would You Need to Copy Data from Tableau?

Before jumping into the "how," it's helpful to understand the "why." Most users need to export data from Tableau for one of these common reasons:

• Ad-Hoc Analysis: You want to run a quick calculation, create a pivot table in Excel, or play around with the numbers in a Google Sheet without altering the original Tableau dashboard.
• Combining Data: You need to merge the Tableau data with information from another system - like a CRM export or a financial spreadsheet - that isn't connected to your dashboard.
• Presenting Information: You’re building a report in Google Slides or Microsoft PowerPoint and just need a simple table or a few key numbers to display, not the entire interactive dashboard.
• Sharing with Others: You need to share a static snapshot of the data with a colleague who doesn't have access to Tableau Server or Tableau Reader.

Whatever your reason, Tableau provides a few different methods depending on exactly what you need.

Method 1: The Quick Copy-Paste

This is the fastest and most straightforward method, perfect for when you only need a small selection of summarized data points. This is like taking a screenshot, but for the actual numbers instead of the pixels.

How It Works

1. On your Tableau dashboard or worksheet, click on a data point (a bar in a bar chart, a slice in a pie chart) to select it.
2. To select multiple data points, hold down the Ctrl key (Cmd on Mac) while you click on different marks in your visualization. You can also click and drag your cursor to select a group of adjacent marks.
3. Once your data is highlighted, press Ctrl+C (Cmd+C) to copy it.
4. Navigate to your spreadsheet software (Excel, Google Sheets, etc.) and paste the data using Ctrl+V (Cmd+V).

When This Method Is Best

This approach is ideal for quickly grabbing a handful of summary values. For example, if you just need the total sales for your top three products from a bar chart, this is the perfect method. It's fast, simple, and gets you the aggregated numbers shown in the chart.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Limitations

The main drawback is that you're only copying the summarized data displayed in the view. You aren't getting the detailed, row-level data that makes up that summary. The formatting can also sometimes be a bit unpredictable when you paste it.

Method 2: Copying the Crosstab

A "crosstab" is just another name for a cross-tabulation table - think of a simple spreadsheet-style view of your data. This method is great when your visualization is effectively a table or matrix and you want to preserve that structure when you copy it.

How It Works

1. Go to the specific worksheet that contains the data visualization you want to copy.
2. In the top menu bar, navigate to Worksheet > Copy > Crosstab.
3. This action copies the entire dataset as shown in the worksheet to your clipboard in a structured, tabular format.
4. Open Excel or Google Sheets and paste the data.

You'll notice that the data is neatly organized into rows and columns, just like a standard table, making it much cleaner to work with than a simple copy-paste from a chart.

When This Method Is Best

Use the crosstab method when you want to export the summary data from a worksheet in a clean, table-like format. It’s perfect for copying tables, matrix charts, or highlight tables directly into a spreadsheet without losing the row and column structure.

Method 3: Viewing and Exporting the Underlying Data

This is the most powerful method. It allows you to access and export the full, granular, row-level data that powers your visualization, not just the summarized numbers you see on the screen. This is how you "get all the data" behind a chart.

How to View the Full Data

First, you need to open the View Data window. You have a few ways to do this:

• Select a mark (or multiple marks) in your visualization. Hover over one of the selected marks until the tooltip appears, and then click the "View Data" icon (it looks like a small table).
• Right-click on a mark in your viz and select "View Data" from the context menu.
• If you want to see the data for the entire worksheet, make sure no marks are selected, then right-click anywhere in the view and choose "View Data."

A new window will pop up. At the top of this window, you’ll see two or more tabs:

• Summary: This shows the aggregated data for the selection. For example, if you selected a single bar representing total sales for "California" in June, the summary tab would show one row with those details: State (California), Month (June), and the total sales figure.
• Full Data: This is the key. This tab shows every single individual row from your original data source that contributes to your selection. In the California example, this would be a list of every single sale made in California during June.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

How to Export the Data

After clicking into the "Full Data" tab, you'll see a button in the upper-left corner labeled "Export All." Clicking this button will prompt you to save the data as a comma-separated values (CSV) file. This CSV can be easily opened in Excel, imported into Google Sheets, or used in almost any other data tool. You also have the option to check boxes next to specific rows and export just that selection if needed.

Method 4: Downloading From a Published Tableau Server or Cloud Dashboard

If you're interacting with a dashboard that has been published online (on Tableau Server or Tableau Cloud), the process is even more user-friendly, provided the author has enabled download permissions.

How It Works

1. In your browser, navigate to the dashboard you want to pull data from.
2. In the toolbar at the top or bottom of the dashboard, look for a "Download" button (it's often an icon of a down arrow).
3. Click the "Download" button. You’ll be presented with several options, such as:

• Image: Creates a PNG image file of the dashboard view.
• Data: This opens the "View Data" window discussed in Method 3, giving you access to the summary and full underlying data. From there, you can export to a CSV.
• Crosstab: Lets you download the data in a CSV file, formatted as a crosstab.
• PDF: Creates a static PDF report of the dashboard.
• PowerPoint: Creates a PowerPoint presentation with the dashboard view as a static image on a slide.

A Note on Permissions

A very common source of frustration is when the "Download" button or a specific option (like 'Data') is missing. This is not a bug. Dashboard authors and server administrators can set permissions to disable downloads. If you can’t see the option to export, it’s most likely because permissions for it haven’t been granted for that specific dashboard or your user role.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Is Copying Data from Tableau Always the Best Idea?

While extremely useful, manually exporting data is a temporary solution. It's great for one-off tasks, but it's not a sustainable process if you find yourself doing it repeatedly. The moment you export data from Tableau, it becomes a static, disconnected copy. If the data in Tableau updates, your exported spreadsheet doesn't - you have to repeat the entire process.

Relying on this manual process often leads to what many reporting managers dread: spending Monday mornings exporting CSVs, wrestling with them in spreadsheets to prepare a report, and delivering it just in time for follow-up questions that require starting the process all over again. By the time you have the full picture, half the week is gone and the data is already out of date.

Final Thoughts

Whether you need a quick copy-paste, a structured crosstab, or the full underlying dataset, Tableau provides several ways to get your data into another application. Knowing which method to use - from a simple keyboard shortcut to the "View Data" window - can save you time and help you get the exact numbers you need for your task.

But constantly pulling data from one system just to put it into another is a clear sign that your reporting workflow has some friction. At Graphed, we’ve found that the real goal isn't just to make it easier to export data but to eliminate the need for manual exports altogether. We do this by allowing you to connect all your data sources - from Google Analytics and Salesforce to your ad platforms and financial tools - in one place. Instead of spending hours copying data to build reports, you can simply ask a question in plain English and instantly get a live, real-time dashboard that always stays up to date. The best solution isn't becoming faster at manual exporting, but finding tools like Graphed that can automate the entire reporting process altogether.