Convert XLS to SQLite

Add your XLS data and automatically convert it to SQLite.

XLS input options
SQLite 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.

SQLite

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.

It's the most used database engine in the world, embedded in many applications. SQLite is serverless and requires zero configuration, making it ideal for local/client storage in application software.

Convert XLS

XLS to CSVXLS to ExcelXLS to JSONXLS to NDJSONXLS to JSONLinesXLS to TSVXLS to HTML TableXLS to XMLXLS to ParquetXLS to ArrowXLS to AvroXLS to Avro schemaXLS to SQLXLS to SQLiteXLS to MySQLXLS to PostgreSQLXLS to Markdown TableXLS to PDFXLS to TXTXLS to LaTeX Table