For folks who download crosstabs from Tableau dashboards, this tip is for you!

To demonstrate this tip, let’s use a simple crosstab with Superstore data.

To begin your download, simply click the download button and select crosstab.

Once you select Crosstab, you are presented with a few additional options: The sheets you wish to download, and a choice between Excel or CSV file formats.

This is where the fun begins! If you select Excel, your download file will be formatted the same way it appears in Tableau. Notice the merged cells in this screenshot:

Alternatively, the CSV format populates each column & each row with the corresponding data. In other words, without merged cells.

Voilà! Two options for downloading crosstabs. If you’d like to take this tip for a test drive, you can find my Tableau workbook published on Tableau Public.

Happy Vizzing!