Csv to multiple xls worksheets

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?

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?

If it is a relatively small amount to do, see:

Thanks, that worked perfectly

1 Like