JSON to CSV converterConverters

JSON to CSV. Nested keys become columns.

Paste an API answer or open a .json file. Nested objects turn into columns like address.city, arrays become joined cells or their own columns, and every row gets the union of all keys.

Cost to you

Free

Runs in your browser. No signup, no API call, no limit per hour.

browser
runs in: none
API calls: none
account

Use it now

Use the JSON to CSV converter here

It runs in your browser. Nothing you type is sent anywhere, there is no signup and no limit.

JSON

Open file

Paste a JSON array of objects, or an object that holds one

Delimiter

Arrays inside a row

Spreadsheet safePuts a ' before text cells that start with = + - or @, so Excel and Sheets do not run them as formulas.

2 rows, 9 columns

Rows taken from the array under "results". Nested keys become dotted column names.

name	rating	reviews	address.street	address.city	address.zip	tags	open_now	website
Blue Door Bakery	4.7	312	12 Rue Oberkampf	Paris	75011	bakery; coffee	true
Maison Lune, Cafe	4.4	87	3 Rue de Bretagne	Paris	75003	cafe		https://example.com/lune

Converted in your browser, up to 50,000 rows. Files you open are read locally and never uploaded.

Run it from your agent

Copy one prompt, give it to your agent.

Fill in the placeholder, paste it, and the agent runs the same job with current data on your looot account and shows the cost.

You give it: a json array of objects, or an object that holds one.
Billed per call, nothing while your agent is idle.
The agent shows the price before it calls.

Prompt: JSON to CSV converter

Use looot to pull [data, such as dentists in Lyon from Google Maps] and save it as CSV. 1. Set up https://looot.ai/skill.md. 2. Search the catalog for an endpoint that returns this data and check its price before you call. 3. Run it. 4. Flatten the JSON rows to CSV with dotted column names, join list fields with semicolons and save results.csv. 5. Return the row count and the cost.

Give this to your agent

Setup command

set up looot - https://looot.ai/skill.md

What comes back

What your agent gets from json to csv

Field names as the providers return them. The exact set varies by endpoint, and your agent reads it from the catalog.

CSV text
column names from flattened keys
row and column count
table preview

Use it for

What people do with json to csv

API answer to sheet
Turn a JSON response into a table you can sort and filter in Excel or Sheets.
Check a payload
See every key every row uses, including the ones only some rows have.
Quick import
Prepare a CSV for a CRM or database import without writing a script.
Agent output
Paste what your agent returned and hand the CSV to a teammate.

Set up once

Three steps. Your agent does the rest.

Paste one prompt into your agent

Set up looot

Done, looot is connected.

Copy one prompt from /connect into Claude Code, Cursor, or any MCP agent. No SDK, no dashboard click-through first.

Your agent finds the right operation

Hunter$0.0265

Exa$0.0090

Diffbot$0.0032

The agent finds the operation it needs and sees the price first. It calls nothing blind.

You watch what it cost

Hunter$0.0265

Exa$0.0090

Diffbot$0.0032

Total$0.0387

Every call settles for its quoted price and lands in the ledger. You always know what ran and what it cost.

Keep going

Formatters
JSON formatter and validator
Pretty prints or minifies JSON, sorts keys and points to the exact line and column of any syntax error.
Free, no signupno limit
Validators
Regex tester
Live regex matching with highlighted matches, capture groups, flags and a replace preview. JavaScript syntax.
Free, no signupno limit
Converters
cURL to fetch converter
Turns a curl command into JavaScript fetch, axios or Python requests code, with headers, JSON body, forms and auth.
Free, no signupno limit

FAQ

Questions about json to csv

Paste the JSON in the box. A top-level array becomes the rows. If the JSON is an object, the first array of objects inside it, such as results or data, becomes the rows. The CSV appears below as you type.

They are flattened into dotted column names. An address object with a city field becomes an address.city column.

Pick one of three modes: join plain values into one cell with semicolons, give each item its own column such as tags.0 and tags.1, or keep the array as JSON text in one cell.

The CSV gets every key that appears in any row, in the order they first appear. Rows without a key get an empty cell.

Yes. Download the .csv and open it. For locales that use a comma as the decimal mark, pick the semicolon delimiter. Turn on spreadsheet safe to stop cells that start with = from running as formulas.

Up to 50,000 rows and 20 MB per file, in the browser. For larger exports a script or a command line tool is faster.

Yes. Numbers are copied as written, so a 19 digit id does not get rounded the way JSON.parse would round it.

No. The conversion runs on this page and files are read locally.

For agents

tool: JSON to CSV converter
category: Converters
input: A JSON array of objects, or an object that holds one
output: CSV text, column names from flattened keys, row and column count, table preview
price: per call, read live from the catalog on the web page
web tool: runs in the visitor's browser, no API call, free and unlimited
schedule: on demand
setup: https://looot.ai/skill.md
llms.txt: https://looot.ai/llms.txt
updated: 2026-10-14

markdown /free-tools/json-to-csv.md

Run json to csv from your own agent.

Start your workspace, top up, and paste the prompt into the agent you already use. It runs the job with live data and shows the cost first.

Start your workspace See all free tools

Use the JSON to CSV converter here