Search papers, labs, and topics across Lattice.
This paper tackles the challenges of automated structured content extraction from spreadsheets by introducing a two-stage pipeline that combines Cell-Type Classification (CTC) and Table Detection (TD). The CTC employs a LightGBM classifier with a pairwise CRF to ensure spatial consistency, while the TD method utilizes a deterministic five-stage procedure to extract table ranges based on predicted cell types. The proposed approach achieves a high Mean File-Macro F1 score of 0.937 on CTC with significantly lower computational costs compared to existing methods, showcasing its efficiency and scalability in spreadsheet understanding.
Achieving near-state-of-the-art performance in spreadsheet table understanding with a fraction of the computational resources typically required.
Spreadsheets are a primary medium for publishing tabular data, yet automatically extracting structured content from them remains difficult due to heterogeneous layouts, diverse file formats, and inconsistent organizational conventions. We address two core tasks in spreadsheet understanding: Cell-Type Classification (CTC), which assigns roles to cells, and Table Detection (TD), which identifies table bounding boxes within sheets. We propose an efficient two-stage pipeline in which a learned CTC model feeds a deterministic TD algorithm. For CTC, we use a LightGBM classifier over 65 structured features together with a pairwise CRF enforcing spatial consistency across the cell grid. Our TD method extracts table ranges from predicted cell types by a deterministic five-stage procedure. For evaluation, we built and share StatSheets, a multilingual benchmark of 737 manually annotated sheets from 14 public data providers across multiple countries and file formats. Under 5-fold cross-validation, our CRF-LightGBM system achieves a Mean File-Macro F1 score of 0.937 on CTC, within 0.6 percentage points of the GPU-based TUTA Transformer, while requiring substantially fewer computational resources. For TD, our deterministic approach outperforms region-based baselines and remains competitive with recent LLM-based systems such as SpreadsheetLLM. These results demonstrate that combining non-linear structured prediction with deterministic range extraction provides a competitive, scalable, and computationally efficient approach to spreadsheet table understanding.