Merge bunch CSV files into one single Excel file manually requires a lot of time and efforts, and on top of that, it’s a painful task. What if you can automate the process with just a single macro?

In this tutorial, I will teach you how to write a VBA script to merge all the CSV files in a folder into a single Excel file.

Exercise file used in the video download

VBA Script