Excel to JSON Converter

How to Use Excel to JSON Converter

1. Upload your Excel fileby dragging and dropping it onto the upload area or clicking “Browse” to select it from your file system. The tool accepts .xls, .xlsx, .xlsb, and.ods files up to 20 MB.
2. Select a sheet from the dropdown if your workbook contains multiple sheets. By default, the first sheet is converted. All available sheet names are populated automatically after the file is parsed.
3. Choose the output format— “Array of Objects” produces JSON objects with column headers as keys (e.g., {"Name": "Alice", "Age": 30}), while “Array of Arrays” produces raw arrays preserving the original row structure (e.g., ["Alice", 30]).
4. Toggle “Header row” on or off. When enabled (default), the first row of the sheet is treated as column names. When disabled, columns are auto-named column1,column2, etc.
5. Toggle “Skip empty rows” to filter out rows where all cells are blank. This is useful for Excel files that have visual separators or formatting-only blank rows.
6. Select JSON indentation— 2 spaces (default), 4 spaces, or compact (no indentation). Compact mode produces the smallest output, which is ideal for API payloads. Indented modes are better for human readability.
7. Review the output in the preview editor. The JSON is syntax-highlighted for easy inspection. Stats below show row/column counts, sheet name, and file size.
8. Copy or download the result using the buttons below the editor. The downloaded file uses the original filename with a .json extension.

Supported File Formats

The converter supports four spreadsheet formats, covering virtually every Excel and spreadsheet file you might encounter:

• XLSX (Excel Workbook)— The modern default format used by Microsoft Excel 2007 and later. XLSX files are ZIP archives containing XML files. This is the most common format for sharing spreadsheet data. The converter fully supports all XLSX features including multiple sheets, formulas (converted to their computed values), date handling, and number formatting.
• XLS (Excel 97–2003 Workbook)— The legacy binary format used by older versions of Excel. Although Microsoft has moved to XLSX, many organizations still maintain XLS files in their archives. The converter reads these binary files directly, preserving all data without requiring Excel to be installed.
• XLSB (Excel Binary Workbook)— A binary format introduced by Excel 2007 that offers smaller file sizes and faster loading compared to XLSX. XLSB is popular for very large spreadsheets where performance matters. The converter handles XLSB files the same way as XLSX, producing identical JSON output.
• ODS (OpenDocument Spreadsheet)— The open standard format used by LibreOffice Calc, Google Docs (when exporting), and Apache OpenOffice. ODS files use XML-based storage and are fully supported by the converter. If you’re working with open-source office tools, this is your format.

Features

• Multi-format support— Accepts XLS, XLSX, XLSB, and ODS files. One converter for every spreadsheet format you’ll encounter.
• Sheet selection— Workbooks with multiple sheets are fully supported. After uploading, select any sheet from the dropdown to convert just the data you need.
• Two output formats— Choose between “Array of Objects” (named keys from headers) and “Array of Arrays” (raw row data) depending on your downstream requirements.
• Header row toggle— Control whether the first row should be treated as column names. When disabled, columns are auto-named for consistent programmatic access.
• Skip empty rows— Optionally filter out blank rows that would produce empty objects or arrays in the output, cleaning up your data automatically.
• JSON indentation options— Choose between 2 spaces (default), 4 spaces, or compact (minified) output. Compact mode is ideal for API payloads and production use, while indented modes are better for debugging and review.
• Type preservation— Numbers remain numbers, booleans stay booleans, and dates are converted to ISO 8601 strings. No more “30” when you meant 30.
• Drag-and-drop upload— Drop your file directly onto the page or use the file picker. No navigating through complex upload forms.
• 100% client-side (privacy-first)— Your file never leaves your browser. No upload, no server processing, no stored data. Safe for confidential financial records, PII, and proprietary business data.
• Copy and download— One-click copy to clipboard or download as a .json file. The output filename is based on your original file name.
• File size up to 20 MB— Handles large spreadsheets with thousands of rows without issues, limited only by browser memory.
• Dark mode support— Fully supports both light and dark themes, automatically following your system preference.