CSV to JSON

CSV to JSON makes an array of objects from the first row of keys. In the Ada sample, qty is the string 2, not a number, and the file is pretty-printed with two spaces.

Two objects, quoted numbers

The text name,qty then Ada,2 then Bea,3 becomes an array of two objects. The first has name Ada and qty the string 2. The second has name Bea and qty the string 3. A quoted comma stays inside one field. name,note and Ada,"a, b" become one object whose note is a, b without the quote marks. An empty name cell stays an empty string, so a row that is a blank name and qty 3 still has both keys. A file that is only a header row becomes an empty array. A completely empty file also becomes an empty array. Blank lines are skipped. The stored name ends in converted.json. The content type is application/json. The button reads Run CSV to JSON.

What the parser does not guess

There is no type menu, so 2 does not become a number. Dates stay text. Semicolons are not detected as a second delimiter. A second sheet does not exist in a CSV. Excel to JSON is the page that keeps numeric cells as numbers, and it starts from a workbook rather than this text. This page does not sort rows. It does not drop a column. It does not invent a key when the header cell is blank. The first row is always the keys, even if it looks like data. If you needed that row as a record, add a header above it before you upload.

How to read the string 2

Open the JSON and look at qty. If it is wrapped in quotes, this page ran. If a script later rejects the string, convert it in the script. Do not expect this file to do that. The two-space indent is fixed. There is no minify switch on the form. A broken quote fails in the CSV parser before a file is stored. The cap on the upload is 25 MB. The job uses the first file.

The CSV is sent

The CSV is uploaded for the conversion, the cap is 25 MB, and the temporary object is removed after the JSON is ready. Keep the CSV if you still need the original text. The download is the array only. A second file in the same request is not appended. The stored name starts with a timestamp, then converted.json, so two uploads do not share one filename. If a script rejects qty, the quotes around 2 are the reason, and this page will not strip them. A row with a blank name and a qty still keeps the name key as an empty string. The indent is two spaces on every object.