Convert XLS to Avro schema

Add your XLS data and automatically convert it to Avro schema.

XLS input options
Avro schema output options
This format does not have any 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.

Avro schema

An Avro schema is a JSON document that defines the structure of Avro data.

It specifies the fields, their names, and data types for Avro data, enabling schema evolution and ensuring data consistency.

Convert XLS