Turn a spreadsheet into JSON
Developers, analysts and no-code builders often keep data in Excel or Google Sheets but need it as JSON to load into an app, a test fixture or an API request.
CSV to JSON treats the first row as the field names and turns every row below into an object. It runs in your browser, so the data is not uploaded.
Convertora does not read .xlsx files directly for this job, so the first step is exporting the sheet as CSV: in Excel use File, Save As, CSV UTF-8; in Google Sheets use File, Download, CSV. Every value in the JSON is text, including numbers and dates, so convert types in your code if your app needs real numbers. Empty cells become empty strings, which keeps every object the same shape.
Step by step
- Export the sheet as CSV UTF-8 from Excel or Google Sheets.
- Open CSV to JSON and add the CSV file.
- Convert and download the .json file.
- Open it in a code editor and confirm the keys match your header row.
Tips
- Give every column a short, unique heading; blank or repeated headers get predictable placeholder names.
- Only the active sheet is exported to CSV, so export each sheet separately.
- Quoted values may contain commas and line breaks; they are read correctly.
Questions
- Are numbers kept as numbers?
- Values are output as text, exactly as they appear in the CSV.
- What if my CSV is malformed?
- A clear error is shown, for example when a quote is never closed, instead of scrambled output.
- Is my data uploaded?
- No. The file is read in your browser.