Excel To Json

Convert a CSV-style spreadsheet file into a JSON array of objects. Despite the name, the parser reads the uploaded file as text and splits on commas and newlines, so it works reliably on .csv files rather than binary .xlsx/.xls workbooks. Numeric cells are auto-parsed to numbers; everything else stays a string.

1. Click the file input and choose a .csv, .xlsx, or .xls file. 2. Toggle First Row As Keys: when on, the first row becomes object property names; when off, keys are generated as Column1, Column2, and so on. 3. Click Convert. 4. Use Copy or Download (data.json) on the result.

Lines are split on \r?\n and blank lines are dropped. Cell values are trimmed and outer double quotes are stripped. Each non-header cell is passed through parseFloat: if the result is not NaN the value becomes a number, otherwise it remains a string. Missing trailing cells in a row are filled with null. Output is pretty-printed JSON with 2-space indentation. Errors surface for no file, empty file, or parse failure.