# API JSON to CSV Without Python: Browser vs curl and jq

> Three ways to turn an API response into a CSV: a browser tool, curl with jq, or a Python script. When each is the right choice, and what each one needs.

Page: https://datautility.in/blog/api-json-to-csv-without-python-curl-jq
This is the Markdown copy of the page. The tool itself runs in the browser: your files are processed on your own device and are not uploaded.

Published 2026-11-15 · Extract and export · api json to csv without python, curl jq to csv, convert api response to csv, json api to excel, api to csv online, flatten json to csv, no code api to table

You can turn an API response into a CSV with a script, with curl and jq, or in a browser. Each fits a different job.

Open the tool: [API Response to Table](https://datautility.in/api-response-to-table)

Short answer: use a browser tool for a quick, one-off table; use curl with jq or a script when the job must repeat on a schedule or run on a server. They solve the same problem for different situations.

## Option 1: a browser tool

API Response to Table takes an https address and a token, sends one GET request from your browser and shows the JSON as a table. Nested fields become columns such as address.city. You download CSV, Excel, JSON or Parquet.

- Good for: one-off exports, checking what an API returns, people who do not code.

- Needs: nothing installed. The API must allow browser calls (CORS).

- Not for: scheduled jobs, paged APIs that need many calls, or huge responses.

## Option 2: curl and jq

On the command line, curl fetches the response and jq reshapes it. You write a filter that picks the fields and prints rows.

- Good for: scripts, servers and repeat runs, and APIs that block browser calls.

- Needs: a terminal, curl and jq, and some jq knowledge. Nested arrays take care.

- Not for: people who just want to look at the data.

## Option 3: a Python script

A script using a request library and a data table library can call, page through and flatten a response, then write a file.

- Good for: complex logic, paging and automated pipelines.

- Needs: Python, packages and time to write and maintain the code.

## How to choose

- One-off and small: browser.

- Repeating or scheduled: curl with jq or a script.

- API blocks browser calls: curl or a script.

- Many pages to collect: a script.

## A middle path

Build a transformation visually in Data Transformation after loading the table, then export the steps as SQL, pandas, PySpark or dbt code to reuse in a script. That way a one-off exploration can become the start of a repeatable job.

## Privacy note

In the browser tool the request goes from your browser straight to the API. Data Utility never receives the response or your token.

## How to use the API Response to Table: step by step

1. Try the browser tool first for a one-off.
2. Use curl with jq or a script when it must repeat.
3. Export the steps as code if you want to automate it.

## When to use the API Response to Table

- Pull a quick export from a REST endpoint
- Decide between a browser tool and a script
- Turn nested API JSON into columns
- Hand a non-coder a table from an API

## Example

Input:

```
GET https://api.example.com/users + Bearer token
```

Output:

```
id,name,address.city
1,Ada,London
```

## Frequently asked questions

### Can I convert an API response to CSV without Python?
Yes. API Response to Table does it in your browser with no code.

### When is curl with jq better?
When the job repeats, runs on a server, or the API blocks browser calls.

### Does the browser tool handle paging?
No. It makes one GET request, so for paged APIs enter each page address.

### Can I turn the steps into code?
Yes. Data Transformation can export your steps as SQL, pandas, PySpark or dbt.

Tip: If the browser says it cannot reach the API, the API probably blocks browser calls. Use curl or a script.

## Related tool pages

- [JSON API Response to CSV](https://datautility.in/json-api-to-csv): Turn the JSON from an API into a CSV file. Nested fields become columns and you pick which list to use. Free, in your browser, with an optional token.

## Also try

- [API response to CSV with a token](https://datautility.in/blog/api-response-to-csv-with-token)
- [Flatten nested JSON](https://datautility.in/blog/flatten-nested-json-api-response)
- [Public API example](https://datautility.in/blog/api-to-table-jsonplaceholder-example)

## More guides

- [Screenshot to Table: Image to Excel, CSV or Parquet (OCR)](https://datautility.in/blog/screenshot-to-excel-csv-ocr)
- [SQL INSERT Generator: Turn CSV, Excel or Parquet into SQL](https://datautility.in/blog/csv-to-sql-insert-generator)
- [How to Convert Many Screenshots to Excel or CSV at Once](https://datautility.in/blog/convert-many-screenshots-to-excel-or-csv)
