How To Export to Excel from Tableau

 Follow these steps in Tableau Desktop:

  • Open Workbook
  • Open View to export to Excel
  • Click Worksheet from top-level menu
  • Click Duplicate as Crosstab 
  • Open crosstab view
  • Click Worksheet,  Export,  Crosstab to Excel from top-level menu
  • Excel will open and you will see the exported data


Comments

Post a Comment

Popular posts from this blog

The (Almost) Definitive Guide to Show/Hide Buttons in Tableau Dashboards

https://www.youtube.com/watch?v=p1yop6z6kbc   Show/Hide buttons in Tableau allow you to do just that, show or hide containers, worksheets, blanks, text, legends, even the title. You can now hide ANY object on a dashboard. In particular, I love to use them to use the show/hide buttons for a filters container. It's always a good idea to name every object in your dashboards in the Layout section so they are easier to identify when creating the buttons. In this video I will walk you through: 0:00 Intro and demo 0:57 Add a show/hide text button to a worksheet 1:44 Add a show/hide icon to a container 2:25 How to show/hide all filters 3:07 Allowing user to view a single worksheet 3:27 How to organize buttons into a container
Read more