06 tools
Spreadsheet tools
Move data between Excel, CSV and JSON, in both directions.
- XLSX to CSVConvert the first sheet of an Excel workbook to UTF-8 CSV.XLSXtoCSV
- CSV to JSONTurn a CSV with a header row into an array of JSON objects.CSVtoJSON
- XLSX to JSONConvert the first sheet of an Excel workbook to a JSON array, one object per row.XLSXtoJSON
- CSV to ExcelTurn a CSV file into an Excel workbook with typed numbers and a frozen header.CSVtoXLSX
- JSON to ExcelConvert a JSON array of objects into an Excel spreadsheet, one row per object.JSONtoXLSX
- JSON to CSVFlatten an array of JSON objects into CSV rows.JSONtoCSV
Moving data between Excel, CSV and JSON
CSV is the plain-text format almost every app can import, JSON is what web APIs and code expect, and XLSX is what people open in Excel or Google Sheets. Excel to CSV and Excel to JSON take the first sheet of a workbook. CSV to Excel writes numbers as real numbers and freezes the header row, so the file sorts and filters correctly the moment it opens. JSON to Excel and JSON to CSV turn an array of objects into one row per object, which is the quickest way to read an API export as a table.
Before you convert
Check that the first row holds column names; the converters use it as headers or JSON keys. Excel to CSV writes UTF-8, so names with accents or non-Latin scripts survive. Older Excel versions may need the CSV imported through the Data menu to read UTF-8 correctly. Nothing is uploaded, which matters for payroll, customer lists and bank exports.