How to convert many .csv files into 1 .xlsx file with multiple tabs

-2

I have multiple .csv files that need to be in a single .xlsx file, each on it's own tab. I know how to do it manually. is there an automated way do do this? I'm going to need to do this on a monthly basis and there are too many .csv files to do this manually every month

Hugh Hamilton

Posted 2014-04-16T13:15:52.457

Reputation: 1

Question was closed 2014-04-22T02:08:30.143

2You'll need a macro. If they are in the same directory, it's pretty simple. Try to figure it out and then come back if you get stuck. – Raystafarian – 2014-04-16T13:36:35.443

Answers

2

You can do a macro to automate the import of CSVs. Take a look at Laszlo's answer in this StackOverflow thread, I think you can adapt its macro to your needs.

ssssteffff

Posted 2014-04-16T13:15:52.457

Reputation: 1 809

Asked: 2014-04-16T13:15:52.457

Viewed: 1 655 times

Active: 2014-04-16T13:24:54.957