Skip to main content

Package to author schemas using spreadsheets

Project description

Schemasheets - make datamodels using spreadsheets

Tests PyPI PyPI - Python Version PyPI - License Code style: black

linkml logo google sheets logo

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

  1. Author your schema as a google sheet or excel spreadsheet
  2. Generate schemas:
    • LinkML
    • SHACL and ShEx
    • JSON-Schema
    • SQL DDL
    • OWL
  3. Get tooling for free:
    • Data validators
    • Python bindings
    • Create a website for your schema

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

schemasheets-0.1.11.tar.gz (21.3 kB view details)

Uploaded Source

Built Distribution

schemasheets-0.1.11-py3-none-any.whl (25.1 kB view details)

Uploaded Python 3

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

Hashes for schemasheets-0.1.11.tar.gz
Algorithm Hash digest
SHA256 2e033653b4d62c2d3d6988b250923e591e89f600a80b2484ab9acc05b52872cf
MD5 63896c7280dcd1902d7354b03209f66d
BLAKE2b-256 db8b7d0aab73df83e90ff08754ef535c5204d43b9558a4a438c46501bd9f04d9

See more details on using hashes here.

Provenance

File details

Details for the file schemasheets-0.1.11-py3-none-any.whl.

File metadata

File hashes

Hashes for schemasheets-0.1.11-py3-none-any.whl
Algorithm Hash digest
SHA256 4722fd7eead02fa8ee045ef855793a61e33d7e959d86139c0f301ba8a02f46ee
MD5 0ec2387c632b77f6afb9f11014428830
BLAKE2b-256 9e10406cc67cb4278f68d476bba6235c33bcf5abb9b8de87e4aa9cf25e3a7e41

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page