REST API Market Data to Excel: Prices to a Sheet

A market data API answers in JSON, but traders and analysts want a sheet. Here is how to get the prices into Excel without code.

Open the API Response to Table

Open API Response to Table, enter the endpoint, choose how you sign in (Bearer token, API key in a header, or username and password) and click Send request. The records become rows, nested fields become columns named by their path, and if the response holds several lists you pick the one that has the bars. Then download Excel.

Excel needs a little care with market data. Keep the symbol column as text so tickers and codes are not changed. Check the date column: an ISO timestamp is the safest, and if your API gives unix times, convert them in Data Transformation with the date step before you share the file. Prices should arrive as numbers, so sort or filter on them to confirm.

Mind the size. A sheet holds 1,048,576 rows, and a minute-by-minute history for several years can be longer than that. For long histories download CSV or Parquet instead, or use the split tool to cut the file into parts.

Only GET requests over https work, and the request goes from your browser straight to the API, so an API that blocks browser calls (CORS) is refused. Use a read-only key. Nothing is uploaded to Data Utility.

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.

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

  1. Open API Response to Table.
  2. Enter the endpoint and sign-in details, then click Send request.
  3. Pick the list that holds the bars and check the columns.
  4. Download Excel and compare the row count with what you expected.

When to use the API Response to Table

  • Look at a price history in a spreadsheet
  • Share quotes with a colleague who uses Excel
  • Build a quick chart from API data
  • Check what an endpoint returns

Example

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

Output: id,name,address.city 1,Ada,London

Frequently asked questions

How does the token work?

Choose Bearer token, API key in a header, or username and password, and paste the value. It is sent only to the API you call, kept in memory, and never saved or written to Data Lineage.

What if the API blocks the request?

Some APIs do not allow calls from other websites (CORS), so the browser blocks the request. Use an API that allows browser access, or ask its owner to enable CORS.

What happens to nested fields?

Nested objects are flattened into columns such as address.city. If the response has several lists, you can choose which one becomes the table.

Is it safe to use a token in API Response to Table?

Your token goes only to the API you call, straight from your browser. Data Utility never receives it or the response. It is kept in memory for that request, not saved, and not written to Data Lineage. Use a token with read-only access when you can.

Tip: Excel stops at 1,048,576 rows. For longer histories download CSV or Parquet.