When outputing tsv from Excel directly, it added an unpleasant ‘\r’ at the end of each line. And you won’t even notive it by opening the file in TextWrangler. It can be checked by
head -n 2 input.txt, you will see the difference.
Here is how to replace the ‘\r’ with ‘\n’:
cat input.txt | tr '\r' '\n' > output.txt cat input.txt | tr '^M' '\n' > output.txt
While typing ^M in the command, do not use shift+6 & M. You should use ctrl+v+m