Excel to JSON Converter.

Upload your .xlsx or .xls file using the file upload area above, then click Convert. The tool reads all sheets in the workbook and converts each one to a JSON array. If the workbook has only one sheet, you get a single JSON array; multiple sheets are returned as an object with sheet names as keys. Download the .json file or copy the output.

Drag and drop your Excel file onto the upload area, or click to browse. The converter processes .xlsx and .xls formats, extracting all cell data. Column headers from the first row become JSON keys, and each subsequent row becomes a JSON object. All processing is client-side — your spreadsheet data never leaves your device.

Excel's Power Query can parse JSON files. Go to Data → Get Data → From File → From JSON. The Query Editor lets you expand nested JSON objects into columns. For JSON within a cell, use the Json.Document() function in Power Query, or for simple cases, use FILTERXML or TEXTSPLIT formulas. For quick conversion outside Excel, use the JSON to Excel converter on this site.

In Excel: Data → Get Data → From File → From JSON. Navigate to your .json file and import it. Power Query opens showing the JSON structure — expand nested records and lists to flatten them into a table, then click Close & Load. For a zero-step alternative, convert JSON to Excel on jsontofile.com and open the .xlsx directly.

Excel 2016 and later support JSON import through Power Query: Data → Get Data → From File → From JSON. Earlier versions require a third-party add-in or online converter. jsontofile.com works with any Excel version — just convert your JSON to .xlsx and open it in any version of Excel, Google Sheets, or LibreOffice.

Paste your JSON array into the converter above. The tool automatically detects field names and creates column headers. Nested objects are flattened with dot-notation keys (e.g., address.city becomes a column). Click Convert and download the .xlsx file — open it in Excel and you have a proper table with filters enabled on each column.

In C#, use Microsoft.Office.Interop.Excel or EPPlus (NuGet package) to read Excel files:
using (var package = new ExcelPackage(new FileInfo("data.xlsx"))) {
  var ws = package.Workbook.Worksheets[0];
  var list = new List<Dictionary<string,object>>();
  // iterate rows and columns...
  var json = JsonSerializer.Serialize(list);
}
For a quick online alternative, use jsontofile.com without writing any code.

Set up a recurring import in Excel Power Query: Data → Get Data → From Other Sources → From Web (for API endpoints), enter the JSON URL, and configure refresh settings (Query Properties → Refresh every N minutes). For local files, use Power Query's From Folder to watch a directory for new JSON files and auto-import them into your workbook.