JSON to CSV
INPUT JSON
OUTPUT CSV
nome,cognome,eta Mario,Rossi,30 Giulia,Bianchi,25
Domande Frequenti
Tutto quello che devi sapere sulla conversione JSON in CSV
Che formato deve avere il JSON in input?
Il JSON deve essere un array di oggetti con le stesse chiavi. Es: [{"nome":"Mario","eta":30},{"nome":"Giulia","eta":25}]. Tutte le chiavi del primo oggetto vengono usate come intestazioni del CSV.
Come vengono gestiti i valori con virgole?
I valori che contengono virgole, virgolette o a capo vengono automaticamente racchiusi tra virgolette doppie nel CSV di output, seguendo lo standard RFC 4180.
Cosa succede con oggetti annidati?
Se il JSON contiene oggetti o array annidati, questi vengono convertiti in stringa con JSON.stringify(). Per i fogli di calcolo è consigliabile appiattire i dati prima della conversione.
What shape does the input JSON need?
An array of objects sharing the same keys. The keys of the first object become the column headers of the CSV, so the first row of the data is what decides the shape of the whole file.
How are values containing a comma handled?
Values carrying a comma, a quotation mark or a line break are wrapped in double quotes, and inner quotes are doubled. That is what RFC 4180 lays down, and it is why the file opens cleanly in Excel.
What happens with nested objects?
An object or an array inside a value becomes a string through JSON.stringify, so it lands in the cell as text. For a spreadsheet it is better to flatten the data first, giving each nested field its own column.
Does my data stay private?
Yes, and not because we promise it: this tool runs entirely inside your browser. What you type or upload never leaves your device, so it never reaches a server of ours and there is nothing we could keep, read or lose. You can check it yourself: open the page, disconnect from the internet, and the tool keeps working.
Do you store what I enter?
No. There is no database behind this tool: we do not store your files, your text or your results. When you close the tab nothing is left — not here with us, because it never arrived, and not anywhere else.
Do you profile me? Are you GDPR compliant?
We do not profile you: there is no account to create, we never ask for your email to use a tool, and we keep no profile of what you do. We are an Italian company and we work under the GDPR and the other European rules, with the privacy notice and the consent request in plain sight. One thing we say in full rather than hiding it behind a slogan: the ads on the page are Google's, and Google may use cookies to personalise them. You decide from the consent banner: if you say no the ads stay, but they are not personalised, and the tool works exactly the same.
If it is free, how do you make money?
From the ads on the page, and that is all. We do not sell your data, there is no hidden paid plan, there is no limit that eventually asks for your card, and you do not have to sign up. The ads pay for the servers and for the time we spend writing the tools: that is how we can keep them open to everyone.