Building this into your own product?
Call the same conversion from your own code with the developer API, using the same prepaid credits.
How to Put JSON Into Google Sheets
- Paste or drop your JSON. An array of records, an API response, or JSON Lines all work. Wrapped responses like
{"data": [...]}are unwrapped for you. - Check the table. It appears instantly, with the exact rows and columns Sheets will get, with nested fields flattened into columns like
Address.City. - Copy, then paste into A1. Click Copy for Google Sheets, open your sheet, select cell A1, and paste with Ctrl+V (⌘V on a Mac; on a phone, tap A1 twice and choose Paste). Every value lands in its own cell.
Prefer a file? Download CSV and use in Google Sheets. Copying, the CSV, and the Excel file are all built in your browser, so your data never leaves your device.
What the Output Looks Like in Google Sheets
Each pattern below shows the JSON you paste and the columns Google Sheets gets after you click Copy for Google Sheets and paste into cell A1.
Flat array of objects
Each key becomes a column header, each object becomes a row.
Input JSON
[
{ "id": 1, "name": "Alice", "role": "Engineer" },
{ "id": 2, "name": "Bob", "role": "Designer" }
]
Google Sheets output
| id | name | role |
|---|---|---|
| 1 | Alice | Engineer |
| 2 | Bob | Designer |
Nested objects
Nested fields become dot-notation columns like address.city, so every value gets its own cell in Sheets.
Input JSON
[
{
"name": "Alice",
"address": { "city": "Austin", "state": "TX" }
},
{
"name": "Bob",
"address": { "city": "Leeds", "state": null }
}
]
Google Sheets output
| name | address.city | address.state |
|---|---|---|
| Alice | Austin | TX |
| Bob | Leeds |
Wrapped API responses
APIs often wrap data inside {"results": [...], "total": 42}. The converter detects this and extracts the array, so you do not need to edit the JSON before pasting it.
How the Copy for Google Sheets Button Works
Everything runs in your browser. No data is uploaded to a server at any point.
- Parse and validate. Your JSON is parsed in the browser. If it is invalid, the error message shows the exact line and character. Wrapped responses are detected and unwrapped.
- Flatten nested structures. Objects inside objects become dot-notation columns. Arrays of objects expand into one row per item. Simple arrays like tags become a single comma-separated cell.
- Format for Sheets. IDs with leading zeros are prefixed so Sheets treats them as text, not numbers. Dates, booleans, and nulls are kept in their original form. The result is placed on your clipboard as a tab-separated table.
- Paste into A1. Open Google Sheets, click cell A1, and Ctrl+V (⌘V on Mac). Each value lands in its own cell. Apply filters, add totals, or create a pivot table right away.
Who Uses This
- Data analysts pasting API responses or log exports into Sheets for pivot tables and charts without leaving the browser.
- Developers sharing API data, test fixtures, or config exports with teammates who work in Google Sheets instead of a code editor.
- Product managers pulling analytics, feature-flag configs, or A/B test results out of JSON into a spreadsheet for stakeholder reviews.
- Operations teams importing payment-processor or CRM exports into Sheets for reconciliation and auditing.
Frequently Asked Questions
Can Google Sheets open a JSON file directly?
No. Google Sheets imports CSV, TSV, and Excel files, not JSON. Convert the JSON to a flat table first: copy the result above and paste it, or download the CSV and use .
How are nested objects and arrays handled?
Nested objects become dot-notation columns like address.city. Arrays of objects become one row per item, with the parent's fields repeated, and simple arrays like tags become one comma-separated cell. It is the same logic as the JSON to Excel converter; see a worked example.
Will Google Sheets change any of my values?
Copy for Google Sheets marks text that Sheets would otherwise rewrite, such as IDs with leading zeros (00123) or text starting with =, so it is kept as text. Real JSON numbers stay numbers you can sum and sort. If you import the CSV instead, untick "Convert text to numbers, dates, and formulas" in the import dialog to preserve leading zeros.
Is my JSON uploaded anywhere?
No. The preview, Copy for Google Sheets, Download CSV, and Download Excel all run entirely in your browser. Your data never leaves your device.
What is the maximum file size?
There is no hard limit because nothing is uploaded. The practical limit depends on your browser's memory. Files with tens of thousands of rows convert without issues. Google Sheets itself has a 10-million-cell limit per spreadsheet.
Can I convert JSON Lines or NDJSON?
Yes. Drop a .jsonl or .ndjson file and each line becomes a row. Learn more about the format in what is NDJSON.
Is this the same as IMPORTDATA or Apps Script?
IMPORTDATA pulls CSV from a URL into a live sheet, and Apps Script can fetch and parse JSON inside Sheets. This tool is faster for one-off conversions: paste, copy, done. For repeated imports from the same API, Apps Script gives you a refresh you can schedule. Read more in how to import JSON into Google Sheets.
Can I automate this?
Yes. The developer API exposes the same conversion as an HTTP endpoint. Send JSON in, get a spreadsheet back.
Related Tools
- JSON to Excel — download a formatted
.xlsxworkbook instead of pasting into Sheets. - Nested JSON to Excel — see how nested objects and lists become columns and rows.
- Excel to JSON — convert a spreadsheet back into a JSON array of objects.
- JSON Formatter and Validator — pretty-print and validate your JSON before converting it.
- JSON Viewer — open and explore a JSON file in a collapsible tree view.