schemasheets 0.1.11

Package to author schemas using spreadsheets

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

• installation
• basics

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