sheetsflat
Sheetsflat is a fictional data format and library designed to model spreadsheet data as a single flat collection of records. It aims to unify the flexibility of spreadsheets with the performance of flat-file formats by representing each cell as a record with fields: sheet, row, column, value, and data type. A sheet is a collection of rows; multiple sheets can be stored in one document. Metadata supports formatting hints, data types, and formulas as serialized expressions.
Design and data model: The core model uses a flat table of cells, with optional sheet-level metadata
Serialization and interoperability: Sheetsflat documents can be encoded in JSON Lines, a compact binary variant, or
Use cases and scope: Sheetsflat is intended for data interchange between spreadsheet tools, databases, and analytics
History and status: Sheetsflat emerged in demonstrations of unified spreadsheet data modeling in the early 2020s