Free online CSV to JSON converter. Just load your CSV in the input field and it will automatically get converted to JSON. In the tool options, you can adjust the input CSV format by specifying the CSV delimiter symbol, quote symbol, and comment symbol. Additionally, you can configure the conversion process and turn column headers into JSON keys, activate dynamic data types, skip empty CSV lines, and choose the JSON indentation format. Created for developers by developers from team Browserling.
Free online CSV to JSON converter. Just load your CSV in the input field and it will automatically get converted to JSON. In the tool options, you can adjust the input CSV format by specifying the CSV delimiter symbol, quote symbol, and comment symbol. Additionally, you can configure the conversion process and turn column headers into JSON keys, activate dynamic data types, skip empty CSV lines, and choose the JSON indentation format. Created for developers by developers from team Browserling.
This tool converts data from CSV format (Comma Separated Values) to JSON (JavaScript Object Notation) format. CSV is a tabular text file with data organized in rows and columns, which are separated by commas. It's commonly used for exporting data from databases and spreadsheets. JSON is a structured text format based on key-value pairs and nested arrays and objects, and it's ideal for exchanging data between programming languages, applications, and online services. Converting CSV to JSON makes it easy to import data from databases and spreadsheets into web applications and APIs. When you load a CSV file in the tool's input, you can customize options for its format. Specifically, you can specify the delimiter, quote, and comment characters used in your CSV file. By default, these characters are comma (,) for the delimiter, double quotes (") for quoting, and the hash symbol (#) for the comment character. If you're working with custom CSV files, you can change them. For example, if you're working with a semicolon-separated file, then you can set the delimiter to a semicolon (;), or if your file contains comments that start with two slashes (//), you can set them as the comment symbol. You can also fine-tune the conversion process. Specifically, you can create JSON objects where CSV column headers are used as keys in the associative objects. This can be controlled via the "Convert Headers to Keys" option. If this option is off, then a JSON array with nested arrays containing corresponding CSV rows will be created. Additionally, the tool can automatically detect numeric or boolean values in the CSV data and convert them to real JSON values (without quotes), preserving their data types. You can also customize JSON indentation and prettify it using two spaces or one tab per indentation level, or output a compact JSON without indentation. Last but not least, you can exclude CSV rows that contain no symbols (empty records). For the reverse data conversion from JSON to CSV, you can use our Convert JSON to CSV program. Json-abulous!
This tool converts data from CSV format (Comma Separated Values) to JSON (JavaScript Object Notation) format. CSV is a tabular text file with data organized in rows and columns, which are separated by commas. It's commonly used for exporting data from databases and spreadsheets. JSON is a structured text format based on key-value pairs and nested arrays and objects, and it's ideal for exchanging data between programming languages, applications, and online services. Converting CSV to JSON makes it easy to import data from databases and spreadsheets into web applications and APIs. When you load a CSV file in the tool's input, you can customize options for its format. Specifically, you can specify the delimiter, quote, and comment characters used in your CSV file. By default, these characters are comma (,) for the delimiter, double quotes (") for quoting, and the hash symbol (#) for the comment character. If you're working with custom CSV files, you can change them. For example, if you're working with a semicolon-separated file, then you can set the delimiter to a semicolon (;), or if your file contains comments that start with two slashes (//), you can set them as the comment symbol. You can also fine-tune the conversion process. Specifically, you can create JSON objects where CSV column headers are used as keys in the associative objects. This can be controlled via the "Convert Headers to Keys" option. If this option is off, then a JSON array with nested arrays containing corresponding CSV rows will be created. Additionally, the tool can automatically detect numeric or boolean values in the CSV data and convert them to real JSON values (without quotes), preserving their data types. You can also customize JSON indentation and prettify it using two spaces or one tab per indentation level, or output a compact JSON without indentation. Last but not least, you can exclude CSV rows that contain no symbols (empty records). For the reverse data conversion from JSON to CSV, you can use our Convert JSON to CSV program. Json-abulous!
This example converts a CSV file containing student grades into a JSON array with two associative objects. It enables the "Convert Headers to Keys" option to convert the column names on the first row of CSV into JSON object keys. As a result, the grade information is printed as a data structure that can be imported into JavaScript for further analysis. Additionally, the JSON output is prettified and printed hierarchically with two spaces per indentation level.
In this example, a two-column and four-row CSV file is converted into a JSON array. As the input CSV contains empty lines, the "Skip Empty Lines" option is turned on to ensure data integrity. In the output, the program prints a JSON array containing another four subarrays, where each inner array corresponds to a single non-empty CSV row.
In this example, we enable dynamic type conversion. It automatically identifies numeric and boolean values in CSV data and outputs them as JSON values without quotes. In the input, we load store inventory CSV data, and in the output, we get JSON data with nested objects containing information about the product's id, name, price, and availability. Additionally, we use the "#" symbol as a comment marker to skip the last incomplete CSV line during the conversion.
You can pass input to this tool via ?input query argument and it will automatically compute output. Here's how to type it in your browser's address bar. Click to try!
Find keys and/or values that interest you in a JSON file.
Create a text list from a JSON array or object.
Create a JSON array from a text list.
Generate HTTP form data from a JSON object.
Generate JSON object from HTTP form data.
Create a HTML table from keys and values of a JSON object.
Convert a JSON file to a CSON file.
Convert a CSON file to a JSON file.
Convert a JSON config to a TOML config.
Convert a TOML file to a JSON file.
Convert a JSON data structure to Bencode encoding.
Convert Bencode data to JSON data.
Convert a JSON file to a JSONL file.
Convert a JSONL file to a JSON file.
Convert binary JSON data structure (BSON) to JSON.
Convert a JSON file to a universal binary JSON (UBJSON).
Convert universal binary JSON (UBJSON) to regular JSON.
Serialize JSON data to binary MessagePack format.
Unserialize binary MessagePack to a JSON struct.
Serialize JSON data to binary Protobuf format.
Unserialize binary Protobuf to a JSON struct.
Generate a LaTeX table from a JSON object.
Convert a JSON data file to an INI configuration file.
Convert an INI configuration file to JSON data file.
Loop over JSON structure and truncate all values or keys.
Find the nesting depth of a JSON data structure.
Convert a JSON data structure to a data URL.
Create a PHP data structure from a JSON data structure.
Create a JSON data structure from a PHP data structure.
Diff JSON files and show differences visually.
Lexicographically sort the order of JSON object keys.
Exchange keys with values in a JSON file.
Create a JSON array with random values.
Create a JSON object with random keys and values.
Randomly change the positions of array elements.
Randomly change the order of key, value pairs.
Add random spaces and newlines in a JSON file.
Tokenize a JSON data structure.
Remove all JSON syntax and leave just the values.
Change curly braces, commas, and quotes to other symbols.
Fix incorrectly quoted (usually single quote) keys and values.
Make all keys and values in a JSON to be single-quoted.
Make all keys and values in a JSON to be double-quoted.
Create JSON that looks real but is fake (FakeSON).
Execute a jq query on a JSON data structure.
Filter keys and values that match a pattern.
Create a JSON array from a string.
Create groups of JSON array items.
Merge two or more JSON arrays together.
Find differences in two or more JSON arrays.
Merge two or more JSON objects together.
Introduce errors in a JSON data structure.
Try to fix a damaged JSON to the best of our ability.
Convert images to valid JSON strings that look like ASCII art.
Create an abstract visualization of JSON's complexity.
Subscribe to our updates. We'll let you know when we release new tools, features, and organize online workshops.
Enter your email here
We're Browserling — a friendly and fun cross-browser testing company powered by alien technology. At Browserling, our mission is to make people's lives easier, so we created this collection of JSON tools. Our tools have the simplest user interface that doesn't require advanced computer skills and they are used by millions of people every month. Behind the scenes, all JSON tools are actually powered by our web developer tools that we created over the last couple of years. Check them out!
