Error: You must specify a sheet name

[Alteryx_KB]

Environment Details

• Alteryx Designer
  • All versions
• Output data tool

Cause

When writing out a new spreadsheet, the file name does not contain a sheet name.

Resolution

Update the filename to include a sheet name. For example, append the sheet name using three pipe characters (|||) as the delimiter; or try reselecting the file in the Write to File or Database drop down, and it can prompt a sheet name option (in the second image below). For more information, see the Output Data help page.

[maamek]

I already have a sheet specified why  do I keep getting this error

[lepome]

@maamek 

If you include screenshots of what you have, maybe that would help.

[Ylin0615]

This just happened to me:

Sheet name is specified but still got error.

[mshinza]

Hi @maamek  and @Ylin0615 

 
Please select these 2 options on you output configuration,

__PRESENT