KNOWLEDGE BASE

Exporting a Crosstab to Excel 2016 Takes a Long Time


Published: 27 May 2016
Last Modified Date: 20 Apr 2018

Issue

When exporting a large number of marks as a crosstab of data in a view from Tableau Desktop to Excel 2016, the export takes long time.

Environment

  • Tableau Desktop
  • Microsoft Excel 2016
  • Windows

Resolution

Please use one of the following workarounds:

Option 1 

When the view you are exporting contains a lot of data, a dialog box opens asking whether you want to copy the formatting options. Choosing to exclude the formatting from the export may improve performance. 

Option 2 

  1. In Tableau Desktop, select Worksheet > Copy > Crosstab.
  2. Paste the crosstab into an Excel spreadsheet.

Option 3 

Export the data as an Access database file, and then export the table from Microsoft Access to Excel: 
  1. In Tableau Desktop, select Worksheet > Export > Data
  2. Select a location and type a name for your Access database file. 
  3. Click Save
  4. Open the Access database file in Microsoft Access. 
  5. Right-click the table in the Datasheet View and select Export > Excel
  6. In the Export - Excel Spreadsheet dialog box that appears, specify the destination file name and format, and click OK.
Note: You will need to have Microsoft Access installed for the above option. 

Option 4

Reduce the number of marks on the Tableau worksheet to reduce the amount of data exported. 
 

Cause

The Export Crosstab to Excel option simultaneously copies and formats the data. If the view being exported contains a large amount of data, performance of the export can be affected.  

Additional Information

Did this article resolve the issue?