ClarityHow to use this tool
- Enter json array.
- Select Update result to view the result.
- Check the method and assumptions below before using the result.
Input reference and sample values
Use the units and choices shown for each field. Sample values are provided for practice, not as recommendations.
| Input | Format and units | Sample |
|---|---|---|
| JSON array | Keep the structure and separators shown in the sample. Line breaks are retained in this input. | [{"name":"Alex","score":95},{"name":"Sam","score":88}] |
Result for these sample inputs
name,score Alex,95 Sam,88
- Data rows
- 2
- Columns
- 2
Select Try the example in the form to load these values and calculate them again. This replaces the current form inputs. Compare the result with the method and worked explanation below.
The method, explained
Collect keys in first-appearance order across the objects, then write one CSV row per object. Quote cells containing commas, double quotes or newlines, and double embedded quotes.
Objects with name and score properties produce a name,score header and one row for each object.
What to keep in mind
Flat objects only: nested objects and arrays are rejected. Missing values and null become empty cells. CSV is plain data; spreadsheet programs may interpret cells starting with =, +, − or @ as formulas. Do not open untrusted exports without reviewing them.
Reference: RFC 4180: comma-separated values
Common questions
Must every object have the same keys?
No. All discovered keys become columns, and missing values become empty cells.
Does this flatten nested JSON?
No. Restructure nested values explicitly before conversion to avoid silently losing information.
Methodology maintained by ClarityKit. How these tools are built and checked.