I usually open CSV files in Micrsoft Excel even if I only want to take a quick peek. Not anymore:

column -s, -t path/to/file.csv | less -#5 -NS

Use column -s'","' -t ... if columns are wrapped in quotes.