View CSV files in the Shell

wget -qO- "https://randomuser.me/api/?nat=us&results=100&format=csv"  > users.csv

cat users.csv

#no line wrap and searchable
less -S users.csv

#better spacing
column -t -s, users.csv   #looks messy because of line wrapping
column -t -s, users.csv|less -S

#if using delimiters other then comas
sed 's/,/|/g' users.csv > users2.csv
column -t -s\| users2.csv|less -S

#using vim/neovim
vim <(column -t -s, users.csv)

# might give you more options
sudo apt-get install csvtool
csvtool readable users.csv
csvtool readable users.csv|less -S
csvtool readable users.csv|view     #vi read only
vim <(csvtool readable users.csv)

#and of course visidata
sudo apt install visidata
visidata users.csv