XLS and JSON explained
The pre-2007 Excel format is a binary structure limited to 65,536 rows and 256 columns — limits modern datasets routinely exceed.
JSON represents structured data as nested objects and arrays. It came from JavaScript but is now the default interchange format for essentially every web API.
- Where XLS files come from
- Spreadsheets from Excel 2003 or earlier, and some legacy export systems.
- Where JSON is used
- APIs, configuration files and application data exports.