Convertitore JSON → CSV

Come usare Convertitore JSON → CSV

Incolla un array JSON di oggetti nel pannello sinistro. Seleziona il delimitatore preferito e attiva l'opzione riga di intestazione. L'output CSV appare in tempo reale sulla destra. Clicca Copia per copiare il CSV oppure Scarica .csv per salvarlo come file.

How JSON becomes CSV

JSON stores data as objects with named keys; CSV stores it as rows and columns. The converter reads every object in your array, collects the union of all keys as column headers, and writes each object as one row. Missing keys become empty cells, so arrays with inconsistent objects still convert cleanly.

Everything runs in your browser - the JSON is never uploaded to a server. That makes it safe for converting exports containing customer data, API responses, or logs that shouldn't leave your machine.

Opening the CSV in Excel or Google Sheets

• Excel (US/UK): the default comma delimiter opens directly with File → Open.
• Excel (Europe): choose the semicolon delimiter - many European locales use comma as the decimal separator, and Excel expects semicolon-separated files.
• Google Sheets: File → Import → Upload, delimiter is auto-detected.
• Non-ASCII characters (ą, é, ü, 中): if Excel garbles them, use Data → From Text/CSV and pick UTF-8 encoding.

Handling nested JSON

CSV is flat, so nested objects like {"user": {"name": "Alice"}} don't map directly to columns. The common approaches are flattening keys with a dot path (user.name) or serializing the nested part as a JSON string inside a single cell. If your data is deeply nested, flatten it first - a quick script or the JSON Formatter tool helps inspect the structure before converting.

Funzionalità

• Array JSON di oggetti → CSV
• Opzioni delimitatore: virgola, punto e virgola, tab
• Riga di intestazione opzionale
• Scarica come file .csv
• Corretta gestione dei caratteri speciali nel CSV

Domande Frequenti

Potrebbe piacerti anche