KNOWLEDGE BASE

Using Union to Join Multiple Excel Files


Published: 29 Mar 2016
Last Modified Date: 02 Jun 2016

Issue

How to join multiple Excel files in Tableau Desktop, using Union.

Environment

  • Tableau Desktop 9.3
  • Excel

Resolution

Option 1

Export multiple Excel files to a csv file in the same directory or folder. 

Option 2

Copy each Excel file into a single MasterFile.xlsx. 
 

Cause

This feature is currently not included in the Union functionality. 

Additional Information

Multiple csv files must be in the same directory/folder or multiple tables/sheets must be in the same Excel file.
Did this article resolve the issue?