CSV Format - Convert CSV to Custom Format | Online Free DevTools by Hexmos

Format CSV data easily with CSVFormat. Convert delimiters and line endings to create custom CSV outputs. Free online tool, no registration required.

csvformat

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|--out-tabs]}} {{data.csv}}

  • Convert delimiters to a custom character:

csvformat {{[-D|--out-delimiter]}} "{{custom_character}}" {{data.csv}}

  • Convert line endings to carriage return (^M) + line feed:

csvformat {{[-M|--out-lineterminator]}} "{{\r\n}}" {{data.csv}}

  • Minimize use of quote characters:

csvformat {{[-U|--out-quoting]}} 0 {{data.csv}}

  • Maximize use of quote characters:

csvformat {{[-U|--out-quoting]}} 1 {{data.csv}}