KNOWLEDGE BASE

Combining Tables from Different Excel Tables into a Single Data Source


Published: 08 Nov 2013
Last Modified Date: 05 Aug 2015

Question

How to combine tables from several Microsoft Excel worksheets into a single data source in Tableau Desktop.

Environment

  • Tableau Desktop 8.2 and later versions
  • Microsoft Excel
  • Tables contain the same fields

Answer

  1. Connect to the first Excel table. For more information, see Connect to Data in Tableau Help.
  2. Extract the data. For more information, see Creating an Extract.
  3. Append the data from the second Microsoft Excel table to the extract. For more information, see Adding Data to Extracts.

 

Did this article resolve the issue?