Convert JSONLines to CSV

JSON Lines, also known as JSONL, is a handy format for storing structured data that you can process 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 works great for logging, streaming, and other scenarios where you want to process data line by line without parsing an entire JSON array.

Comma-separated values (CSV) is a simple and popular format for storing tabular data. It's easy to read and create, making it a go-to choice for many.

Row delimiter

The row delimiter separates each row in the CSV data. It's usually a new line character (LF) or a carriage return plus a new line character (CRLF).

We'll automatically detect and parse the rows correctly, so you don't need to worry about it.

Value separator

The value separator splits each value within a row.

For CSV files, it's typically a comma, but it can vary depending on the software used to create the file. We support these separators:

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

Character encoding

The character encoding of your CSV file might differ based on the software you used to create it.

If you're not sure about the character encoding, don't worry. We'll try to guess it automatically if it's not specified.