Concatenating CSV files

Many programs will log data to a CSV (comma separated value) file. These files are usually structured with a standard format. Let’s say you want to import the data into a database or spreadsheet. There is an alternative to importing 2, 5, 10 or 100+ files one at a time. You can concatenate the files into one file. Here is how you do it…

  1. Create a new directory on your hard drive (ie: C:\CSV-Files)
  2. Copy all the files into a new directory.
  3. Open a command window by clicking Start->Run. In the open line type “cmd” and hit return
  4. CD to the directory you created in step one (ie: cd C:\CSV-Files)
  5. Copy all the files to a single file… copy *.csv consolidated.csv
  6. You can now import consolidated.csv into your database or spreadsheet.