JSON ↔ CSV
Converti tra JSON e CSV
Input
JSON, CSV o TSV UTF-8, fino a 5 MB. Puoi anche trascinare qui un file.
Result
Oggetti e array restano testo JSON in una cella. CSV → JSON mantiene tutti i valori come stringhe; null e valori mancanti diventano celle vuote. Si usa il separatore selezionato.
Excel può trattare le celle che iniziano con =, +, -, @ come formule. Importa i dati esterni come Testo. BOM e virgolette CSV non impediscono l’esecuzione di formule.
JSON and CSV: Two Data Formats, One Easy Converter
JSON is the web's favorite data format -- APIs speak it fluently. CSV is what spreadsheets like Excel understand best. They're both useful, they're both everywhere, and sooner or later you'll need to convert between them. That's what this tool does.
When Would You Need to Convert?
Got JSON data from an API and want to analyze it in Excel? Convert it to CSV. Have a spreadsheet you need to send to a web service? Convert it to JSON. It comes up more often than you'd expect.
JSON vs. CSV: Different Tools for Different Jobs
JSON is structured data with key-value pairs that can nest objects inside objects and hold arrays. It's what most APIs send and receive, and it's the standard for config files. CSV is the simple one -- just rows and columns separated by commas. Open it in Excel or Google Sheets and it looks like a normal spreadsheet. JSON is flexible but harder to read at a glance; CSV is limited but instantly understandable. Knowing when to use which saves you a lot of headaches.
Real-World Scenarios Where You'll Need This
Say you're a data analyst and an API dumps 10,000 records in JSON. You're not going to analyze that in a text editor -- convert it to CSV and open it in Excel. Or maybe you've got a product catalog in a spreadsheet and you need to upload it to an e-commerce platform that only accepts JSON. Database exports, CRM data migrations, analytics reports -- they all involve bouncing between these two formats. Having a fast converter means you spend less time wrangling data and more time using it.
Avoiding Common Pitfalls When Converting Data
Oggetti e array restano testo JSON in una cella. CSV → JSON mantiene tutti i valori come stringhe; null e valori mancanti diventano celle vuote. Si usa il separatore selezionato.
Excel può trattare le celle che iniziano con =, +, -, @ come formule. Importa i dati esterni come Testo. BOM e virgolette CSV non impediscono l’esecuzione di formule.