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

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 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.

Open the API Response to Table

Related tool pages

  • JSON API Response 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

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.