Found this csv merge tutorial and it works great to merge csv files on mac into one file.
An explanation and quick piece of code that will help you to simply merge large numbers of .csv files (or for that matter: any kind of text files) into one. I used it to merge multiple .csv files with differing filenames into one. Quick & easy.
- Put all of your .csv files into one folder and open the folder in terminal on the Mac.
- Run this command in terminal on the folder:
cat *.csv >merged.csv
To specify which files you want to merge use:
cat file1.csv file2.csv file3.csv >merged.csv
Note that each file must have the same number of columns.