Merge csv files without any additional software (Windows)

Here’s a really neat way to merge csv files without any additional software.

1. Put all the csv files you want to merge into a folder.

2. Open up Notepad, and enter this code:

copy *.csv merged.csv

3. Go to “save as” and save the file as a .bat file, for example “merge.bat”. Put it into the same folder as the csv files. Remember to include the quotation marks in the file name.

4. Run the .bat file. Done!

Advertisements