An intelligent agent skill that analyzes uploaded templates to generate context-aware, import-ready sample data.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install generate-import-template-data
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install generate-import-template-data using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Generate Import Template Data?
This skill enables AI agents to process uploaded .xlsx, .csv, or .tsv templates and populate them with realistic business data. By integrating with Openclaw Skills, developers can quickly generate test datasets, initialization values, or edge-case scenarios that match the exact structure, headers, and sheet names of a target import file. It ensures data integrity by respecting existing formats, enumeration values, and business logic described by the user.
Using Openclaw Skills for data generation significantly reduces the manual effort required to prepare spreadsheets for system testing. The skill intelligently distinguishes between actual data sheets and instruction sheets, ensuring that the final output is ready for immediate import into enterprise applications.
Generate Import Template Data Use Cases
- Creating realistic test data for software system imports during development.
- Generating large datasets for load testing based on a specific Excel structure.
- Preparing sample data for client demonstrations using their own business templates.
- Fabricating edge-case data to validate system error handling and boundary conditions.
- Filling empty import templates with initialization data for new platform migrations.
How Generate Import Template Data Works
- The agent inspects the uploaded template file (Excel or CSV) using a specialized inspection script to identify headers and sheet structure.
- It identifies the correct import sheet by filtering out instruction or metadata sheets.
- The agent processes the user's business scenario to determine the quantity and nature of the data needed.
- It maps the business requirements to the specific columns found in the template.
- The Openclaw Skills logic generates the rows while strictly maintaining column order and formatting requirements.
- A final validation step ensures the generated data aligns with the original template constraints before outputting the result.
Generate Import Template Data Setup
To utilize this functionality within the Openclaw Skills framework, ensure the inspection scripts are accessible in your workspace.
# Inspect a template to identify headers and sheets
python scripts/inspect_template.py --input <template-file>
# Optional: Inspect a specific sheet with JSON output
python scripts/inspect_template.py --input data.xlsx --sheet "Sheet1" --json
Generate Import Template Data Data Schema & Taxonomy
The skill organizes data by strictly adhering to the input template's schema to ensure successful imports.
| Component | Description |
|---|---|
| Headers | Exact match of the original template column names including order. |
| Sheets | Preserves target sheet names for multi-sheet Excel workbooks. |
| Formats | Respects date, code, and identifier length constraints found in the template. |
| Values | Prioritizes realistic business data over generic placeholders. |
| Output | Delivers data via Markdown tables, CSV blocks, or new workspace files. |
Generate Import Template Data Advanced Features
- Support for multi-sheet Excel workbooks with intelligent sheet selection logic.
- Automated boundary and edge-case generation for robust QA testing scenarios.
- Context-aware data generation that mimics real-world business entities based on user prompts.
- Integration with internal generation guidelines to ensure strict compliance with field-level constraints.
- Flexible output options including in-place template filling or separate file generation.
SKILL.md
Loading
Related Openclaw Skills
American Airlines Information Specialist
An AI agent skill designed to retrieve and analyze comprehensive corporate data, market standing, and historical context for American Airlines.
DealWatch Read-only Builder
A secure, read-only integration skill for AI agents to interact with DealWatch grocery data using the Model Context Protocol.
Gen-Z Design Agent
A high-leverage design agent focused on surrealist, minimalist, and atmospheric aesthetics tailored for Gen-Z audiences.
Current View Triage
A read-only triage tool that transforms complex workspace snapshots into a single, evidence-based next action for students.
United Information Portal
A comprehensive information hub for United-related data, providing deep insights into historical milestones, business scope, and global operations.
Pre-Install Scanner
A pre-deployment security auditor that scans Openclaw Skills for high-risk patterns before they are written to your local disk.
Featured*
