inicio/dev/json-csv

JSON to CSV Converter Online

Convert between JSON and CSV

Cómo usar JSON a CSV

  1. 1

    Paste your data

    Enter a JSON array or CSV data in the input panel.

  2. 2

    Choose conversion direction

    Select JSON to CSV or CSV to JSON.

  3. 3

    Download or copy result

    Copy the converted data to the clipboard or download it as a file.

Preguntas frecuentes

Is my data safe?
Yes. All processing happens entirely in your browser. Your data never leaves your device and is never uploaded to any server.
Can it handle nested JSON?
Yes. Nested objects are flattened using dot notation when converting to CSV. For example, {user: {name: 'Alice', age: 30}} becomes two columns: user.name and user.age. Very deeply nested structures may produce many columns.
What JSON structure is required for CSV conversion?
The input must be a JSON array of objects — for example, [{id: 1, name: 'Alice'}, {id: 2, name: 'Bob'}]. Each object in the array becomes one CSV row. JSON objects that are not arrays, or arrays of primitives, will not convert cleanly.
How are arrays within JSON handled?
Arrays within JSON objects (e.g. tags: ['a', 'b', 'c']) are joined into a comma-separated string within a single CSV cell. This is the standard approach since CSV cannot represent nested arrays natively.
Can I change the CSV delimiter?
The tool supports configurable delimiters. Comma is the default, but you can switch to semicolon (common in European locales where commas are used as decimal separators) or tab-separated values.

Saber más

¿Qué es JSON to CSV?

Convert JSON arrays to CSV format for spreadsheets and data analysis, or convert CSV data back to JSON for API integration and programmatic use. Handles nested objects by flattening them with dot notation, supports custom delimiters, and auto-generates header rows from JSON keys. Useful for exporting API responses into Excel, converting database query results for reporting, and preparing data for import into other tools. Everything runs in your browser — no file uploads, no sign-up required.

¿Por qué usar JSON to CSV?

  • Bidirectional conversion — convert JSON arrays to CSV for spreadsheets, or CSV tables back to JSON for APIs.
  • Handles nested objects — deeply nested JSON keys are flattened using dot notation (e.g. address.city becomes a column header).
  • Auto-generates headers from JSON keys — no need to manually specify column names.
  • Copy or download result — grab the output as text or save it as a .csv or .json file.
  • Completely private — your data never leaves your browser. Safe to convert sensitive records.

Casos de uso de JSON to CSV

API response to spreadsheet

Export JSON API responses to CSV for analysis in Excel, Google Sheets, or business intelligence tools without writing custom scripts.

Database export conversion

Many database tools export as JSON. Convert to CSV to open in spreadsheet applications for non-technical stakeholders.

CSV import preparation

Convert a CSV file to JSON before sending records to a REST API or importing into a system that expects JSON payloads.

Data transformation for analytics

Convert JSON event logs, analytics exports, or configuration files into CSV for use with data analysis tools like Python pandas or R.

Consejos y buenas prácticas

  • 💡JSON arrays of flat objects (no nesting) convert most cleanly to CSV. Each object becomes a row, and each key becomes a column header.
  • 💡Nested objects are flattened with dot notation — {address: {city: 'Paris'}} becomes address.city as a column header. Deep nesting can produce many columns.
  • 💡Arrays within JSON objects (e.g. tags: ['a', 'b', 'c']) are converted to comma-separated strings within a single CSV cell.
  • 💡When converting CSV to JSON, the first row is treated as the header row and becomes the key names in each JSON object.

Cómo funciona

JSON-to-CSV conversion flattens nested objects recursively using dot-notation key paths, then writes a header row from all unique keys found across all records, followed by data rows. Missing values for sparse records are written as empty cells. CSV-to-JSON parsing splits on the configured delimiter (comma by default) with proper handling of quoted fields that contain commas or newlines, per RFC 4180. The conversion runs synchronously in the browser's JavaScript engine with no external libraries for small to medium datasets.