tableschema-to-template

What it is and what it does

tableschema-to-template bridges Frictionless Table Schema definitions and Excel spreadsheets. You provide a schema (YAML or JSON) describing fields, types, constraints, and descriptions, and the package generates a ready-to-use Excel file with input validation rules baked in. Enum fields become dropdown lists, numeric fields get range validation, and field descriptions appear as comments in the header row.

The package is built on jsonschema for validation logic, pyyaml for schema parsing, and xlsxwriter for Excel generation. It offers both a command-line tool (ts2xl.py) and a Python API (create_xlsx function). Because the project is abandoned with no commits since 2023-02-01, it will not receive updates for new Excel features, schema spec changes, or bug fixes.

Use it for:

• Generate standardized data-entry templates for biomedical or research projects that define schemas in Frictionless format.
• Automate creation of Excel files with validation rules so non-technical users can enter data without manual constraint setup.
• Convert machine-readable table schemas into human-friendly spreadsheet templates with built-in guidance via field descriptions.
• Build data pipelines where schema-driven templates enforce consistency before data reaches downstream processing.
• Create audit-ready templates with predefined valid values (enums) and type constraints for regulated data collection.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Converts a Frictionless Table Schema into an Excel template with built-in input validation, dropdown constraints, and field descriptions.

Yes, if you need to generate Excel templates from Frictionless schemas and can tolerate no future maintenance. The package is stable, has low install friction, no known vulnerabilities, and a permissive license. However, do not rely on it for production systems requiring active support or compatibility with future Excel or schema spec changes. Consider it a one-time tool rather than a long-term dependency.

Install

tableschema-to-template on PyPI

pip install tableschema-to-template

uv add tableschema-to-template

poetry add tableschema-to-template

Installing tableschema-to-template

Before you install

Low install friction with three lightweight runtime dependencies (jsonschema, pyyaml, xlsxwriter). However, the package is abandoned—last commit was 2023-02-01 with no releases since—so expect no maintenance or bug fixes.

License in practice

Licensed under MIT (permissive), so you may use, modify, and distribute this package freely in commercial and private projects with minimal restrictions.

Quickstart

pip install tableschema-to-template

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

Verify before relying

• Whether enum constraints are reliably transformed into Excel dropdown lists across all schema variations.
• Whether float, integer, and boolean type validation works correctly with modern Excel versions.
• Whether range checks on numbers are enforced consistently in generated templates.

Package facts

Evidence: tableschema_to_template-0.0.13-py3-none-any.whl

Tags

More Utilities packages