JSON to Sheets

How to use

1. Paste your JSON data into the input field.
2. Copy or download your tab-separated values output.
3. Paste the values into Google Sheets.

Extended support

Both JSON & JS Code - To extend this tool for versatility and ease of use, we have extended support from not only strict JSON, but also JavaScript code. This means you can paste not only strict JSON data, but also object and array variable definitions in JavaScript, directly from VSCode, or any code editor.

Automatic detection - The tool will first assume that you are pasting strict JSON data, and try to convert it as is. If it fails, it will try its best to interpret it as JavaScript code. This is useful if you have a JSON data that is not properly formatted, or if you have a JavaScript object definition that you want to convert to a table without converting it to JSON first.

Other data types - If the tool fails to convert your data both as JSON and as JavaScript code, it will not try other languages or data types. If you want to see a specific language supported, like Python to Sheets, Ruby to Sheets, or others, please let us know. Similarly, if your conversion fails and you think it should be supported, please let us know. You can use the feedback

Using the Sheets Output

Once you have your tab-separated values output, you can easily paste it into Google Sheets or other spreadsheet software. When you paste you should instantly see the full table parsed into its individual cells.

We have included a Pretty Printed JSON tab, which will show you the JSON data in a more human readable format. This is useful if you want to inspect the JSON data structure, or if you want to copy the JSON data back into a JSON file or other JSON editor.

Scope and Limitations

This tool is designed to convert simple JSON data to a format that can be pasted into Google Sheets. It supports the following simple JSON structures:

• Array of Objects - An array of objects, each containing one of the primitive data-types: string, number, boolean or null. Each object represents a row in the sheet. The keys of the objects become the column headers.
• Array of Arrays - An array of arrays, each containing one of the primitive data-types: string, number, boolean or null. Each array represents a row in the sheet. No column headers are generated.
• Single Object - A single object, containing one or more key-value pairs of the primitive data-types: string, number, boolean or null. The keys and values of the object become the column headers and first row of the sheet, respectively.
• Single Array - A single array, containing one or more of the primitive data-types: string, number, boolean or null. Each element of the array represents a row in the sheet. Since there is only one array, there will be only one column in the sheet.
Limitations
This tool is designed for simple JSON data structures. It is meant to be able to convert JSON into simple tables. Therefore, it does not support nested data structures or more complex JSON data. If you have more complex JSON data, you may need to preprocess it before using this tool.

Mastering JSON to Sheets

Learn how to use this tool to its full potential with these tips and tricks.

• Properly formatted JSON - Ensure your JSON data is properly formatted before pasting it into the tool. Use a JSON linter or validator to check for syntax errors.
• Working through issues - If you encounter issues with the conversion, the tool will try to identify the problem and let you know what went wrong. Use the error message to correct the issue and try again.
• Simplify - If you have issues that you cannot resolve, try simplifying your JSON data. Remove any unnecessary complexity and try converting again. Try to isolate the issue by removing parts of the JSON data until you find the problem.

Advanced Options

• Delimiters - Customize the output column and row delimiters to fit your specific needs. For example, you can change the column delimiter from the sheets copy and paste preferred tab, to a comma for CSV output. This effectively turns this tool into a JSON to CSV converter, with the noted limitations above.
• Trimming - Enable the trim option to trim each cell in the output.
• Sorting - Sort your data alphabetically or numerically before converting to sheet format. Although we recommend that you leave this off, and handle sorting as you would normally do in Google Sheets, through filters and filter-views.

Privacy and Security

We take your privacy and security seriously. This tool runs entirely in your browser and does not send any data to our servers. Your data stays on your own device and is not accessible to anyone but yourself.

Definitions

JSON

JavaScript Object Notation, a lightweight data-interchange format that is easy for humans to read and write and easy for machines to parse and generate.

Tab-Separated Values (TSV)

A simple text format for storing data in a tabular structure (e.g., spreadsheet or database). Each record in the table is one line of the text file, with fields separated by tabs.

Delimiter

A character that separates fields or records of data.

Trim

To remove unwanted whitespace from the start and end of a string.

Why we created this tool

As developers, we often need to convert data between different formats. JSON is a common format for data exchange, but working with JSON in spreadsheet software like Google Sheets can be cumbersome. This tool simplifies the process by converting JSON data to a format that can be easily pasted into Google Sheets.

We created JSON to Sheets because we couldn't find a simple and effective tool for quickly converting JSON data to a spreadsheet-compatible format. This tool does all that for you, and more, in a simple copy and paste workflow.

Features

• Simple yet advanced - Choose from various formatting options to create the sheet structure that fits your needs.
• Fast - Convert your data instantly. Just paste your JSON and get your tab-separated values.
• Fast - Our JSON to Sheets is fast. Start now and instantly get TSV. Just paste your JSON and get the tab-separated values.
• Easy - Sometimes you just need a simple tool with no fuss. Our JSON to Sheets is just that. But for those times when you need more, it also has powerful features such as custom keys and array or object format.
• Modern - Our JSON to Sheets is built in Next 13, with Material 3 design and served on blazingly fast Vercel edge servers.
• Ad free - Our JSON to Sheets is free from ads. Many other tools are cluttered with ads, but not this one.
• Free for life - Our JSON to Sheets is free to use forever.

Contribute and Share

We are always looking to improve. If you have any feedback or suggestions, please use the feedback button

Share your results with your friends and colleagues. Click

Coming Soon

We are constantly improving this tool. Here are some of the features we have planned for future implementation:

• Advanced filtering and manipulation options for the JSON data after conversion.
• Customizable output formats for different spreadsheet software.
• Allowing you to choose if you want to try javascript conversion if JSON conversion failsn or not. Right now the tool does it regardless. This could be unwanted behavior in the cases where you need to detect strict JSON errors as part of your conversion.
• Enhanced error handling and data validation. For example we could help you highlight the actual character where the JSON parsing failed, or at least repeat the text so you can find it easier. Right now it is referenced only by row position, column position and sometimes only position, depending on the type of error. This can be tedious to find in raw text.

If you want to see any of these features quicker, please let us know by using the feedback