Split large CSV file into smaller chunks

split_csv.sh

FILE=$1
BASENAME=`basename $FILE .csv`
ROWS=$2

echo Splitting $FILE into multiple files of $ROWS rows each...
# split to chunks:
split -l $ROWS -d $FILE $BASENAME\_
# append file extension:
for file in $(find $BASENAME\_*);
  do mv $file $file.csv;
done;
# add header row to all chunks except of the first:
for file in $(find . -type f -name "$BASENAME\_*.csv" -not -name "$BASENAME\_00.csv");
  do echo "$(head -1 $BASENAME\_00.csv)\n$(cat $file)" > $file;
done