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/