Skip to content

JSON

JSON is a text format for structured data: labels and values inside curly braces, lists inside square brackets. Programs use it to pass data to each other.

How to do it: read a JSON file and turn it into a table

Select any words here to ask your Maestro about them.

How to do it

Read a JSON file and turn it into a table

How to tell it worked. You get one row per item in the list and one column per field. If you see a single cell that says List or Record, it still needs expanding.

Ask an AI assistant

For your own sheet, in ChatGPT, Claude or Copilot: copy the prompt and fill in the brackets.

I have a JSON file shaped like this: paste a piece. Show me how to turn it into a table in Excel with Power Query and in Python with pandas.
Prompt

Write yours in the highlighted part. Anything left in brackets reaches your agent as is.

JSON
{"country": "Chile", "year": 2007, "continents": ["Americas"]}

If it looks like a Python dictionary, that's because it nearly is one. JSON always uses double quotes, and it writes true, false and null where Python writes True, False and None.

Every Altair chart becomes JSON in the end: a Vega-Lite specification that the browser draws. chart.to_json() shows it.

Ask your Maestro about JSON

It answers from a free course page that uses this word, the way it answers while you study.

Example

You: What does "JSON" mean, in plain words?

Your Maestro: I'll explain it with a case of yours: it sticks better than a definition. Want to see the JSON behind an Altair chart?

Asking about: Answers from the page "How do I review a misleading dashboard? Fix one with four questions"

Only this browser keeps what you ask here. How it works

In Maestro's courses

Learn more

  • Vega-Lite

    Vega-Lite is a language for describing charts in JSON: you name the data, the mark and which column goes on each axis, and a renderer draws it. Altair writes Vega-Lite for you.

  • Altair

    Altair (Vega-Altair) is a Python package for making charts by describing them: you say which column goes on each axis, color or size, and it writes the Vega-Lite that draws the chart.

The whole glossary