Can I import JSON directly into Google Sheets?

No. Google Sheets cannot open or parse JSON files natively. You either need a custom Apps Script, a third-party add-on, or a simpler approach: convert the JSON to XLSX first using a free converter, then import the spreadsheet into Sheets via File, Import, Upload.

Do I need Apps Script to convert JSON to Google Sheets?

No. Apps Script works but requires coding and can be slow for large datasets. A faster alternative is to convert JSON to XLSX in your browser, then import the .xlsx file into Google Sheets. The converter handles nested fields, API wrappers, and large files without any scripting.

Will nested JSON fields become columns in Sheets?

Yes. The converter flattens nested objects into dotted column headers such as user.address.city. Once you import the resulting XLSX into Google Sheets, those columns are preserved exactly as they appear in the spreadsheet, ready to filter, sort, and share.

Is the JSON data uploaded to a server?

No. The conversion runs entirely in your browser. Your JSON data never leaves your device and is never sent to any server, so it is safe to use with sensitive or private data.

Can I import multiple JSON files into one Google Sheet?

Yes. Convert each JSON file to XLSX separately, then import each one into the same Google Sheets document using File, Import, Upload and selecting Insert new sheet. Each file becomes its own tab. If a single JSON file contains multiple top-level arrays, those are already split into separate sheets in the XLSX.

How to Import JSON into Google Sheets (Free, No Script)

Last updated: 20 June 2026

Google Sheets is a go-to tool for sharing and collaborating on data, but it cannot open JSON files directly. Unlike CSV, there is no built-in JSON parser in Sheets. The usual advice is to write an Apps Script or install an add-on, but there is a faster path: convert your JSON to XLSX first, then import the spreadsheet into Sheets. No coding, no extensions, and no data leaves your browser.

Why JSON does not open directly in Google Sheets

Google Sheets understands tabular formats like CSV, TSV, and XLSX. JSON is a hierarchical format with nested objects and arrays, so Sheets has no way to map it to rows and columns on its own. The two common workarounds are writing a custom Apps Script that fetches and parses the JSON, or converting the JSON to a spreadsheet format beforehand. The converter approach is the fastest option because it requires no coding and works with any JSON structure.

Step-by-step: JSON to Google Sheets via XLSX

Open the converter and drop your .json file or paste your JSON text directly.
Preview the table. Nested fields are automatically flattened into dotted column headers like user.address.city. Confirm the columns look right before downloading.
Click Download Excel to get the .xlsx file.
Open Google Sheets. Go to File → Import → Upload and select the .xlsx file you just downloaded.
Choose Replace spreadsheet to start fresh, or Insert new sheet to add the data as a new tab in an existing document.
Your JSON data is now in Google Sheets with proper column headers, ready to filter, sort, chart, and share with collaborators.

Why XLSX instead of CSV for Google Sheets

You could convert JSON to CSV and import that, but CSV has significant drawbacks when Sheets re-interprets the data. Numbers stay numeric in XLSX, so a value like 12.0 is not silently turned into 12. IDs with leading zeros (such as 007) are preserved as text in XLSX rather than stripped down to 7. Large numbers like 18-digit order IDs are not rounded by floating-point conversion. XLSX also carries type information per cell, so Sheets does not have to guess. For a deeper comparison, see the JSON to CSV vs Excel guide.

Handling nested JSON and API wrappers

Real-world JSON is rarely flat. API responses come wrapped in envelope objects like { "data": [...] } or { "results": [...] }, with pagination metadata sitting alongside the actual records. The converter auto-detects these wrappers and extracts the record array so you get clean rows instead of a single blob. Nested objects within each record are flattened into dotted columns - for example, customer.name and customer.city sit beside top-level fields like id and total. For details on how flattening works, see the nested JSON to Excel guide and the API response to Excel guide.

Large files and multiple sheets

The converter supports files up to 15 MB. If your JSON contains multiple top-level arrays - for example { "users": [...], "orders": [...] } - each array becomes a separate sheet in the XLSX file. When you import that XLSX into Google Sheets, those tabs are preserved, so each dataset lives on its own sheet. For very large exports, consider filtering fields at the API level before converting. The JSON array to Excel guide covers how arrays map to rows and columns, and the database JSON to Excel guide covers exporting large database dumps.

Frequently asked questions

Can I import JSON directly into Google Sheets?: No. Google Sheets cannot open or parse JSON files natively. You either need a custom Apps Script, a third-party add-on, or a simpler approach: convert the JSON to XLSX first using a free converter, then import the spreadsheet into Sheets via File, Import, Upload.
Do I need Apps Script to convert JSON to Google Sheets?: No. Apps Script works but requires coding and can be slow for large datasets. A faster alternative is to convert JSON to XLSX in your browser, then import the .xlsx file into Google Sheets. The converter handles nested fields, API wrappers, and large files without any scripting.
Will nested JSON fields become columns in Sheets?: Yes. The converter flattens nested objects into dotted column headers such as user.address.city. Once you import the resulting XLSX into Google Sheets, those columns are preserved exactly as they appear in the spreadsheet, ready to filter, sort, and share.
Is the JSON data uploaded to a server?: No. The conversion runs entirely in your browser. Your JSON data never leaves your device and is never sent to any server, so it is safe to use with sensitive or private data.
Can I import multiple JSON files into one Google Sheet?: Yes. Convert each JSON file to XLSX separately, then import each one into the same Google Sheets document using File, Import, Upload and selecting Insert new sheet. Each file becomes its own tab. If a single JSON file contains multiple top-level arrays, those are already split into separate sheets in the XLSX.

Related guides

See all guides or the FAQ.

Convert your JSON for Google Sheets →