Quick tip: concatenate multiple CSV files • 21 December 2012 • The SnowBlog

Quick tip: concatenate multiple CSV files

          If you're importing sales, oftentimes you need to import more than one CSV file at a time. Here's a shortcut for the Mac to help you combine multiple files into one new one. Create a folder on your desktop and put the csv files in it. 
Open a Terminal window and type the following:

cat *.csv > my-new-file.csv

Immediately you'll have a new file called my-new-file, which contains the content of all the other files in that folder.

This works for data files other than CSV. 

        

The SnowBlog is one of the oldest publishing blogs, started in 2003, and it's been through various content management systems over the years. A 2005 techno-blunder meant we lost the early years, but the archives you're reading now go all the way back to 2005.

Many of the older posts in our blog archive suffer from link rot. Apologies if you see missing links and images: let us know if you'd like us to find any in particular.


Read more from the SnowBlog...

« Alias Hook
Vince Cosmos »