HTML Formatter
Beautify and indent HTML markup.
OpenPaste spreadsheet rows with a header line and get a JSON array of objects, one per row.
Include the header row; its cells become the JSON keys.
Quoted fields may hold commas, line breaks and doubled quotes.
Each data row turns into one object in a JSON array.
Copy the indented JSON or download it.
Product data lives in a spreadsheet maintained by the marketing team, and your front end needs it as JSON for a static build. Export the sheet as CSV, paste it here, and you have an array ready to commit.
The parser reads the first row as column names (trimmed of surrounding spaces) and turns each following row into an object with those keys. It handles the tricky parts of CSV properly: fields wrapped in double quotes may contain commas and line breaks, doubled quotes inside them become a single quote, a byte order mark at the start of an Excel export is removed, and both Windows and Unix line endings work. Completely empty rows are skipped. Output is indented JSON that updates as you type and downloads as data.json.
Every value comes out as a string, including numbers and true or false, because CSV carries no type information. Duplicate column names overwrite each other, so make headers unique before pasting, and note that the delimiter must be a comma. To browse a large result, open it in the JSON Viewer. To go the other way, use JSON to CSV, and for database seeding the CSV to SQL tool skips the JSON step entirely.
Parsing is done character by character in the browser, so spreadsheets with personal details are not uploaded.
Keyboard shortcut
Answers for this tool. For site-wide help, open the FAQ hub.
CSV has no data types, so the converter keeps every cell as a string rather than guess. That protects values like the ZIP code 02134, which would lose its leading zero as a number. Convert specific fields in your code.
Missing cells become empty strings for the remaining keys. Extra cells beyond the header are ignored.
Not directly; only commas are treated as separators. Re-export with a comma delimiter, or replace semicolons with commas if no cell contains either character.