Directory output many .gz to many excel files?

[StephenF]

I have a directory full of .gz files containing one csv data file each I wish to spit them back out as xlsx files.

Best I can do is get a row of the file details printed on one sheet each in one xlsx file , what am I doing wrong?

I find this widget very unintuitive.

[StephenF]

I get the following error when I try this, Jordan.

Error: Output Data (40): Unable to Open archive for zipping: G:\FTP\sales\Samantha\DataExtracts\schd.output_20190404.gz|||datafile.csv.xlsx Error Opening file: G:\FTP\sales\Samantha\DataExtracts\schd.output_20190404.gz|||datafile.csv.xlsx
: The filename, directory name, or volume label syntax is incorrect. (123)

[JordanB · Accepted solution]

@StephenF and myself went on a call to resolve. So for those reading the thread, the solution is outlined.

The syntax below was incorrect regarding the file extension of the file. 

We needed to change this from datafile.csv.xlsx to just .xlsx|||Sheet1. This extension was added onto a re-formatted filename of schd.output_ using the text to columns tool. 

We then fed these into a batch macro to allows for changing field headers.

Best,

Jordan