JSON ↔ CSV
Converteer tussen JSON en CSV
Input
UTF-8 JSON, CSV of TSV, maximaal 5 MB. Je kunt hier ook een bestand neerzetten.
Result
Objecten en arrays blijven JSON-tekst in één cel. CSV → JSON houdt alle waarden als tekenreeksen; null en ontbrekende waarden worden lege cellen. Het gekozen scheidingsteken wordt gebruikt.
Excel kan cellen die beginnen met =, +, -, @ als formules behandelen. Importeer externe gegevens als Tekst. BOM en CSV-aanhalingstekens voorkomen geen formule-uitvoering.
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
Objecten en arrays blijven JSON-tekst in één cel. CSV → JSON houdt alle waarden als tekenreeksen; null en ontbrekende waarden worden lege cellen. Het gekozen scheidingsteken wordt gebruikt.
Excel kan cellen die beginnen met =, +, -, @ als formules behandelen. Importeer externe gegevens als Tekst. BOM en CSV-aanhalingstekens voorkomen geen formule-uitvoering.