Skip to main content

Given a Frictionless Table Schema, generates an Excel template with input validation

Project description


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


Download a sample schema.yaml, and then:

pip install tableschema-to-template 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.


  • 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:

For the biomedical ontologies community:

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

Project details

Download files

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

Files for tableschema-to-template, version 0.0.9
Filename, size File type Python version Upload date Hashes
Filename, size tableschema_to_template-0.0.9-py3-none-any.whl (13.2 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size tableschema-to-template-0.0.9.tar.gz (10.7 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page