# Send Sheetsmith to your agent
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
## Fast path
- Download the package from Yavira.
- Extract it into a folder your agent can access.
- Paste one of the prompts below and point your agent at the extracted folder.
## Suggested prompts
### New install

```text
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Then review README.md for any prerequisites, environment setup, or post-install checks. Tell me what you changed and call out any manual steps you could not complete.
```
### Upgrade existing

```text
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Then review README.md for any prerequisites, environment setup, or post-install checks. Summarize what changed and any follow-up checks I should run.
```
## Machine-readable fields
```json
{
  "schemaVersion": "1.0",
  "item": {
    "slug": "sheetsmith",
    "name": "Sheetsmith",
    "source": "tencent",
    "type": "skill",
    "category": "效率提升",
    "sourceUrl": "https://clawhub.ai/CrimsonDevil333333/sheetsmith",
    "canonicalUrl": "https://clawhub.ai/CrimsonDevil333333/sheetsmith",
    "targetPlatform": "OpenClaw"
  },
  "install": {
    "downloadUrl": "/downloads/sheetsmith",
    "sourceDownloadUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=sheetsmith",
    "sourcePlatform": "tencent",
    "targetPlatform": "OpenClaw",
    "packageFormat": "ZIP package",
    "primaryDoc": "SKILL.md",
    "includedAssets": [
      "README.md",
      "SKILL.md",
      "references/usage.md",
      "scripts/sheetsmith.py",
      "tests/data/test.csv",
      "tests/test_sheetsmith.py"
    ],
    "downloadMode": "redirect",
    "sourceHealth": {
      "source": "tencent",
      "slug": "sheetsmith",
      "status": "healthy",
      "reason": "direct_download_ok",
      "recommendedAction": "download",
      "checkedAt": "2026-05-01T05:34:10.068Z",
      "expiresAt": "2026-05-08T05:34:10.068Z",
      "httpStatus": 200,
      "finalUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=sheetsmith",
      "contentType": "application/zip",
      "probeMethod": "head",
      "details": {
        "probeUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=sheetsmith",
        "contentDisposition": "attachment; filename=\"sheetsmith-1.0.1.zip\"",
        "redirectLocation": null,
        "bodySnippet": null,
        "slug": "sheetsmith"
      },
      "scope": "item",
      "summary": "Item download looks usable.",
      "detail": "Yavira can redirect you to the upstream package for this item.",
      "primaryActionLabel": "Download for OpenClaw",
      "primaryActionHref": "/downloads/sheetsmith"
    },
    "validation": {
      "installChecklist": [
        "Use the Yavira download entry.",
        "Review SKILL.md after the package is downloaded.",
        "Confirm the extracted package contains the expected setup assets."
      ],
      "postInstallChecks": [
        "Confirm the extracted package includes the expected docs or setup files.",
        "Validate the skill or prompts are available in your target agent workspace.",
        "Capture any manual follow-up steps the agent could not complete."
      ]
    }
  },
  "links": {
    "detailUrl": "https://openagent3.xyz/skills/sheetsmith",
    "downloadUrl": "https://openagent3.xyz/downloads/sheetsmith",
    "agentUrl": "https://openagent3.xyz/skills/sheetsmith/agent",
    "manifestUrl": "https://openagent3.xyz/skills/sheetsmith/agent.json",
    "briefUrl": "https://openagent3.xyz/skills/sheetsmith/agent.md"
  }
}
```
## Documentation

### Overview

Sheetsmith is a lightweight pandas wrapper that keeps the focus on working with CSV/Excel files: previewing, describing, filtering, transforming, and converting them in one place. The CLI lives at skills/sheetsmith/scripts/sheetsmith.py, and it automatically loads any CSV/TSV/Excel file, reports structural metadata, runs pandas expressions, and writes the results back safely.

### Quick start

Place the spreadsheet (CSV, TSV, or XLS/XLSX) inside the workspace or reference it via a full path.
Run python3 skills/sheetsmith/scripts/sheetsmith.py <command> <path> with the command described below.
When you modify data, either provide --output new-file to save a copy or pass --inplace to overwrite the source file.
Check references/usage.md for extra sample commands and tips.

### summary

Prints row/column counts, dtype breakdowns, columns with missing data, and head/tail previews. Use --rows to control how many rows are shown after the summary and --tail to preview the tail instead of the head.

### describe

Runs pandas.DataFrame.describe(include='all') (customizable with --include) so you instantly see numeric statistics, cardinality, and frequency information. Supply --percentiles to add additional percentile lines.

### preview

Shows a quick tabulated peek at the first (--rows) or last (--tail) rows so you can sanity-check column order or formatting before taking actions.

### filter

Enter a pandas query string via --query (e.g., state == 'CA' and population > 1e6). The command can either print the filtered rows or, when you also pass --output, write the filtered table to a new CSV/TSV/XLSX file. Add --sample to inspect a random subset instead of the entire result.

### transform

Compose new columns, rename or drop existing ones, and immediately inspect the resulting table. Provide one or more --expr expressions such as total = quantity * price. Use --rename old:new and --drop column to reshape the table, and persist changes via --output or --inplace. The preview version (without writing) reuses the same --rows/--tail flags as the other commands.

### convert

Convert between supported formats (CSV/TSV/Excel). Always specify --output with the desired extension, and the helper will detect the proper writer (Excel uses openpyxl, CSV preserves the comma separator by default, TSV uses tabs). This is the simplest way to normalize data before running other commands.

### Workflow rules

Always keep a copy of the raw file or write to a new path; the script will only overwrite the original when you explicitly demand --inplace.
Use the same CLI for both exploration (summary, preview, describe) and editing (filter, transform). The --output flag works for filter/transform so you can easily branch results.
Behind the scenes, the script relies on pandas + tabulate for Markdown previews and supports Excel/CSV/TSV, so ensure those dependencies are present (pandas, openpyxl, xlrd, tabulate are installed via apt on this system).
Use references/usage.md for extended examples (multi-step cleaning, dataset comparison, expression tips) when the basic command descriptions above are not enough.

### References

Usage guidelines: references/usage.md (contains ready-to-copy commands, expression patterns, and dataset cleanup recipes).

### Resources

GitHub: https://github.com/CrimsonDevil333333/sheetsmith
ClawHub: https://www.clawhub.ai/skills/sheetsmith
## Trust
- Source: tencent
- Verification: Indexed source record
- Publisher: CrimsonDevil333333
- Version: 1.0.1
## Source health
- Status: healthy
- Item download looks usable.
- Yavira can redirect you to the upstream package for this item.
- Health scope: item
- Reason: direct_download_ok
- Checked at: 2026-05-01T05:34:10.068Z
- Expires at: 2026-05-08T05:34:10.068Z
- Recommended action: Download for OpenClaw
## Links
- [Detail page](https://openagent3.xyz/skills/sheetsmith)
- [Send to Agent page](https://openagent3.xyz/skills/sheetsmith/agent)
- [JSON manifest](https://openagent3.xyz/skills/sheetsmith/agent.json)
- [Markdown brief](https://openagent3.xyz/skills/sheetsmith/agent.md)
- [Download page](https://openagent3.xyz/downloads/sheetsmith)