How to Painlessly Combine Multiple Adwords CSVs

by Christopher Yee on September 17, 2012

When I first started doing keyword research I found myself easily downloading 10+ CSV files from the Google Adwords Keyword Tool.  This became a (painful) problem because I had to manually copy and paste all the data into a single Excel file.

Fast forward a few months when I finally found the perfect solution: using the CAT function (short for CONCATENATE) within the command line.  Mac users can get started immediately with their Terminal (located in the Utilities folder); Windows users will have to download Cygwin.

Are you ready for the super secret code to painlessly aggregate all your CSV files into a single document?  Here you go…

cat *.csv >> OUTPUT_FILE.csv

And this is how it looks like in action…

The *.csv portion of the code tells the computer to fetch all files ending in .csv.  The remaining line appends all the data into OUTPUT_FILE.csv or whatever you want to name it – in the image above it’s combine.csv.

Merging of your files should take less than 3 seconds.  Painless, right?!


Eric Wu October 3, 2012 at 5:32 pm

+1 for Command Line solutions for real world search industry problems :)

Christopher Yee October 4, 2012 at 10:27 am

Glad you like it – thanks for the props, Eric!