Skip to main content

    Convert JSON to CSV online

    Convert your JSON files to CSV for free, online, no signup or installation.

    Accepted source formats

    JSON

    Available output formats

    CSV

    How it works

    1

    Upload

    Drag and drop or select your JSON file from your device

    2

    Convert

    Click "Convert" and wait a few seconds

    3

    Download

    Get your converted CSV file instantly

    Common mistakes

    • Using a source file of poor quality.
    • Publishing without checking the final result.
    • Confusing file size, dimensions and quality.
    • Overwriting the original file without keeping a copy.

    Pro tips

    • Always keep an original version.
    • Test several settings before downloading.
    • Use WebP for the web when possible.
    • Choose descriptive file names for SEO.

    Privacy guaranteed

    Your files are processed locally in your browser and are never uploaded to our servers.

    JSON to CSV: open API data in Excel or Google Sheets

    JSON is the standard exchange format of modern APIs, but it can’t be used directly in a spreadsheet. Converting to CSV turns a JSON array of objects into a file importable into Excel, Google Sheets, Numbers, or any analysis tool (Power BI, Tableau).

    Each object becomes a row, each key becomes a column

    A JSON like [{"name":"Marie","age":30},{"name":"Jean","age":25}] becomes a CSV with two columns (name, age) and two data rows. Keys of the first object serve as headers. Missing values in some objects produce empty cells.

    Nested objects are flattened or serialized

    A JSON with nested objects (address: {street, city}) is either flattened into separate columns (address.street, address.city) or serialized as JSON into a cell, depending on options. Nested arrays are serialized to stay readable.

    Discover all our tools

    Convert, compress, merge and edit your files in a few clicks.

    See all tools

    Complementary tools

    Guides and tutorials

    Learn how to use our tools with our detailed guides.

    Frequently asked questions

    Yes — the union of keys across all objects forms the CSV’s column list.

    They’re either flattened into dot-separated columns or serialized as JSON into a cell.

    Commas by default (CSV standard). Some European spreadsheets expect semicolons: open via "Import" rather than double-click to pick the separator.

    Yes, within browser memory limits: tens of thousands of records handle fine on a recent computer.
    Convert JSON to CSV for free | Convertly Converter