Question 1

Can I paste directly from Excel or Google Sheets?

Accepted Answer

Yes. Copied cells paste as tab-separated text, and Auto detection picks that up, so you get one JSON object per row with your header row as the keys.

Question 2

How are quoted fields handled?

Accepted Answer

Fully. Fields in double quotes can contain commas, line breaks and doubled quotes ("") for a literal quote mark, following the standard CSV format (RFC 4180).

Question 3

What does “Detect numbers” do?

Accepted Answer

It turns values that look like numbers into JSON numbers and true/false into booleans, but only when nothing changes: 007, 1.50, 1e3 and numbers too long to store exactly, like 12345678901234567890, stay strings. Turn it off to keep every value as a string.

Question 4

What if a row has more or fewer cells than the header?

Accepted Answer

Missing cells become empty strings and extra cells are kept under the names column4, column5 and so on, so nothing is lost. The status line says how many rows didn't match the header.

Question 5

What if there is no header row?

Accepted Answer

Turn off “First row is header” and each row becomes an array of values instead of an object.

Convert CSV to JSON

How to convert CSV to JSON

Why semicolons?