JSON to CSV Converter

How It Works

This converter reads your JSON input, identifies the structure, and flattens it into a two-dimensional table that maps directly to CSV rows and columns. The process involves three main steps: parsing the JSON text into a JavaScript object, traversing the data tree to collect all unique keys (including nested paths), and then writing each record as a CSV row with proper escaping.

When you paste or upload JSON data, the parser first tries standard JSON.parse(). If that fails, it checks whether the input follows JSON Lines format, where each line is a standalone JSON object. This dual-mode approach means you can work with API responses, database exports, log files, and streaming data without any preprocessing.

The column mapping step lets you control exactly what ends up in your CSV. Every detected field appears in the mapping panel, where you can toggle visibility, rename headers, and drag columns into your preferred order. This eliminates the need for post-processing in a spreadsheet application.

JSON Structure Guide

Not all JSON looks the same. Here are the most common patterns this tool handles:

• Array of objects — The standard tabular format. Each object becomes a row, and each key becomes a column. Example: [{"{"}name":"A"{"}"}, {"{"}name":"B"{"}"}]
• Single object — Converted to a one-row CSV with each key as a column header.
• JSON Lines (JSONL) — One JSON object per line, commonly used in logging and data pipelines. Each line is parsed independently.
• Nested structures — Objects within objects are flattened with dot notation. address.city becomes a column header.
• Mixed types — When the same key holds different types across records, values are converted to their string representation.

Nested Object Handling

Real-world JSON is rarely flat. API responses from services like Stripe, GitHub, and Shopify routinely nest objects three or four levels deep. This converter walks the entire object tree and creates column headers using dot-separated paths. For instance, a structure like {"{"}user: {"{"}profile: {"{"}name: "Jo"{"}"}{"}"}{"}"} produces a column called user.profile.name.

Arrays of primitive values (strings, numbers, booleans) are joined with semicolons into a single cell. This preserves the data while keeping each record on one row. If an array contains objects, those objects are flattened with indexed notation like items.0.name and items.1.name.

This approach follows the same conventions used by tools like MDN's JSON reference and popular Node.js flat-file converters, ensuring the output is predictable and easy to work with downstream.

CSV Format Options

CSV might seem simple, but the details matter when importing into different applications. The delimiter choice affects compatibility: commas work everywhere, but semicolons are the default in many European locales where commas serve as decimal separators. Tab-separated values (TSV) avoid delimiter conflicts entirely, and pipe-delimited files work well with Unix command-line tools.

The quote character wraps values that contain the delimiter, newlines, or the quote character itself. Double quotes are the RFC 4180 standard, but single quotes can be useful for specific import targets. Line endings matter too: Windows applications expect CRLF, while Unix and macOS tools prefer LF.

Toggling the header row is useful when you need to append data to an existing CSV or when your downstream process expects raw data without column names.

Common Use Cases

Developers, analysts, and project managers reach for JSON-to-CSV conversion in a wide range of scenarios:

1. API data export — Pull data from a REST API, paste the JSON response, and get a spreadsheet-ready file in seconds.
2. Database migration — MongoDB exports JSON by default. Convert to CSV for import into PostgreSQL, MySQL, or a data warehouse.
3. Log analysis — Structured JSON logs (JSON Lines format) convert neatly into rows for filtering in Excel or Google Sheets.
4. Reporting — Transform nested analytics data into flat tables that non-technical stakeholders can open in any spreadsheet app.
5. Data cleaning — Use the column mapping to drop unwanted fields and rename headers before passing data along.

Frequently Asked Questions

Browser Compatibility

This tool works in all modern browsers including Chrome 80+, Firefox 78+, Safari 14+, and Edge 80+. It relies on standard Web APIs like FileReader, JSON.parse, Blob, and the Clipboard API. No plugins, extensions, or server-side processing required. Mobile browsers on iOS and Android are fully supported, though the drag-and-drop file upload works best on desktop.