CSVSheets

CSVSheets is a software toolkit designed to treat plain CSV files as spreadsheet-like sheets that can be manipulated programmatically. It provides a consistent interface for reading, writing, and transforming tabular data stored in CSV format, with support for large datasets and streaming processing.

Key features include support for standard CSV dialects and custom delimiters, proper handling of quoted fields and multiline records, and robust character encoding support (UTF-8 and beyond). The API allows access by rows or by columns, optional header rows, and explicit or inferred schemas. Transformations such as filtering, mapping, and aggregation can be composed in a pipeline, and writes can preserve or normalize formatting.

CSVSheets employs a sheet abstraction that remains agnostic to the underlying storage. Data can be read in a streaming fashion to minimize memory usage, while random access by row and column is available when needed. It offers error reporting with precise line positions and supports transactional-style writes to avoid partial updates.

Compatibility and ecosystem: CSVSheets is designed to be available in multiple programming languages with bindings for common runtimes, and it integrates with data processing workflows, ETL pipelines, and testing environments. It is suitable for exporting data from databases, transforming CSV exports, or consuming CSV input from other tools.

History and licensing: The project is community-driven and released under an open license, with ongoing development and documentation. The goal is to provide a dependable, well-tested CSV handling layer that complements spreadsheet tools by offering a predictable, programmable interface.