How to merge multiple CSV files

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% [?]

Related posts:

1. Transfer files without a tracker in utorrent In this tutorial I will explain how to transfer files via utorrent without the use of a tracker This is very useful to share large...
2. Beware the smiling man A few weeks ago I stumbled across some interesting spam; it was generic enough to make me think hmm is this spam or a...
3. mIRC Coding – Coding in a IRC Backdoor mIRC Coding – Coding in a IRC Backdoor tutorial written by ‘Zook’s; This is for educational use only. Its main aim is to give an...