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 tableSelect 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.Write yours in the highlighted part. Anything left in brackets reaches your agent as is.
{"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.
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
Related terms
- 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.