JSON formatter
How to format JSON and fix invalid JSON
Format and validate JSON with practical examples. Fix trailing commas, single quotes and unclosed brackets, then choose code view, tree view or minified output.
Read guideJSON and data conversion guides
Practical examples for formatting JSON, comparing responses, and converting spreadsheet data. Learn what to check, then open the tool to try it.
JSON diff
Compare JSON objects without key-order noise
Learn how to compare JSON objects structurally. See examples of reordered keys, nested values, arrays, missing properties and null using the DataLens JSON diff.
Read guideComma separator
Convert an Excel column to a comma-separated list
Turn Excel or Google Sheets rows into a comma-separated list. See TEXTJOIN, quoted values, JSON arrays, SQL lists and ways to preserve leading zeroes.
Read guideCSV to JSON converter
Convert CSV to JSON without losing field values
Convert CSV rows to JSON objects while preserving headers, quoted commas and leading zeros. Learn how to handle duplicate headers and inconsistent row widths.
Read guide