Selecting Excel sheet tabs with $

eizarahman

In the actual Excel spreadsheet, there is only 1 tab named 'Output'. However when selecting the sheet using the Input Data tool, I am seeing 2 sheet names - 'Output' and 'Output$'.

What is the difference between the 2 sheet names - 'Output' and 'Output$'?

Under what circumstances will we encounter this scenario - having 2 sheet names (one with the original tab name and another with $)?

Note: This screenshot of 'Choose Sheet or Specify Query' can be viewed when selecting the Cust_wTransactions.xls file from \Alteryx\Samples\SampleData folder.

JoeM

In this panel where we can choose a "specific sheet", we actually have the ability to select a sheet or a named range. It appears your workbook has both a named range and a sheet by the name of "output". Any value with the suffix "$" represents a sheet. So in your case, "Output" is the named range in your workbook and "Output$" is the sheet.

If you were not aware of a named range existing in your data, go inside the workbook, go to the formulas tab, and select "Name Manager" to a listing of your named ranges.