# DataLens

> Free online JSON formatter, JSON validator, JSON diff, comma separator and data conversion tools by Flazetech. No account is required to use the tools.

Canonical site: https://datalens.flazetech.in/. Public instructions and examples are available as HTML and Markdown without JavaScript. Interactive editors require JavaScript. These references describe the tools; they do not provide an API for executing conversions.

Formatting and conversion run in the browser. Optional sharing can expose submitted data through a link or sharing service. API requests go to the selected destination. JSON uses JavaScript number precision; keep exact long identifiers as strings. JSON diff ignores object-key order and compares arrays by index.

## Tools

- [JSON formatter & validator](https://datalens.flazetech.in/json/index.md): Format, validate and minify JSON online. Explore a collapsible tree, search values, sort keys and download formatted JSON. Processing happens in your browser.
- [Delimiter converter](https://datalens.flazetech.in/delimiter/index.md): Convert delimited text between commas, tabs, pipes, semicolons and custom separators. Trim spaces, remove duplicates, add quotes and download your list.
- [Comma separator](https://datalens.flazetech.in/convert-column-to-comma-separated-list/index.md): Convert a column to a comma separated list online. Paste lines from Excel or text, remove duplicates, add quotes, and copy a list or JSON array for free.
- [JSON diff](https://datalens.flazetech.in/json-diff/index.md): Compare two JSON documents and find added, removed or changed values by path. Ignore object key order, inspect differences and download a JSON diff report.
- [SQL schema visualizer](https://datalens.flazetech.in/schema/index.md): Visualize SQL CREATE TABLE statements as an interactive ER diagram. Inspect columns, data types, primary keys and foreign keys, or explore MongoDB samples.
- [CSV ↔ JSON converter](https://datalens.flazetech.in/csv/index.md): Convert CSV to JSON and JSON arrays to CSV. Detect comma, tab, pipe or semicolon separators, preserve quoted fields, and download the converted file.
- [YAML ↔ JSON converter](https://datalens.flazetech.in/yaml/index.md): Convert YAML to JSON or JSON to YAML in your browser. Validate configuration files, inspect errors, copy the result and download the converted data.
- [XML ↔ JSON converter](https://datalens.flazetech.in/xml/index.md): Convert XML to JSON and JSON to XML online. Preserve attributes, validate XML syntax, and copy or download the output directly from your browser.
- [JSONPath tester](https://datalens.flazetech.in/jsonpath/index.md): Test JSONPath expressions against JSON data. Extract nested fields, filter arrays, inspect matching values, and debug queries locally in your browser.
- [API client](https://datalens.flazetech.in/api/index.md): Send GET, POST and PUT requests from your browser. Add headers and query parameters, inspect JSON responses, and export a cURL command with DataLens.

## Guides

- [How to format JSON and fix invalid JSON](https://datalens.flazetech.in/guides/format-validate-json/index.md): Format and validate JSON with practical examples. Fix trailing commas, single quotes and unclosed brackets, then choose code view, tree view or minified output.
- [Compare JSON objects without key-order noise](https://datalens.flazetech.in/guides/compare-json-objects/index.md): Learn how to compare JSON objects structurally. See examples of reordered keys, nested values, arrays, missing properties and null using the DataLens JSON diff.
- [Convert an Excel column to a comma-separated list](https://datalens.flazetech.in/guides/excel-column-to-comma-list/index.md): 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.
- [Convert CSV to JSON without losing field values](https://datalens.flazetech.in/guides/csv-to-json-preserve-values/index.md): Convert CSV rows to JSON objects while preserving headers, quoted commas and leading zeros. Learn how to handle duplicate headers and inconsistent row widths.

## About and data handling

- [About DataLens](https://datalens.flazetech.in/about): The product and publisher.
- [Data processing and privacy](https://datalens.flazetech.in/privacy): Local processing, optional sharing and analytics.
- [Contact](https://datalens.flazetech.in/contact): Support and feedback.

## Optional

- [Complete tool and guide reference](https://datalens.flazetech.in/llms-full.txt): All public tool instructions, examples, FAQs and guides in one text file.
- [Guides hub](https://datalens.flazetech.in/guides): Browse practical guides.
- [XML sitemap](https://datalens.flazetech.in/sitemap.xml): Canonical public HTML pages.