KNOWLEDGE BASE

Exporting in Excel File Format


Published: 07 Aug 2013
Last Modified Date: 03 Oct 2017

Question

How to export a crosstab from Tableau Server to .xls or .xlsx.

Environment

Tableau Server

Answer

Tableau Server 9.2 and newer versions: 

  1. Open the view on Tableau Server, and then select Download > Crosstab.
  2. Open the resulting .csv file in Microsoft Excel.
  3. In Excel, save the file with a .xls or .xlsx file extension.

Tableau Server 9.1 and earlier versions: 

  1. Open the view on Tableau Server, and then select Export > Crosstab.
  2. Open the resulting .csv file in Microsoft Excel.
  3. In Excel, save the file with a .xls or .xlsx file extension.
Did this article resolve the issue?