Convert JSON to CSV

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

Originally created for JavaScript, JSON quickly has become the dominant format for web data exchange due to its simplicity and versatility. It's now widely used across various programming languages and platforms.

Primarily used in web applications, JSON efficiently represents structured data from simple key-value pairs to complex nested objects and arrays, making it ideal for client-server communication.

Schema

JSON's flexible structure, while advantageous, can pose challenges for data integrity and processing, especially with large or complex datasets.

Konbert automatically detects the schema of your JSON data. By scanning your JSON file to identify its structure, we ensure all data is accurately captured and maintained throughout the conversion process, preserving the integrity of your information.

Character encoding

As stated by the RFC 8259, we expect strings in uploaded JSON files to be encoded in UTF-8.

If your file contains non UTF-8 characters, you might get an error when parsing your data.

Nested data

We support reading and flattening nested objects and arrays in case you want to convert it to flat data like CSV or Excel.

Comma-separated values (CSV) is a simple and widely used format for storing tabular data. It is human-readable and easy to generate and parse.

Row delimiter

The row delimiter is the character used to separate each row in the CSV data. This is usually a new line character (LF), or a carriage return plus a new line character (CRLF).

We will automatically detect this and parse the rows correctly.

Value separator

The value separator is the character used to separate each value inside a row.

For CSV files, as the name implies it is usually a comma, but it can be different depending on the software used to generate the CSV file, we support the following separators:

• Comma ,
• Tab \t
• Pipe |
• Hash #
• Semicolon ;

Character encoding

Depending on what software you used to generate the CSV file, it might have a different character encoding

If no character encoding is specified we will automatically try to guess it, so you don't have to worry about it if you're unsure.