Convert CSV to JSONLines

Add your CSV data and automatically convert it to JSONLines.

CSV input options
JSONLines output options
This format does not have any output options.

CSV

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.

JSONLines

JSON Lines, also known as JSONL, is a convenient format for storing structured data that may be processed one record at a time.

Each line in a JSON Lines file is a valid JSON object, typically representing a single record. The lines are separated by newline characters, making it easy to read and write sequentially.

This format is particularly useful for logging, streaming, and other scenarios where you want to process data line by line without having to parse an entire JSON array.

Convert CSV