bash tab separated values to comma separated values

tsv2csv.sh

#!/bin/bash
# Alex Duzsardi @aduzsardi
# made it more portable by using 'tr' instead of 'dos2unix'

if [[ $# -ne 1 ]]; then
	echo "Usage: ./$0 tab-delimited-file.txt"
else
tr -d '\r' < "$1" | sed -r -e 's/\t/","/g' -e 's/^/"/g' -e 's/\s+(")/\1/g' -e 's/(\s+)?$/"/g' >  "$1".csv
fi

another way ...the 'tr' part converts CRLF to LF , 'sed' part removes extra spaces from between the fields if you have for example

Field1\s\s\s\tField2\s\tField 3\tField 4

tr -d '\r' < tsv-file.txt | awk -F'\t' '{print "\""$1"\",\""$2"\",\""$3"\""}' | sed -r -e 's/\s+(","|")/\1/g'