KNOWLEDGE BASE

Exporting View with Values Populated for Each Row


Published: 28 Jan 2014
Last Modified Date: 20 Jan 2019

Question

How to export a view from Tableau Desktop so that each column in a row contains values.

Environment

Tableau Desktop

Answer

Use the Copy option instead of Export:
  1. Select Worksheet > Copy > Crosstab.
  2. Open Excel or the desired spreadsheet program.
  3. Paste the data into the spreadsheet.

Additional Information

By copying the view as a crosstab, and pasting the data into Excel, the full data behind the view in Tableau Desktop can be transferred to an Excel file, without merging cells that contain duplicate values.

Discuss this article... Feedback Forum
Did this article resolve the issue?