---
id: tableschema-to-template
version: "0.0.13"
license: unclear
license_treatment: permissive
maintenance: abandoned
---

# tableschema-to-template — Given a Frictionless Table Schema, generates an Excel template with input validation

License: permissive · Maintenance: abandoned · Downloads: 292.1K/mo

## 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 above — 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

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

- License: not declared (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: abandoned
- Downloads: 292.1K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

excel template generation from schema, table schema to excel, frictionless data validation template, excel input validation generator, schema-driven spreadsheet, data entry template builder, xlsx with constraints, data-validation, excel-generation, frictionless-data

[View on SkillFed](https://skillfed.io/packages/tableschema-to-template) · [View on PyPI](https://pypi.org/project/tableschema-to-template/)