tableschema-to-template
Given a Frictionless Table Schema, generates an Excel template with input validation
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
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 · maintenance · safety
permissive license (permissive) — Licensed under MIT (permissive), so you may use, modify, and distribute this package freely in commercial and private projects with minimal restrictions.
last release 2023-02-01 (1290 days) · last repo commit 2023-02-01 · 12 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 292,146 downloads/mo, #7,967 on PyPI
Alternatives
Verify before relying
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')- 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.
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 on it.
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
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 | permissive license permissive |
| Python support | Supports the current Python release >=3.6 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 3 packagesjsonschemapyyamlxlsxwriter |
| Maintenance | Abandoned 1,290 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 292,146 / month, #7,967 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | License :: OSI Approved :: MIT LicenseOperating System :: OS IndependentProgramming Language :: Python :: 3 |
Evidence: tableschema_to_template-0.0.13-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “excel template generation from schema”
- tableschema-to-templateConverts a Frictionless Table Schema into an Excel template with…
- mkdocs-table-reader-pluginA MkDocs plugin that inserts tables from external files (CSV, JSON,…
- robotframework-datadriverDataDriver extends Robot Framework to generate multiple test cases…
Give your agent the search over MCP, or paste the wish link into any chat.
More Utilities packages
Converts domain names between Unicode and ASCII-compatible encoding (Punycode) according to IDNA 2008 and Unicode Technical Standard 46, with security validation and broader script coverage than the standard library.
Install it if you work with internationalized domain names, need to validate domains, or use HTTP clients that depend on it transitively.
Detects and normalizes text encoding from unknown or ambiguous sources, supporting all IANA character sets that Python's core library provides codecs for, with the ability to register custom codecs.
Setuptools is a Python build backend and package management tool that handles building, distributing, and installing Python packages, including support for C/C++ extension modules.
Pluggy provides a plugin system that lets you define hook specifications and register implementations to be called in sequence, enabling extensible Python applications without tight coupling.
Install it if you're building an extensible application or framework.
Pygments is a syntax highlighter that colorizes source code and text in over 500 languages and formats, outputting to HTML, LaTeX, RTF, SVG, images, or ANSI terminal sequences.
Install it if you need to display or transform source code.
Six provides utility functions to write Python code that runs on both Python 2.7 and Python 3.3+, smoothing over language differences between the two versions.
See also frictionless · tableschema · xlsx2html · drf-excel · aspose-cells-python · agate-excel · tabulator · xlsxwriter · xls2xlsx · mkdocs-table-reader-plugin