Loading tool…

Preparing the browser-side workspace

Loading Datio workspace…

Preparing the browser-side engine

Herramienta • Transformación

Convertidor de CSV a JSON

Convierte CSV tabular en objetos JSON limpios o matrices 2D con números y booleanos tipados.

Sube un CSV para convertir a JSON

Suelta tu CSV o Excel aquí. La conversión es instantánea en memoria.

Aceptados:.csv.tsv.xlsx.xlsMáx. 5 MB

100% en memoria del navegador

Acerca de esta herramienta y cómo usarla

Acerca de esta herramienta

The CSV to JSON converter turns a delimited file into clean JSON in your browser. Choose an array of objects (headers become keys) or a 2D matrix (headers plus rows), with 2-space, 4-space, or minified indentation. Numbers and true/false become typed JSON values; empty CSV cells become null.

Output: array of objects or 2D matrix
Typed numbers and booleans; empty cells become null
Indentation: 2 spaces, 4 spaces, or minified
Copy to clipboard or download .json

¿Para quién es?

Useful for developers and analysts who need spreadsheet data as JSON for APIs, configs, or JavaScript apps without installing conversion utilities.

Cómo usarla

Choose a CSV, TSV, TXT, or Excel (.xlsx, .xls) file (up to 5 MB).
Pick Array of Objects for keyed records or 2D Matrix for a compact grid.
Choose indentation, review the generated output and record count.
Copy the JSON or download the .json file.

Ejemplo

name,score,active
Alice,98,true
Bob,,false
→
[
  { "name": "Alice", "score": 98, "active": true },
  { "name": "Bob", "score": null, "active": false }
]

Array-of-objects output with typed values (empty cell → null):

Formatos y flujo

Accepted: .csv, .tsv, .txt with automatic delimiter detection, plus Excel (.xlsx, .xls) workbooks — pick a sheet if there are several.
Parsed locally; exact parse errors are reported when a file has no data rows.
Going back: empty cells become null in JSON, and nulls become empty cells in CSV.

Convert after cleaning so the JSON reflects fixed values. To go the other direction, use the reverse converter. JSON a CSV, Limpiador CSV, Visor CSV.

Preguntas comunes

What is a CSV to JSON converter?

It turns spreadsheet rows into structured JSON — typically an array of objects where each header becomes a key. Datio does this in your browser with typed numbers and booleans, so “98” becomes 98 and empty cells become null.

How do I convert CSV to JSON?

Load the CSV file in Datio's CSV to JSON tool, choose Array of Objects (keyed records) or 2D Matrix (compact grid), pick 2-space, 4-space, or minified indentation, then copy the output or download the .json file.

What happens to empty cells and numbers?

Empty CSV cells become null in JSON objects; numeric text like “98” becomes the number 98 and “true”/“false” become booleans. Going back, nulls become empty cells in the CSV, so round-trips stay predictable.

Array of objects or 2D matrix — which should I pick?

Pick Array of Objects when each row is a record for an API or app (headers become keys). Pick 2D Matrix when you want the smallest faithful grid — headers plus rows as nested arrays with no keys repeated.

Limitaciones

Conversion in the CSV / Excel to JSON tool reflects the parsed table exactly — headers are trimmed and capped in length, and very wide or very long files are bounded to keep browser parsing fast (up to 5 MB per file).

Herramientas y guías relacionadas