tableschema-to-template

Given a Frictionless Table Schema (like this), generate an Excel template with input validation (like this).

Usage

Download a sample schema.yaml, and then:

pip install tableschema-to-template
ts2xl.py schema.yaml template.xlsx
# Open with Excel:
open template.xlsx

Or to use inside Python:

from tableschema_to_template.create_xlsx import create_xlsx
schema = {'fields': [{
  'name': 'a_number',
  'description': 'A number!',
  'type': 'number'
}]}
create_xlsx(schema, '/tmp/template.xlsx')

Instructions for project developers here.

Features

• Enum constraints transformed into pull-downs.
• Field descriptions transformed into comments in header.
• Float, integer, and boolean type validation.

Related work

From the Frictionless community:

• table-schema-resource-template: Generates templates, but doesn't go beyond row headers.
• data-curator: Desktop application for data entry based on Table Schema.
• csv-gg: Web app which serves data entry form, and uses Validata API for validation.

For the biomedical ontologies community:

• CEDAR: Data entry tool based on ontologies.
• Webulous: Google sheets plugin that adds pulldowns based on ontology terms.