Built-in support for Excel files enhances data ingestion capabilities.
Databricks now supports reading `.xls`, `.xlsx`, and `.xlsm` files natively, allowing users to ingest, parse, and query Excel files without needing external libraries or manual conversions. Users can read any sheet from multi-sheet workbooks, target specific cell ranges, and automatically infer schema and data types. This feature supports both batch and streaming workloads using Auto Loader, facilitating seamless data integration from Excel files.
This enhancement significantly improves productivity by streamlining the data ingestion process for users who rely on Excel files, reducing the time and effort spent on data preparation. It allows data teams to leverage existing Excel data directly in their analytics workflows, enhancing decision-making capabilities and enabling faster insights. The built-in support also mitigates risks associated with manual conversions and external dependencies.