CSV Tools

View CSV as a table, normalise delimiters and quoting, and convert between CSV, TSV and JSON. Built on papaparse with delimiter sniffing, so exports from Excel, Google Sheets and databases just work.

Action

  • View CSV as a table and normalize delimiters and quoting.

    CSV
  • Turn CSV rows into a JSON array.

    CSVto JSON
  • Flatten JSON arrays into CSV for spreadsheets.

    JSONto CSV
  • Convert tab-separated values to CSV and back.

    TSVto CSV

About CSV Tools

CSV looks simple until a field contains a comma, a quote or a newline. Formattr parses with a standards-compliant parser and writes output with correct quoting, and the table preview makes it obvious when a row has the wrong number of columns.

Converting JSON to CSV flattens nested objects into dotted column names, and converting back can rebuild the nesting.

Frequently asked questions

Why does Excel show strange characters in my CSV?

Excel assumes a legacy encoding unless the file starts with a UTF-8 byte-order mark. Turn on the Excel-friendly option in JSON to CSV to add one.

Can I convert semicolon-separated files?

Yes. Delimiters are detected automatically, and you can choose comma, semicolon, tab or pipe explicitly.

More categories