Opening multiple CSV files into the same excel sheet

**JustinKelly99** · 07-15-2009, 02:27 PM

Is there a way to open multiple CSV files into the same excel sheet? It's only helpful if it is quicker than opening individually and copy/pasting. I need to do this daily.

Ideally, I'd like to highlite the 14 files, right click and have an option right there. Is that possible? I would like to avoid using access and keep it simple...

I have some moderate excel programming experience so any amount of detail/insight would be much appreciated.

**Andy Pope** · 07-16-2009, 07:30 AM

Stick with the simple approach.

Use a loop to open each csv and copy/paste to master sheet.
If the csv has fields that need special consideration, such as dates or leading zeros, then use the QueryTables method to import a file and then copy/paste it.