CSV files from subfolders to xlsx sheets

Hi guys,
I have CSV files that I want merge into xlsx (sheets).
The files are in a folder in different numbers.
I want it to be as:
One subfolder=one xlsx with many sheets.
I’ve spent some hours trying to make it properly but I end up with one file saved with different filenames

I created a workflow that demonstrates how such a job could be done. I use two loops. The first one lists all the folders from the import folder, the second one iterates thru all the CSV files found there.

The names of the folders and files are extracted and used to name the resulting Excel files. Maybe you could modify that to your needs.


kn_example_csv_to_excel.knar (229.3 KB)


Thank you, I will give it a try.

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.