Skip to content
Sumly

Data Format Converter

JSON, CSV, TSV and NDJSON — paste any, convert to any.

In

Detected: json

Out

campaign,spend,revenue
Search,4200,18900
Social,1800,5100
Rows converted2
Nested objectsSerialised to JSON strings in cells
Nested objects survive as JSON strings so nothing is lost — flatten them upstream if the target system needs plain columns.

How Data Format Converter works

Input format is sniffed automatically: leading { or [ means JSON, otherwise the delimiter that appears most in the first line (comma, semicolon, tab, pipe) wins.

Conversion normalises everything through an internal row model — each format becomes records, records become any output format. Nested objects survive as JSON strings inside cells so nothing is silently dropped.

Output quoting follows RFC-4180: cells containing the delimiter, quotes or line breaks get wrapped in quotes with inner quotes doubled — the detail that breaks naive converters in Excel.

Worked example

A two-campaign JSON array converts to CSV with campaign,spend,revenue columns and two data rows; flipped the other way, a 200-row spreadsheet export becomes an NDJSON stream ready for an API import.

The tool above opens with these numbers. Change them to run your own scenario, or press Reset to come back to this example.

Frequently asked questions

Instant, clean table view of any CSV — no spreadsheet needed.

Remove duplicate lines and clean up lists, emails, and CSV rows in seconds.

API responses into spreadsheets — columns built from your keys.

From 12,500 to 18,400 is +47.2% — with the reverse check done for you.

Mean, median, mode and range from any list of numbers.

Spread that means something — sample or population, with context.

  • csv
  • json
  • tsv
  • ndjson
  • data conversion