If you work with a lot of data either personally or as part of your job, then you may find yourself in a scenario where you have a lot of CVS files. These files are often created automatically by different reporting systems on websites, or by internal systems at businesses, and the data that they contain can be very important.
Unfortunately these files often come in large numbers, and the data that they contain is often more valuable as a whole than as separate files. Sure, you could open each file individually and manually copy all of that data into one large file, but that can be very tedious, and is an exercise that is very prone to mistakes.
Fortunately Windows has a method that you can use to quickly combine all of your CSV files into one large file. This is accomplished with the command tool, and is a method that can save a lot of time and frustration.
How to Merge CSV Files in Windows 7 Using the CMD Tool
The steps below are going to assume that you have a folder containing all of the CSV files that you wish to combine into the one, larger CSV file. If not, then create a new folder and move all of your CSV files into that folder.
Step 1: Browse to the folder containing the CSV files that you would like to merge.
Step 2: Hold down the Shift key on your keyboard, right-click the folder containing the CSV files that you wish to merge, then click the Copy as path option.
Step 3: Click inside the search field at the bottom-left corner of the screen, type cmd then click the “cmd” result under Programs.
Step 4: Type cd, press the spacebar once, then right-click and choose the Paste option.
The screen should now look something like the screen below. If it does, then press Enter on your keyboard.
Step 5: Type copy *.csv combined-csv-files.csv after the file path (or you can just copy it from this article, then use the right-click, Paste option that we used in Step 4), then press Enter on your keyboard. Note that you can replace the “combined-csv-files” part of that command with whatever name you would like to use for the merged CSV file that you are about to create.
If everything worked properly, you should see a screen similar to the one shown below.
Now if you go back to the folder that contained the original CSV files, you should see a new CSV file with the name that you chose in Step 5.
If you open that file, it will contain all of the information from each of the CSV files that were involved in the file merge.
Are the formulas in your Excel workbook not calculating? Learn how to enable automatic calculation in Excel 2013 if your workbook had previously been set to manual calculation.