A lightweight pandas-based CLI tool for rapid spreadsheet previewing, filtering, and format conversion.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install sheetsmith
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 sheetsmith 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 Sheetsmith?
Sheetsmith acts as a specialized pandas wrapper designed to simplify the management of CSV, TSV, and Excel files. As a featured utility among Openclaw Skills, it allows users to perform structural metadata analysis and complex data manipulations without manually writing Python scripts. It provides a robust interface for data practitioners who need to quickly summarize, describe, or transform datasets while maintaining high standards for data integrity and technical efficiency.
Sheetsmith Use Cases
- Inspecting file structures and identifying missing data in large datasets.
- Filtering rows based on logical conditions using pandas-style query strings.
- Transforming data columns by applying mathematical or string expressions.
- Converting legacy Excel files into modern CSV or TSV formats for automation pipelines.
How Sheetsmith Works
- The user specifies a target spreadsheet file and a specific command like summary, describe, or transform.
- Sheetsmith utilizes pandas to load the data into memory and tabulate for terminal-friendly Markdown previews.
- Logical operations, such as filtering or column renaming, are applied directly to the internal DataFrame.
- Users can preview changes in real-time or persist them to disk using the output or inplace flags.
Sheetsmith Setup
Ensure that Python 3 and the necessary libraries (pandas, openpyxl, xlrd, tabulate) are installed in your environment. This tool is designed to work seamlessly with other Openclaw Skills.
# Run a summary of a CSV file
python3 skills/sheetsmith/scripts/sheetsmith.py summary data.csv
# Filter data and save to a new file
python3 skills/sheetsmith/scripts/sheetsmith.py filter data.csv --query "age > 30" --output filtered.csv
Sheetsmith Data Schema & Taxonomy
Sheetsmith organizes data through a CLI-to-DataFrame mapping, supporting various tabular structures. Below is how the tool handles metadata and outputs:
| Attribute | Description |
|---|---|
| Input Support | CSV, TSV, XLS, XLSX formats |
| Data Preview | Tabulated Markdown head and tail views |
| Summary Stats | Counts, dtypes, null values, and pandas describe() output |
| Export Options | Preserves separators and handles engine-specific writing for Excel |
Sheetsmith Advanced Features
- Support for complex pandas expressions for dynamic column generation and data cleaning.
- Random subset sampling capability when filtering large datasets to allow for quick sanity checks.
- Built-in conversion logic to normalize datasets across different file formats.
- Seamless integration into automated data processing pipelines utilizing Openclaw Skills.
- In-place file modification for rapid iterative data cleaning tasks without creating redundant files.
SKILL.md
Loading
Related Openclaw Skills
Policy Lawyer
An automated CLI utility for referencing, searching, and extracting authoritative rules from workspace policy playbooks.
Ops Dashboard
A specialized operational monitoring tool for gathering disk usage, Git status, and system resource signals in one snapshot.
DevLog Skill
A professional developer journaling tool for AI agents to track project milestones, task statuses, and historical context.
DevLog Skill
A standardized journaling system for AI agents to track project progress, milestones, and task statuses using a structured SQLite database.
Dupe Similar Product Finder
A powerful product discovery tool that finds similar items and price comparisons using product URLs or direct image links.
EuroBot Song Contest
A daily music competition for AI agents to create MIDI songs, vote on entries, and climb the rankings using Openclaw Skills.
METADATA
Featured*
