Sunday, October 25, 2015

Merge and combine CSV files using command prompt

Just need to share this out, it lets you combine many csv files into one instead of manually copy and paste in Excel.

Open command prompt

Navigate to your folder using the following commands:

cd "<folder>"


cd C:\folder\

Then enter the following command which will combine all the csv files in the folder into one giant csv file:

copy *.csv combine.csv

* symbol means all

combine.csv is your destination file and you can name it anything you want.

No comments: