CSV to JSON Converter - Excel & Spreadsheet to JSON Online

Convert CSV, Excel, or Google Sheets data to JSON format instantly. Our free online converter transforms spreadsheet data into properly formatted JSON for APIs, databases, and applications.

• CSV to JSON online: Convert comma-separated values to JSON arrays or objects
• Excel to JSON: Transform spreadsheet data without software installation
• Google Sheets to JSON: Copy-paste directly from Google Sheets
• Multiple output formats: Arrays, objects, key-value pairs, indexed data
• Auto-detect types: Numbers, booleans, and strings detected automatically

Perfect for developers preparing data for APIs, migrating spreadsheets to databases, or converting tabular data for web applications.

Best Sheets to JSON Tool ever

Our Sheets to JSON Tool is the best in the world because it is simple yet advanced, fast, and ad free.

• Easy - Most of the time you want to paste, convert and leave. Our Sheets to JSON does that first, and keeps the rest out of the way until you need it such as custom keys and array or object format.
• Fast - Our Sheets to JSON uploads nothing and waits for nothing: you get JSON as you type. Just copy your data from Google Sheets and get the JSON.
• Modern - Our Sheets to JSON is built in Next 16, with Material 3 design, and served from Vercel edge servers.
• Ad free - Our Sheets to JSON is free from ads. Many other tools are cluttered with ads, but not this one.
• Free for life - Our Sheets to JSON needs no account, has no trial, and sets no usage limit.

How to use

1. Copy your data from Google Sheets.
2. Paste the data into the input field.
3. Copy or Download your JSON output.

Using the JSON Output

Once you have your JSON output, you can easily copy it as a JSON string or as a JavaScript object for direct use in your code.

JSON (pretty) - Pretty printed JSON with indentation and whitespace for better readability. This is useful for debugging and understanding the structure of the data.

JSON - Compact JSON without extra whitespace. This is useful for saving space and for use in production code.

Mastering Sheets to JSON

Learn how to use this tool to its full potential with these tips. Choosing the right mode is key to getting the results you need. Use the Mode option to choose whether your data is represented as an array or a keyed object. This flexibility allows you to format the JSON output according to your specific requirements. The following modes are supported:

• Objects - Use this mode to create an array of objects with keys and values. Each row in your data will be represented as an object with keys and values. The keys are taken from the first row (header) of your data.
• Array - Use this mode to create an array of arrays. Each row in your data will be represented as an array of values. This mode is useful when you want to keep the data in a simple array format.
• Single Array - This mode will create a single flat array of values. This is most relevant when you have a single column of data. If you have multiple columns, the data will be flattened, and all your data will be in a single array.
• Indexed Objects - This mode is similar to the Objects mode, but it will create a single object, keyed by the first column. Each of these will be an object with keys and values. The keys are taken from the first column (header) of your data.
• Indexed Array - This will create an object, indexed by the first column, where the rest of the columns are represented as an array.
• Key-Value Pairs - This mode will create an object with key-value pairs. The keys are taken from the first column, and the values are taken from the second column. If your data has more than two columns, the additional columns will be ignored.

Additional Options

• Filtering - Use the filter option to whitelist or blacklist keys from your data. If you choose to blacklist keys, only the keys you specify will be removed from the output. For example, you might want to exclude a key named password from the output. If you choose to whitelist keys, only the keys you specify will be included in the output.
• Advanced Options > Delimiters - Use the advanced options to further customize how this tool works. You can specify non-standard delimiters for your data. For example, changing the column delimiter to ,, effectively turns this into a CSV to JSON converter.
• Advanced Options > Trimming - Specify custom trim characters to clean your data. Adding trimming can help remove unwanted whitespace from your data.
• Advanced Options > Sorting - Sort your keys or arrays alphabetically or numerically. Although this is relatively easy to prepare in Google Sheets before you copy, this option can still be useful if you need it.

Privacy and Security

Nothing you paste here reaches us. The conversion runs in your browser, so the data never leaves your device, and there is nothing on our side to store or track even if we wanted to. Load the page once and it keeps working offline.

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.

