Wildcard Union of Excel Data Sources Results in Duplicate Data

Published: 20 Jan 2020
Last Modified Date: 08 Jul 2022


When using a Wildcard Union to union Excel files together, the resulting data is duplicated.


  • Tableau Desktop 
  • Tableau Prep
  • Excel


To avoid duplication, the sheet and range names can be modified to have different names and then use that sheet name or named range in the matching pattern. Named ranges can also be removed from the Excel files (Formulas > Name Manager > select Named Range to be removed > Delete).


Tableau does not differentiate between named ranges and sheet name.
This behavior is "by design". Please refer to the Online Help documentation -  "Note: When working with Excel data, wildcard search includes named ranges but excludes tables found by Data Interpreter.
Did this article resolve the issue?