How to combine multiple CSV files into one using CMD

Suppose you have a folder where you get files in csv format every day or in a certain interval. You may need to combine all those csv into one file to analyze or get some meaningful information. The below command will help you to combine all the csv files into a single file without using any software.

Open Command Prompt by running “cmd”

Go to the specific drive and folder by running the command “c:\” and “cd\Folder”

Run the below command to combine all csv files into one csv.

copy *.csv combine.csv

All CSV files will be combined into a file named combine.csv

Thats so easy.

Thanks to the reference: http://www.tomnash.eu/how-to-combine-multiple-csv-files-into-one-using-cmd/

Add a Comment

Your email address will not be published. Required fields are marked *