Key

An identifier for a value in a key-value pair within a JSON object.

Array

An ordered list of values in JSON.

Object

A collection of key-value pairs in JSON.

Mode: Objects

Creates an array of objects. Keys are taken from the first row. Values taken from the rest of the rows.

Mode: Arrays

Creating an array of arrays. Each row is represented as an array of values.

Mode: Indexed Objects

Creates an object of objects. The main objects keys are taken from the first column and its values are sub-objects. The sub-objects keys are taken from the first row. The the sub-objects values are taken from the rest of the rows.

Mode: Single Array

Creates a single flat array of values.

Mode: Indexed Array

Creates an object of arrays. The main objects keys are taken from the first column and its values are arrays. The arrays values are taken from the rest of the columns.

Mode: Key-Value Pairs

Creates an object of key-value pairs. The keys are taken from the first column and the values are taken from the second column.

Pretty Print

Formatting JSON to be more readable by adding whitespace and indentation.

Compact JSON

Formatting JSON to be more compact by removing whitespace and indentation.

Whitelist

Include only the spicified values or keys.

Blacklist

Exclude the specified values or keys. Include everything else.

Auto-detect

Automatically detect the data type of each column.

Why we created this tool

Data tends to start life in a spreadsheet, because a spreadsheet is where you can see it and fix it. Then it has to go somewhere else: into a database, into a config file, hard-coded into a component. Google Sheets does not export JSON, so that step is usually a manual retype or a throwaway script.

We created Sheets to JSON because we couldn't find a simple and effective tool for quickly converting Google Sheets data to JSON format. We found ourselves rewriting the same helper functions over and over again for each project. arrayOfArraysToJSONObjects() , arrayOfArraysToJSONArrays() , etc. This tool does all that for you, and more, in a simple copy and paste workflow.

Features

• Easy - Most of the time you want to paste, convert and leave. Our Sheets to JSON does that first, and keeps the rest out of the way until you need it such as custom keys and array or object format.
• Fast - Our Sheets to JSON uploads nothing and waits for nothing: you get JSON as you type. Just copy your data from Google Sheets and get the JSON.
• Modern - Our Sheets to JSON is built in Next 16, with Material 3 design, and served from Vercel edge servers.
• Ad free - Our Sheets to JSON is free from ads. Many other tools are cluttered with ads, but not this one.
• Free for life - Our Sheets to JSON needs no account, has no trial, and sets no usage limit.

Contribute and Share

We are always looking to improve. If you have any feedback or suggestions, please use the feedback button to let us know. We read every feedback and use it to improve this tool.

Share your results with your friends and colleagues. Click and share a link to this tool and optionally include your input and settings as well.

Coming Soon

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

• Support for Auto-detect data types in more modes. Currently only the Objects mode supports auto-detecting data types. We plan to extend this feature to other modes as well.
• Filtering of rows. Currently, you can only filter keys. We plan to extend this feature to allow filtering of rows as well. That could include filtering out based on key or column bound rules.
• Post manipulation of data. We plan to add options to manipulate the data after it has been converted to JSON. This could include replacing values, adding suffixes and prefixes, and more.
• Option to force parsing of specific keys cell values as objects. Auto-detection could also be supported here. Either the user can choose which keys should try to be treated as objects, or the tool can try to detect this automatically by testing cell values for starting and ending with { and } characters.
• Option to support parsing specific keys cell values as arrays. For example, if a cell contains a comma-separated list, it will be parsed as an array. Additionally user should be able to choose their delimiter for the cell array. Auto-detection could also be supported here, although it is unusual to begin and end a cell value with [ and ].
• Option to support parsing specific keys cell values as dates. For example, if a cell contains a date, it will be parsed as a date object. Auto detect and manual key selection should be supported.
• Option to support parsing specific keys cell values as numbers. For example, if a cell contains a number, it will be parsed as a number object. Auto detect and manual key selection should be supported.

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