Package to author schemas using spreadsheets
Project description
Schemasheets - make datamodels using spreadsheets
Create a [data dictionary]*https://linkml.io/schemasheets/howto/data-dictionaries/) / schema for your data using simple spreadsheets - no coding required.
About
Schemasheets is a framework for managing your schema using spreadsheets (Google Sheets, Excel). It works by compiling down to LinkML, which can itself be compiled to a variety of formalisms, or used for different purposes like data validation
Documentation
See the Schema Sheets Manual
Quick Start
pip install schemasheets
You should then be able to run the following commands:
- sheets2linkml - Convert schemasheets to a LinkML schema
- linkml2sheets - Convert a LinkML schema to schemasheets
- sheets2project - Generate an entire set of schema files (JSON-Schema, SHACL, SQL, ...) from Schemasheets
Companion tools
We recommend using COGS to synchronize your google sheets with local files using a git-like mechanism
Details
- Author your schema as a google sheet or excel spreadsheet
- Generate schemas:
- LinkML
- SHACL and ShEx
- JSON-Schema
- SQL DDL
- OWL
- Get tooling for free:
- Data validators
- Python bindings
- Create a website for your schema
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file schemasheets-0.1.11.tar.gz
.
File metadata
- Download URL: schemasheets-0.1.11.tar.gz
- Upload date:
- Size: 21.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.1 CPython/3.8.13
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2e033653b4d62c2d3d6988b250923e591e89f600a80b2484ab9acc05b52872cf |
|
MD5 | 63896c7280dcd1902d7354b03209f66d |
|
BLAKE2b-256 | db8b7d0aab73df83e90ff08754ef535c5204d43b9558a4a438c46501bd9f04d9 |
Provenance
File details
Details for the file schemasheets-0.1.11-py3-none-any.whl
.
File metadata
- Download URL: schemasheets-0.1.11-py3-none-any.whl
- Upload date:
- Size: 25.1 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.1 CPython/3.8.13
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4722fd7eead02fa8ee045ef855793a61e33d7e959d86139c0f301ba8a02f46ee |
|
MD5 | 0ec2387c632b77f6afb9f11014428830 |
|
BLAKE2b-256 | 9e10406cc67cb4278f68d476bba6235c33bcf5abb9b8de87e4aa9cf25e3a7e41 |