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.

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}}