CSV to JSON Lines (JSONL) converter

How to use it

1. Enter csv data, cell delimiter, convert numbers and true/false to types and trim spaces around each cell.
2. The result appears straight away and updates as you edit.
3. Copy the result, or copy a link that keeps the same values to share it.

How it is calculated

The header row gives the keys (a blank header becomes column_N, a repeat gets _2). Each data row becomes JSON.stringify of one object on one line. With types on, 30 becomes a number and true/false become booleans.

Example

Inputs: Cell delimiter = Detect automatically, Convert numbers and true/false to types = yes, Trim spaces around each cell = yes. Result: JSON Lines: {"product":"Tea","price":12.5,"qty":3} {"product":"Coffee","price":18,"qty":2} {"product":"Dates","price":30,"qty":1}; Records: 3; Columns: 3.

product,price,qty
Tea,12.5,3
Coffee,18,2
Dates,30,1

{"product":"Tea","price":12.5,"qty":3}
{"product":"Coffee","price":18,"qty":2}
{"product":"Dates","price":30,"qty":1}

Limits and caveats

• Numbers with leading zeros like 007 and integers above 9007199254740991 stay as text so they are not altered.
• An empty cell stays an empty string "" and does not become null.