JSON Converter

This tool supports conversion between JSON, CSV, XML, and YAML formats. You can also convert JSON to SQL INSERT statements. All conversions run entirely in your browser.

Nested objects are flattened using dot notation. For example, { "user": { "name": "Alice" } } becomes a column called "user.name" with the value "Alice". You can toggle flattening on or off.

Comma is the most common delimiter and works with most spreadsheet applications. Use semicolons for European locales where commas are decimal separators. Tab-separated values (TSV) work well for copying to spreadsheets.

Yes! Select CSV as input format and JSON as output format. The first row is treated as headers, and each subsequent row becomes a JSON object. The converter handles quoted fields and escaped characters.

Yes, the tool auto-detects whether your input is JSON, CSV, XML, or YAML based on the content structure. You can also manually select the input format from the dropdown.

Yes. When the Flatten option is enabled (on by default), nested objects are flattened using dot notation. For example, a JSON object like {"user": {"address": {"city": "NYC"}}} becomes a CSV column named "user.address.city". This makes deeply nested API responses compatible with spreadsheet applications like Excel and Google Sheets.

For most practical data, yes. JSON and YAML share the same data model (mappings, sequences, scalars), so converting between them preserves all values. However, YAML supports additional types like dates and multiline strings that JSON does not, so a round-trip from YAML to JSON and back may lose some YAML-specific formatting. JSON to YAML is always lossless.

The converter generates standard SQL INSERT statements compatible with MySQL, PostgreSQL, SQLite, and most relational databases. Each JSON object becomes an INSERT INTO statement with the table name you specify. Column names are derived from JSON keys, and values are properly quoted and escaped. Nested objects are flattened using dot notation when the Flatten option is enabled.