Exporting DATA from Tableau to Excel

by Jennifer Hunter, Analytics Manager

No matter how beautiful and informative and actionable your Tableau visualizations may be, there will always be a person or use case for exporting data to a tabular format usually via excel.

Though this is still surprisingly more difficult than it should be, there are some ‘non-coding’ options to help satisfy this requirement. 

Let’s go through the “easy” options for allowing others to get the data behind your visualizations and what to expect from the output.

First, the easiest and really ONLY way to export everything on a dashboard at once to a single excel workbook is to use the ‘Export All Extension’ developed by the Information Lab (for Tableau version 2018.2 or later). This extension allows you to create a nice export button on a dashboard which will prompt you to select which sheets and columns you want to export.  Note, if using this for business dashboards with sensitive data, be aware of the security issues around its use.  The remaining options for retrieving data require exporting a single sheet at a time.

From Tableau Desktop there are several built-in options explained in Tableau’s help documentation here.  You can export your entire data source or a subset from the data source page or from the data pane within a view. 

The export options are to a .csv file or as an extract (.hyper) file or as a tableau data source (.tds) file.  Any of these can then be used to connect directly to Tableau or share the data for others to use.  If you only want the data used to create a single view or sheet, the options are to either export/copy to .csv or to a crosstab in excel. 

The main difference between these two options is the control over the output. 

The .csv does not preserve formatting so the fields used the create the view will appear in alphabetical order whereas the crosstab will preserve formatting (unless you turn this off) which will give a “prettier” appearance to your end-user.  If you have larger data, the performance of the crosstab could be impacted or error out in my experience.  To exercise a bit more control you can use aliasing to force column order when using the .csv option or you can also simply create the exact view your users want to export depending on the needs of your use case.

In most cases, your users will want an easy way to export data from Tableau Server where they typically access the content you create. If preservation of formatting is preferable, then simply selecting the viz/sheet you want to export on your dashboard and then clicking the download icon at the top right of the window and selecting ‘Crosstab’ is the best option. This method does require brief end-user education, but the output is “pretty”, will account for any filtering done before exporting, and can handle a large data set.

You can also select the ‘Data’ option from the Download menu if formatting is not necessary, but the same rules will apply to this output as it does from Tableau Desktop. If you do not want to have to educate your end-users and desire an “Easy button” then follow the directions from Andy Kriebel here in which he shows you how to easily append .csv to the end of your dashboard URL and embed that within an image icon on your dashboard. Note, this method will behave like the other .csv exports described above. You can also pass parameter/filter values to the URL described here. 

While this list may not be exhaustive (it does not include “coding” options such as using Javascript), it should provide at least one easy option to satisfy your use case for tabular data!


Jennifer Hunter

Analytics Manager

Jennifer Hunter is a Manager of Analytics Consulting at Data Ideology with more than 7 years of experience encompassing many areas of reporting, analytics, and mathematics.
Read more.


Why do you need a Data Strategy now more than ever?

With increasing globalization and technology developments spurring modern economics, Data Strategy has been vital in identifying and understanding customers.
Data Management

Data Modeling is the Key to Success

A data model enables you to make decisions based on facts instead of educated guesses. However, the value goes far beyond that. With data modeling, you’re easily able to store and access information that will benefit you and your organization.
Data Science

Predictive Analytics can help reduce your Data Decay

Data decay is a pervasive problem in many industries that can lead to frustrated customers and a lack of trust in a business.