csvformat

Convert a CSV file to a custom output format. Included in csvkit. More information: <https://csvkit.readthedocs.io/en/latest/scripts/csvformat.html>.

Install

All systems
curl cmd.cat/csvformat.sh
Debian Debian
apt-get install csvkit
Ubuntu
apt-get install csvkit
image/svg+xml Kali Linux
apt-get install csvkit
Fedora
dnf install python3-csvkit
Windows (WSL2)
sudo apt-get update sudo apt-get install csvkit
OS X
brew install csvkit
Raspbian
apt-get install python3-csvkit

Convert a CSV file to a custom output format. Included in csvkit. More information: <https://csvkit.readthedocs.io/en/latest/scripts/csvformat.html>.

  • Convert to a tab-delimited file (TSV):
    csvformat -T data.csv
  • Convert delimiters to a custom character:
    csvformat -D "custom_character" data.csv
  • Convert line endings to carriage return (^M) + line feed:
    csvformat -M "\r\n" data.csv
  • Minimize use of quote characters:
    csvformat -U 0 data.csv
  • Maximize use of quote characters:
    csvformat -U 1 data.csv

© tl;dr; authors and contributors