How to Export Data in Tableau

Tableau is a phenomenal tool for visualizing and interacting with your data, but sometimes you need to get that data out of Tableau and into another format. Whether you need a simple image for a presentation or the full underlying dataset for analysis in a spreadsheet, there are several ways to export what you see. This guide will walk you through the most common methods for exporting your hard work from a Tableau worksheet, dashboard, or data source.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Would You Need to Export Data from Tableau?

While Tableau is designed to be an all-in-one analysis and visualization platform, exporting your work is a common part of the data workflow. Some of the most frequent reasons include:

• Sharing with others: The simplest reason is to share your findings with colleagues or stakeholders who don’t have access to Tableau Desktop or Tableau Server. A quick PNG or PDF can be easily emailed or dropped into a slide deck.
• Further analysis in other tools: You might want to run specific statistical models, create a complex financial forecast, or simply manipulate the data in a way that’s more familiar to you in a tool like Excel or Google Sheets.
• Creating presentations and reports: While you can present directly from Tableau, many people prefer to integrate their charts and data summaries into PowerPoint, Google Slides, or Word documents as part of a larger narrative.
• Archiving data: Saving a snapshot of the data from a specific point in time as a CSV file can be a useful way to archive or backup key findings.

Whatever your reason, mastering Tableau's export functions will make your analytics process more flexible and efficient.

Option 1: Exporting Visualizations as an Image, PDF, or PowerPoint

This is the most straightforward export method and is perfect when you need a static representation of your chart or dashboard. It’s a "what you see is what you get" process that captures the visual element of your work.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Export as an Image (PNG, JPEG, etc.)

If you need to drop a single chart into an email, Slack message, or presentation slide, exporting it as an image is your best bet. PNG files are generally best for charts with text as they maintain sharpness, while JPEGs are good for more complex visualizations with gradients or photos.

Here’s how to do it:

1. Navigate to the worksheet or dashboard you want to export.
2. From the top menu, click Worksheet > Export > Image... (if you're on a worksheet) or Dashboard > Export Image... (if you're on a dashboard).
3. An "Export Image" dialog box will appear. Here, you can select the image format (PNG, BMP, JPEG are common), whether to include a title and caption, and how you want the legend to appear.
4. Click Save and choose where to save your file. A static image of your view will be created.

This is incredibly useful for quick shares where interactivity isn't needed.

Export as a PDF

Creating a PDF is a better choice when you need to print a high-quality version of your dashboard or combine multiple worksheets into a single, shareable document. The quality is vectorized, meaning it will remain sharp even when you zoom in.

Here’s how to create a PDF:

1. From the top menu, go to File > Print to PDF....
2. The "Print to PDF" dialog box gives you several customization options.
3. You can choose what to include in the export: the entire workbook, just the active sheet, or specific sheets that you select.
4. You can also control the paper size and orientation (Portrait vs. Landscape), which is important for getting multi-page dashboards to format correctly.
5. Click OK and save your PDF file. The resulting document is a professional, high-resolution copy of your work.

Export to PowerPoint

A recent and highly requested feature, Tableau now allows direct export to PowerPoint. This is far more efficient than exporting as an image and then pasting it into your slides.

1. Navigate to the sheet or dashboard you want to include in a presentation.
2. From the menu, choose File > Export as PowerPoint....
3. Tableau creates a new PowerPoint presentation. Each selected sheet becomes its own slide, and captions are automatically placed into textbox notes for context. The image is a crisp, high-quality export to the slide.

This method saves time and preserves the quality of your visuals, making report creation much smoother.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Option 2: Exporting Aggregated Data (Crosstab)

Often, it’s not the chart you need, but the summary data behind the chart. This is the aggregated data visible in your visualization. For example, if you have a bar chart showing sales per region, exporting a crosstab gives you a simple table with one column for regions and another for the sum of sales.

This is commonly referred to as exporting to a "crosstab" format, and Excel is the most common destination.

How to Export a Crosstab to Excel

1. Open the worksheet or dashboard containing the data you want to export.
2. From the top menu, select Worksheet > Export > Crosstab to Excel.
3. Tableau will prompt you to save the file. If you are on a dashboard with multiple worksheets, it will ask which sheet's data you wish to export.
4. Excel will automatically open with your summary data formatted in a simple table, preserving the structure you see in your Tableau view.

An Alternative Copy & Paste Method

For a quicker export that doesn't require saving a new file, you can copy the data directly.

1. In your Tableau worksheet, select the data points (or marks) you want to export. You can click-and-drag to select multiple marks at once.
2. Right-click on your selection and choose Copy > Crosstab.
3. Open Excel or Google Sheets and simply paste (Ctrl+V or Cmd+V). The summary data will appear, ready for you to work with.

Option 3: Exporting the Full, Underlying Data

Sometimes summary data isn't enough. You need the full, raw, row-level data that powers your worksheet. For instance, if your bar chart shows total sales by region, exporting the underlying data would give you every single sales transaction that was used to calculate those totals, including columns not even used in the chart.

This is useful for detailed audits, deeper dives in another tool, or just for understanding the full context of your visualization.

Using the View Data Window

The key to accessing underlying data is the "View Data" window.

1. Make sure you’re on the worksheet you need data from. If you're on a dashboard, select the specific chart within the dashboard.
2. Hover your mouse over the visualization. A small menu will often appear. Click the "View Data" icon (it looks like a small table).
3. Alternatively, you can access this from the menu by clicking Worksheet > Export > Data....
4. A new window pops up. It will have two tabs at the top: Summary and Full data. The "Summary" view shows the aggregated data (just like the crosstab export).
5. Click on the "Full data" tab. This will display all the rows and columns from your original data source that are relevant to your current selection.
6. Near the top of this window, you’ll see the number of rows. An "Export All" button is just below. Click it.
7. You'll be prompted to save your data as a Comma Separated Values (CSV) file. This format is universally compatible with nearly any data tool, from Excel to Python.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Important Note:

Filters and selections in your worksheet will also apply to the underlying data export. If you have filtered for a specific date range, your CSV will only contain data from that range.

Tips for Better Exporting

Follow these tips to avoid common frustrations and ensure you get exactly the data you need:

• Check Your Filters First: Exports reflect the current state of your worksheet. Double-check any filters on your view before exporting to make sure you’re not accidentally excluding data you need (or including data you don't).
• Know the Difference: Always be clear about whether you need aggregate/summary data or full/underlying data. Choosing "Crosstab" when you need "Full data" is a very common mistake.
• Manage Large Exports: If you are trying to export a massive dataset (millions of rows), Tableau may slow down or become unresponsive. If possible, apply filters to narrow down your data to a more manageable size before exporting the full set.
• Formatting is Visual: The beautiful formatting, colors, and font choices in your Tableau dash will not transfer when you export the raw or summary data. Expect a plain, unformatted table in Excel or your CSV file that may require some cleanup.

Final Thoughts

Exporting data from Tableau is a fundamental skill that bridges the gap between powerful visualization and practical data sharing. As we've covered, you can easily export a simple image, generate a clean PDF, grab the aggregated data for a quick summary in Excel, or download all the underlying details for a much deeper analysis.

Constantly exporting CSVs to do manual analysis in other tools often highlights a common friction point in many teams' reporting processes. Here at Graphed, we believe data should be instantly accessible and easy to query right where it lives. That's why we’ve focused on removing these manual steps, allowing you to connect sources and ask questions in plain English to build real-time, interactive dashboards without ever needing to export another file. If you're looking to speed up your reporting workflow and get answers in seconds instead of hours, give Graphed a try.