Convert Excel XML (SpreadsheetML) to JSON
Overview
Excel can save workbooks as XML (SpreadsheetML format with .xml extension). This XML can be converted to JSON for use in applications. The converter extracts worksheet row data into a JSON array of objects, using the first row as field names.
How to Use This Tool
Export your Excel file as XML Spreadsheet 2003 (.xml). Paste the XML content. Click Convert to JSON. The converter extracts the worksheet data. Download the JSON array.
Ready to get started? It's free, no registration required, and your files never leave your device.
PDF Tool →Frequently Asked Questions
How do I export Excel as XML?
In Excel, go to File > Save As and choose 'XML Spreadsheet 2003 (*.xml)' from the format dropdown. This creates a SpreadsheetML file. The .xlsx format is a ZIP archive, not plain XML, and cannot be pasted directly.
Can I convert .xlsx directly to JSON?
Not with this XML converter since .xlsx is a ZIP archive internally. For .xlsx to JSON, use a dedicated Excel-to-JSON tool or open the .xlsx in Excel, save as XML Spreadsheet 2003, and then convert the XML.
What does SpreadsheetML data look like in JSON?
The converter extracts Worksheet Row elements. Each Row becomes a JSON object with Cell values. If the first row contains headers (field names), those become the JSON keys for all subsequent rows.