Csv to multiple xls worksheets

Question
1

Is there a way I can pull in multiple csv files and output them in 1 excel file, with each csv being in their own worksheet in the xls?

2

Yes. The best way to do this depends a bit on how many CSV files there (a few or hundreds) and how often you need to do it (once or frequently). Can you tell us a bit more?

3

If it is a relatively small amount to do, see:
https://www.easydatatransform.com/help/1m/windows/html/write_to_multiple_excel_sheets.html

4

Thanks, that worked perfectly

1 Like