Loading...
Loading...
Free, private, and runs entirely in your browser. No data is sent to any server.
Output will appear here...
JSON excels at representing hierarchical, nested data structures, but many business tools — spreadsheets, databases, analytics platforms, and reporting software — work natively with tabular CSV data. Converting JSON to CSV bridges this gap. When you receive an API response containing an array of user records, product listings, or transaction logs, converting to CSV lets you open the data directly in Excel, Google Sheets, or LibreOffice Calc for filtering, sorting, pivot tables, and charting. CSV is also the standard import format for most database tools, CRM systems, and email marketing platforms.
Paste a JSON array of objects into the left editor. The converter flattens each object into a row, using the object keys as column headers. Nested objects are flattened with dot notation (e.g., address.city becomes a column header). Arrays within objects are joined with semicolons so each row remains a single CSV line. The output appears in the right panel, ready to copy or download as a .csv file. The converter handles edge cases like missing keys across objects (empty cells), special characters that require CSV escaping (commas, quotes, newlines), and mixed-type values.
Not all JSON maps cleanly to CSV. Flat arrays of uniform objects convert perfectly — each object becomes a row, each key becomes a column. Nested objects are flattened automatically using dot notation, so a JSON structure like {name: 'Alice', address: {city: 'London'}} becomes columns 'name' and 'address.city'. Deeply nested arrays or highly irregular structures may produce wide tables with many empty cells. For best results, pre-process complex JSON to a flat structure before conversion, or use the formatter to inspect and restructure your data first.
Use JSON when you need hierarchical data, type preservation (distinguishing strings from numbers from booleans from null), or when the consuming application is a web API, JavaScript runtime, or NoSQL database. Use CSV when the consumer is a spreadsheet, SQL database, data analysis tool, or any system that expects tabular rows and columns. Many data pipelines start with JSON (from an API) and end with CSV (for reporting). This converter handles that middle step instantly, directly in your browser.