Move spreadsheet data between CSV and JSON
Carry an ID with leading zeros and a name with a comma through a complete conversion.
Start with clearly named columns
Open the sample CSV. The id cell contains 0042, and the comma in "Patel, Ria" stays inside the name column because the field is quoted. Select Comma and run the tool. The output should include "id": "0042" and "name": "Patel, Ria". If your spreadsheet uses semicolons, choose Semicolon instead.
Open CSV to JSON →Verify the file before passing it to another system
Copy the output into the JSON validator. It should report a valid array. Check that the receiving system expects an array and that id is a string. You can download the JSON directly from the converter.
Open JSON validator →Return to the spreadsheet with text columns intact
Open the JSON file in JSON to CSV and download the result. Import the CSV with the separator you selected and set the id column to Text in your spreadsheet. Otherwise the spreadsheet may display 0042 as 42. If the converter adds an apostrophe to a formula-like cell, keep the original JSON for an exact copy.
Open JSON to CSV →