Crosstab Export Differs Between Tableau Server and Desktop

Published: 01 May 2014
Last Modified Date: 13 Mar 2018


When you export a view as a crosstab from Tableau Server, the resulting CSV file might differ from the CSV you get using the Crosstab to Excel export feature in Tableau Desktop.


Tableau Server 


Use one of the following workarounds.

Option 1: Export from Tableau Desktop.
  1. Download the workbook from Tableau Server.
  2. Open the downloaded workbook in Tableau Desktop.
  3. Select Worksheet Export Crosstab to Excel.

Option 2: Format the fields that are incorrectly summed to display with decimals.
  1. Open the workbook in Tableau Desktop.
  2. Right-click the field you want to edit in the Measures pane and select Default Properties Number Format.
  3. Choose Number (Custom).
  4. Under Decimal Places, select at least 2, then click OK.


The export from Tableau Server exports the underlying data, while the export from Tableau Desktop exports the data in the view.
Did this article resolve the issue?