I needed to concatenate a bunch of CSV files while skipping the header row. There was a nice solution on Stack Overflow:

find . -name "*.csv" | xargs -n 1 tail -n +2

With the GNU version of tail (sadly not the one installed on OS X by default), you can just use

tail -q -n +2 *.csv

or

awk 'FNR != 1' *.csv