# Tableau 2020.2: Improved crosstab export

> This is content from just-tim, the data-and-analytics channel by Tim Ngwena (formerly 'Tableau Tim'). Tim has 12+ years of hands-on BI experience and covers Tableau most of all, plus Power BI, Looker, Hex, SQL and data modelling, the analytics industry, and the craft of doing the job — always tool-agnostic and honest about the trade-offs.

- **Author:** Tim Ngwena (just-tim, https://just-tim.com/about)
- **Published:** 2020-05-06
- **Format:** Video · 2 min watch · transcript available
- **Topics:** Data visualisation
- **Tools:** Tableau (cloud, server)
- **Canonical:** https://just-tim.com/posts/tableau-2020-2-improved-crosstab-export
- **Watch:** https://www.youtu.be/csswV6D20MA

I walk through the improved crosstab export in Tableau 2020.2 on Tableau Server and Tableau Online. Previously you had to select a chart before the crosstab option became available, but now you can hit download and pick the sheet you want directly from a new interface.

## Key takeaways

- In older versions you had to click a chart first before the crosstab download option became active, with no visual feedback that anything was selected
- In 2020.2 you can hit download and choose your sheet from a new interface without pre-selecting a chart
- The sheet picker shows your worksheet names, so naming sheets properly is essential or users will see Sheet 1, Sheet 2, etc.
- The export downloads as a CSV that opens in Excel, with formatting applied to negative values out of the gate

Watch the full video, read the transcript and use chapter deep-links on the page: https://just-tim.com/posts/tableau-2020-2-improved-crosstab-export

---
just-tim — Data and analytics, with a point of view. · https://www.youtube.com/channel/UC7HYxRWmaNlJux-X7rNLZyw · https://twitter.com/TableauTim · https://www.linkedin.com/in/timngwena