FreeToolBox
English

JSON to CSV Converter

Convert JSON data into a CSV table. Each object becomes a row and each key a column, with nested objects flattened into columns like address.city. Preview the table, then download a CSV that opens correctly in Excel and Google Sheets.

Your JSON

Each object becomes a row and each key becomes a column. A single object becomes one row.

CSV

    How to use the JSON to CSV Converter

    1. Paste a JSON array of objects, or use Try an example.
    2. Choose the separator and whether to flatten nested objects.
    3. Check the preview and download the CSV file.

    Your data stays on your device. This tool runs entirely in your browser. Nothing you type or paste is sent to our server or saved. Read our privacy policy.

    From JSON to a spreadsheet

    CSV is a plain table format that Excel, Google Sheets and databases all open. Converting JSON to CSV lets non-developers read API data, and lets you filter, sort and chart it.

    The converter expects an array of objects. Each object becomes a row and each key a column:

    [{"name": "Ali", "city": "Lahore"},
 {"name": "Sara", "city": "Karachi"}]

    becomes a table with the columns name and city.

    Nested objects and arrays

    With flattening on, {"address": {"city": "Lahore"}} becomes a column called address.city. Arrays are written as JSON text inside the cell so no data is lost. Objects with different keys are fine: missing values are left empty.

    Comma or semicolon?

    Use a comma for most software. In countries where the comma is the decimal separator (much of Europe), Excel expects a semicolon. If all your data appears in one column when you open the file, switch the separator.

    Why do Urdu or accented letters look wrong in Excel?

    The downloaded file includes a marker that tells Excel it's UTF-8, so Urdu, Arabic and accented letters display correctly when you double-click it.

    JSON not valid?

    Check and fix it first with the JSON Formatter, which shows the exact line of the error.

    Frequently asked questions

    What JSON can be converted?

    An array of objects works best: each object becomes one row. A single object becomes one row, and an array of arrays uses numbered columns. Objects don’t need the same keys; missing values are left empty.

    How are nested objects handled?

    With Flatten nested objects on, {"address": {"city": "Lahore"}} becomes a column called address.city. Lists inside an object are kept as JSON text in one cell.

    Why choose a semicolon separator?

    In countries that use a comma for decimals, Excel often expects semicolons. If your CSV opens with everything in one column, download it again with the semicolon separator.