Why AI output is "almost JSON"
When ChatGPT or Claude gives you structured data, it usually looks like this:
```json
[{ "name": "Ada", "role": "engineer" }]
```
Three things get in your way: the markdown fences (```json), sometimes a friendly intro sentence ("Here is the data you asked for:"), and occasionally a trailing remark. Paste that into a strict converter and it fails — so most people start hand-deleting lines.
The one-step method
- Copy the AI's entire answer — fences, prose and all.
- Open the JSON to CSV converter. The “Fix pasted AI output” option (on by default) strips fences and stray prose automatically, then converts.
- Copy the CSV or download it — it opens cleanly in Excel, Google Sheets, pandas or R.
The same trick works across the whole toolkit: JSON → Markdown table for READMEs and Notion, JSON → SQL for seeding a database, CSV → HTML table for email templates and pages.
Going the other way: table → AI-ready JSON
Sometimes you have the spreadsheet and want JSON for an API call. Copy the cells straight out of Excel or Google Sheets and paste into TSV → JSON — spreadsheets copy as tab-separated values, so there is no export step. If you already have a CSV file, use CSV → JSON instead.
Common gotchas
- Single objects vs arrays. If the AI returned one object but you expected a list, wrap it in
[ ]— or just paste it: the converter handles both. - Numbers as strings. AI output like
"price": "9.99"keeps prices as text. For SQL, the generators infer column types from the data — check the CREATE TABLE before running it. - Huge tables. For big results, ask the AI for compact JSON (no pretty printing), then format here with JSON Formatter.
- Secrets. Everything on JSONSheet runs in your browser — but as a rule, strip credentials from any data before pasting it anywhere.
TL;DR
Paste the whole AI answer into JSON → CSV, keep "Fix AI output" checked, download. Ten seconds, zero manual cleanup — and your data never left your machine.