How to Merge Multiple CSVs into a Single File
Here's an ultra-easy solution to the challenge of merging multiple CSV files into a single file. I'm on a Mac OSX and used Terminal or iTerm
- Move all the CSV files into the same folder
- Open Terminal or iTerm or your favourite command-line app
cd path-to-the-csv-folder
cat *.csv > ../result.csv
This combines all your CSVs into result.csv
In my case, I needed to combine around 140 CSVs and this method took seconds.
The merged file will have multiple records of the headers from each of your CSVs. If you need to clean this up, open result.csv with your favourite text editor and use search and replace.