Convert Excel97 to ORC Online
Use our free online tool to convert your Excel 97-2003 (.xls) data to Apache ORC quickly
Excel 97-2003 (.xls)
Excel 97-2003 file refers to the file format used by Microsoft Excel versions from 1997 to 2003, typically having the .xls extension. This format is a binary file format known as BIFF (Binary Interchange File Format) and was the standard for Excel spreadsheets before the introduction of the newer format in Excel 2007. This version of Excel support 65,536 rows and 256 columns per sheet, as well as various formatting options, formulas, charts, pivot tables, and conditional formatting. This older format included password protection and encryption which has since been improved in the newer version. The Excel 97-2003 .xls remains in uses in environments where legacy systems are in operation or where compatibility with older versions of Excel is necessary.
Apache ORC
Apache ORC (Optimized Row Columnar) is a self-describing, columnar file format that supports high compression ratios and fast data retrieval. ORC supports complex types, including structs, lists, maps, and unions. ORC files are divided into blocks of data (stripes) containing statistics (such as min, max, sum, and count) and lightweight indexing which can be used to skip over irrelevant data during queries. ORC also supports predicate pushdown, meaning that filters can be applied as the data is read from disk, reducing the amount of data loaded into memory and processed. Due to its high performance in terms of compression and speed of access, ORC is particularly well-suited for heavy read operations and is commonly used in data warehousing and analytics applications.