Many CSV files to one XLS with multiple sheets

[Zuko]

Hi, Can you add option to allow "merge" many csv files into one xls file with separate sheet for each csv file?

[ferkulat]

Hi Zuko,

does every sheet need a custom name? What should happen if one or more files exeed the line limit (I.e. 65535)? What happens if the number of input files exeed the limit of max sheets. I dont know this limit yet, but I expect it being there. Could you please write something about this use case?

[Zuko]

Hi @ferkulat

does every sheet need a custom name? yes

What should happen if one or more files exeed the line limit (I.e. 65535)? I think it should add another sheet with eg. "*_2" name

What happens if the number of input files exeed the limit of max sheets. New file should be created with "*_2" in name?

My usage case: I want to merge ~20 csv files (reports from shops) into one xls file (every single one in separate sheet). Sheets names could represent csv file names. (Shop_1, Shop_2 ... Shop_20).

[Zuko]

So, can you add it or I need to find another app? ;(