OpenRefine http://openrefine.org/ for years has been my go to tool when looking at csv or tsv. I really love this project.
> OpenRefine (formerly Google Refine) is a powerful tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data.