Convert XLS to JSON

Add your XLS data and automatically convert it to JSON.

XLS input options
JSON output options

XLS

XLS files are Excel files that use the Binary Interchange File Format (BIFF), which was the default format for Excel versions 97-2003.

XLS files can contain multiple sheets, and each sheet can contain multiple rows and columns of data. They support various data types, including text, numbers, dates, and formulas.

Key features of XLS files include:

  • Compatibility with older versions of Excel and other spreadsheet software
  • Ability to store formatting information, charts, and macros
  • Smaller file size compared to newer formats like XLSX
  • Limited to 65,536 rows and 256 columns per sheet

While XLS files are still widely used, they are gradually being replaced by the more modern XLSX format.

JSON

JSON (JavaScript Object Notation) is a lightweight data interchange format that is easy for humans to read and write and easy for machines to parse and generate.

JSON has become the de facto standard for data exchange on the web, and it is widely used in APIs.

Character encoding

As stated by the RFC 8259, we expect strings in uploaded JSON files to be encoded in UTF-8.

If your file contains non UTF-8 characters, you might get an error when parsing your data.

Convert XLS