Skip to main content
appkiro.com
Data

JSON to CSV

Convert pasted JSON, public JSON APIs, or uploaded JSON files into CSV with delimiter, quoting, line ending, and BOM controls — all processed in your browser.

Read the full guide

Practical guide

JSON is good for APIs, but a teammate may need the same records in a spreadsheet. Paste an API response or upload a JSON file, flatten the fields that matter, and export CSV with delimiter and quoting choices. If CSV feels too limited, create an Excel file instead.

Example preview

Visual examples show the kind of input and output this tool is designed around.

Nested JSON to spreadsheet columns

Flatten records and pick CSV options before handing data to a spreadsheet workflow.

Before
JSON to CSV demo showing JSON records converted into CSV columns before
After
JSON to CSV demo showing JSON records converted into CSV columns after

Where this fits

Hand API data to non-developers

Convert arrays of records into columns so support, marketing, or operations teams can filter and sort them in a spreadsheet.

Prepare exports for regional tools

Choose semicolon, tab, or pipe delimiters when the receiving system cannot safely read comma-separated files.

Document structured data

When the output belongs in a README or issue comment, make a Markdown table instead of attaching a CSV.

How to use JSON to CSV

  1. 1Provide JSON dataPaste JSON, upload a file, or fetch a public JSON endpoint.
  2. 2Select recordsUse an array of objects when possible; review nested values before flattening.
  3. 3Choose delimiter and quotingPick the CSV format expected by the receiving spreadsheet or import system.
  4. 4Check the previewLook for nested objects, arrays, blank columns, and values that need quotes.
  5. 5Download the CSVSave the file with the line endings and BOM setting that matches the destination.

Practical notes

Keep a JSON copy for edits

CSV is a delivery format, not a perfect representation of nested data. Keep the original JSON so you can convert CSV back to JSON only when the spreadsheet edit is intentional.

API response to spreadsheet

Treat CSV export as a translation step; verify columns before sending the file to someone who will not see the original JSON.

  1. 1

    Inspect JSON shape

  2. 2

    Export CSV

  3. 3

    JSON to Excel

Questions worth checking

Why do nested objects appear as text in CSV?

CSV cells are flat. Nested JSON has to be flattened into column names or serialized into cell text, depending on the shape of the data.

When should I add a BOM?

Add a BOM when Excel or another spreadsheet app misreads UTF-8 characters. It can help names, accents, and symbols open correctly.

Which delimiter should I choose?

Comma is the common default. Use semicolon for regional spreadsheet settings, tab for TSV workflows, and pipe when commas are common inside values.

Workflow links

create an Excel fileUse when CSV is not enough and a stakeholder expects an XLSX workbook.make a Markdown tableUse when the same data should appear in a README, issue, or docs page.convert CSV back to JSONUse when a spreadsheet edit needs to return to an app or API fixture.

Related tools

JSON to ExcelConvert JSON arrays, API responses, and uploaded JSON files into Excel spreadsheets with flattening, array expansion, and CSV export.
JSON to Markdown TableConvert JSON arrays or objects into clean Markdown tables, lists, structured documents, or HTML tables. Perfect for README files, GitHub, Notion, and Obsidian — all processed in your browser.
CSV to JSONConvert pasted CSV/TSV, uploaded CSV files, or public web page tables into JSON directly in your browser.