Home / SheetAlchemy
SheetAlchemy
Google Sheets ORM for Python with Django-style queries
Overview
A Python library that provides an Object-Relational Mapping (ORM) interface for Google Sheets. Interact with Google Sheets data using Python objects and Django-like query syntax.
Features
- Model-based approach - Define Python classes for Google Sheets tabs
- Rich field types - String, Integer, Date, Boolean, Decimal, List, and Custom
- Django-style queries - Familiar filtering with field lookups (__lt, __gt, __ct, etc.)
- Data validation - Built-in type validation and error handling
- Load policies - Configure eager (INIT) or lazy (LAZY) data loading
- Data transformation - Automatic cleaning of common spreadsheet issues
- Authentication management - Seamless Google Sheets API authentication
Installation
Available on PyPI: pip install sheet-alchemy
Requirements
Python 3.8+
Status
Active development