Cómo usar esta calculadora
How the column set is built
JSON-to-CSV flattens an array of objects into a spreadsheet-ready table, and the first job is deciding the columns. The converter takes the union of every object’s keys in first-seen order: the first object contributes its keys in order, then new keys from later objects are appended. That is the behavior that keeps the output correct when rows disagree — an API response where one user has a city and another does not produces a name, age, city table with an empty cell where city is missing, and every row lines up with the header.
The input contract is strict because the output needs a stable shape: the converter requires a non-empty array of objects. A bare object, an array of strings, or an empty array is rejected with a message that says what was wrong, rather than guessed into a structure that would break downstream.
What happens to values that are not simple text
CSV cells are text, so values are serialized the way the format allows: missing keys become empty cells, null and undefined become empty cells, and nested values — an object or array inside a cell — are serialized as JSON strings, so {"x":1} stays the text {"x":1}. That is the only lossless flat representation: the nested data survives verbatim in the cell, and any spreadsheet software shows it as text.
Numbers and booleans are written as their plain forms (30, true), which is the natural convention for spreadsheet imports. True flattening of deep structures — turning every nested key into its own column — is outside the converter’s scope, and the page says so rather than pretending otherwise.
Quoting and line endings: the RFC 4180 contract
The output follows RFC 4180 exactly so every spreadsheet application opens it correctly: cells containing a comma, a quote, or a line break are wrapped in double quotes, embedded quotes are doubled (""), and rows are terminated with CRLF — the line ending the standard defines and the one spreadsheet tools expect. The worked example shows the pair in action: the cell "New York, NY" is quoted because of its comma, and the file ends every row with CRLF.
Getting these details right is the difference between a file that opens cleanly and one that splits columns or misaligns rows. The converter never produces the unquoted forms that break on the first address containing a comma.
The local promise
API responses, database exports, and test data often contain internal details that should not leave your machine, and converting JSON to CSV is a job no server needs to perform. Everything runs in your browser: the JSON is parsed and serialized locally, nothing is uploaded, logged, or stored, and copy and download actions deliver the CSV file where you need it — a spreadsheet, an import tool, or a stakeholder who asked for the data in a readable form.
Preguntas frecuentes
¿Cómo se convierten los objetos anidados?
Los valores anidados se serializan como cadenas JSON dentro de la celda: por ejemplo, {"x":1} se convierte en el texto {"x":1}. CSV es un formato plano, así que las estructuras más profundas necesitan aplanamiento o una exportación aparte.
¿Cuál es el orden de las columnas?
Las columnas siguen el orden de primera aparición en el array: el primer objeto aporta sus claves en orden y después se añaden las claves nuevas de los objetos siguientes. Cada fila queda alineada con la cabecera independientemente de qué claves tenga cada objeto.
¿Por qué mi archivo termina con CRLF?
CRLF es el final de línea de RFC 4180 y la convención que esperan las aplicaciones de hojas de cálculo. El conversor lo emite por defecto para que los archivos se abran correctamente en todas partes.
Can I convert an object instead of an array?
No — the converter requires a non-empty array of objects, because that is the shape that maps to rows. A bare object is rejected with a clear message; wrap it in an array if that is what you have.
Why do my null values come out as empty cells?
Null and undefined mean "no value here" in JSON, and an empty cell is the honest CSV equivalent — the column position is preserved, and the spreadsheet shows the absence rather than a placeholder that could be mistaken for data.