This is a discussion on Importing multiple CSV files to Excel within the Excel Questions forums, part of the Question Forums category; I have a bunch of CSV files in a folder. I'd like to import each file into Excel using the ...
I have a bunch of CSV files in a folder. I'd like to import each file into Excel using the 'Import from Text' tool by typing the name of the file into a cell. I then need to format all of the data into a specific layout.
All of the files are in the same folder and are identical in terms of headings used, number of entries, size etc. The final layout will also be identical each time, it's just a matter of getting the data from the CSV file into the correct places and applying the correct formatting.
I have a template layout in a separate Excel workbook, so could either use this if possible or could apply the formatting from scratch within the macro.
I've never written a VBA code before and am just starting out recording macros (the absolute basics) because I know that's the way to get automating processes like this. A suggestion on how to record this macro myself would be absolutely ideal, as a bunch of code with no explanation will be difficult for me to edit later if needs be, however any advice is much appreciated.
I hope this helps.
Append Multiple Text Files into a Worksheet without Code - Office Blogs