How to merge multiple CSV files

Posted on October 28th, 2009 by Donace in Coding, Computer, How to

This is a very simple trick I picked up that has saved me A LOT of time when doing research that has required multiple csv files.

Basically what the little snippet does is make all the .csv files in a said folder merge into one nice big .csv file. Making analysis THAT much easier.

The Code for a Batch File

Open up notepad or your equivalent and add the following:

copy *.csv importfile.csv

Then just save the file as a ‘.bat’ and when you need to use it just drag it into the folder and double click, and it will create a file called ‘importfile.csv’ which will be the new merged csv file.

Download

Now some of you might not want to wonder into notepad etc and copy and paste a line!!!! for those of you the download link is below!

Merge Multiple CSV Bat File Download

Nice and simple :p

Alternate Method to merge csv files

Some of you might not trust batch files (its alright I have my doubts on what they do at night as well). So here is a different method with video!!!

1) Choose Start->Run
2) Enter “cmd”
3) Enter the following:

copy C:*.csv C:[filname].csv

…replacing the path and filename with your own information.

4) Hit the enter key.

Source

So remember dont waste money on those programs!!! do it yourself! :p

Popularity: 1% [?]

Archives

Full Archive

Top Commentators!

Tag Cloud