Excel to JSON Converter
Excel spreadsheets organize data in rows and columns with formatting, formulas, and charts — but web applications, APIs, and modern data pipelines communicate in JSON (JavaScript Object Notation). Converting Excel to JSON transforms your tabular spreadsheet data into a structured, hierarchical format that developers can directly consume in web apps, databases, and automation workflows. SublimePDF intelligently maps your spreadsheet structure: column headers become JSON keys, rows become objects, and multiple sheets become separate arrays or nested structures.
Convert Excel to JSON instantly in your browser — no file uploads, no registration, and completely free.
Drop your Excel files here
or click to browse — up to 50MB
How to Convert Excel to JSON Online
Upload your Excel file
Drag and drop your .xls or .xlsx file. Workbooks with multiple sheets, merged cells, and various data types (text, numbers, dates, booleans) are all handled.
Configure JSON mapping
Choose how to structure the output: use the first row as object keys (recommended), or output raw arrays. Select which sheets to include, how to handle empty cells (null, empty string, or omit), and date formatting (ISO 8601 or Unix timestamp).
Preview the JSON output
Review the generated JSON structure to verify that column mappings, data types, and nesting are correct before downloading. Formulas are resolved to their calculated values.
Download your JSON file
The formatted .json file is ready for import into web applications, databases, or API endpoints. Output uses clean, properly indented JSON with correct data typing.
Excel to JSON Converter Features
When to Convert Excel to JSON
- Extract spreadsheet data as JSON for consumption by web application APIs and frontend frameworks
- Convert product catalogs from Excel to JSON for import into e-commerce platforms like Shopify or WooCommerce
- Transform Excel survey results into JSON for visualization with D3.js, Chart.js, or other JavaScript charting libraries
- Convert Excel configuration tables to JSON for use in application settings and environment files
- Migrate Excel-based datasets to JSON for loading into MongoDB, Firebase, or other NoSQL databases
About Excel and JSON
What is Excel?
Microsoft Excel Spreadsheet (.xls, .xlsx) — The standard spreadsheet format for organizing, analyzing, and visualizing data. Learn more about Excel →
What is JSON?
JavaScript Object Notation (.json) — A lightweight data format commonly used in web APIs and configuration files. Learn more about JSON →
Privacy & Security
Your files never leave your device. All conversion happens locally in your browser using WebAssembly technology.
Excel to JSON Conversion FAQ
Will my Excel formulas be converted to calculated values in JSON?
How are Excel dates represented in JSON?
What happens to merged cells?
Can I convert a specific sheet from a multi-sheet workbook?
What's the maximum number of rows supported?
Related Guides
How to Convert Scanned PDF to Text
Scanned PDFs are essentially images — you can't select or search the text. OCR (Optical Character Recognition) technology converts these image-based PDFs into searchable, editable text. SublimePDF's OCR tool handles this conversion right in your browser.
How to Convert JPG to PDF
Converting JPG images to PDF is useful for creating photo albums, digitizing receipts, compiling screenshots, or sharing images in a universally readable format.
How to Convert PDF To Grayscale
Printing color PDFs on black-and-white printers often produces muddy, hard-to-read output because the printer's automatic color conversion isn't optimized for clarity. Pre-converting your PDF to grayscale ensures consistent, clean results on any mono printer and can dramatically reduce printing costs for large jobs. SublimePDF converts all colors—in text, images, and vector graphics—to properly weighted grayscale.