How to convert Excel or CSV to JSON
- Add your .xlsx or .csv file (first row = headers).
- Pick the first sheet or all sheets, indented or compact.
- Download your .json file.
Project data often starts life in Excel: a product catalog with prices, a list of cities, quiz questions, a club's contacts. To use it in a website, a mobile app or a database import, developers need JSON. Retyping it by hand is slow and error-prone; converting takes seconds.
The first row of the sheet supplies the field names, so an Excel row “Product | Price | Stock” becomes [{"Product": "Green tea", "Price": 25, "Stock": 120}, …]. Numbers stay numbers, empty cells become null and completely empty rows are skipped. With “All sheets” you get one object that groups every sheet under its name.
Choose indented output to read it easily, or compact output for a smaller file. Up to 50 files at once; they are processed in memory and deleted after 30 minutes.
Tip: keep one table per sheet, starting in cell A1, with no title row or merged cells above the headers — otherwise the first row will not hold your field names. Remove total rows at the bottom if you don't want them as records. For CSV files exported from Excel in French, the semicolon separator is detected automatically.
Frequently asked questions
How are the JSON keys named?
They come from the first row of the sheet. Use clear, unique headers such as “name”, “city” and “price”.
Can I convert a workbook with several sheets?
Yes, pick “All sheets”: the JSON then holds one object with a list per sheet, keyed by the sheet name.
Are numbers handled correctly?
Numbers stay numeric values and empty cells become null, so there is little to clean up afterwards.
Do semicolon-separated CSV files work?
Yes, CSV files separated by semicolons (common with European Excel settings) are accepted as well as comma-separated ones.
Is my data private?
Yes, files are processed in memory, never shared, and deleted automatically after 30 minutes.