← Back to Skills Marketplace
49
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install csv-tool-pro
Description
Perform comprehensive CSV file operations including viewing, filtering, sorting, merging, splitting, deduplication, conversion (JSON/YAML/TSV/Markdown/HTML),...
README (SKILL.md)
📊 CSV Tool Pro
Author: Lin Hui | GitHub | MIT License | v1.0.0
One command to rule all your CSV files. View, filter, sort, merge, split, dedupe, convert, and analyze — all without leaving your terminal or opening Excel.
✨ Features
Core Operations
- View — Pretty-print CSV with alignment and truncation
- Filter — Row filtering by column value, regex, or numeric range
- Sort — Single or multi-column sort (asc/desc)
- Dedupe — Remove duplicate rows by key columns
Multi-File Operations
- Merge — Combine multiple CSVs (union by headers)
- Join — Inner/left/right/full join on key columns
- Split — Split large CSV into smaller files by row count or column value
Format Conversion
- to JSON — Array of objects or nested format
- to YAML — Clean YAML output
- to TSV — Tab-separated output
- to Markdown — GitHub-flavored markdown table
- to HTML — Styled HTML table
Analytics
- Stats — Count, mean, median, min, max, std for numeric columns
- Frequency — Value frequency distribution
- Pivot — Pivot table aggregation
🚀 Usage
View a CSV file
Read the CSV file at /path/to/data.csv and show the first 20 rows in a nice table.
Filter and sort
Read sales.csv, filter rows where amount > 1000, sort by date descending.
Merge multiple CSVs
Merge january.csv and february.csv into a single file Q1.csv.
Convert to JSON
Convert users.csv to JSON format and save as users.json.
Stats
Show statistics for all numeric columns in metrics.csv.
Dedupe
Remove duplicate rows from contacts.csv based on the email column.
Pivot table
Create a pivot table from sales.csv with region as rows, product as columns, sum of amount as values.
⚙️ Technical Details
- Runtime: Python 3.6+
- Dependencies: Zero (stdlib only: csv, json, statistics, re, argparse, os)
- Encoding: Auto-detect UTF-8/GBK/UTF-8-BOM
- Large files: Streaming processing for files >100MB
- Delimiters: Auto-detect comma, tab, semicolon, pipe
📝 Notes
- Auto-detects delimiter (comma, tab, semicolon, pipe)
- Handles quoted fields with embedded delimiters and newlines
- Preserves original encoding on write
- Supports gzip-compressed CSV files
Usage Guidance
This skill appears to be a straightforward, local CSV processing script. Before installing: (1) Confirm you only run it on files you trust, since it reads and writes local files and can overwrite inputs if no output path is provided; (2) If you need gzip support or other edge behaviors (the SKILL.md claims gzip handling and multiple encodings), review the full script to confirm those features work as expected; (3) Because the agent can invoke the skill autonomously, avoid granting it access to sensitive CSVs unless you trust automated runs. No network or secret exfiltration was found, but always keep backups of important data before bulk modifications.
Capability Analysis
Type: OpenClaw Skill
Name: csv-tool-pro
Version: 1.0.0
The skill is a standard CSV utility tool providing features like filtering, sorting, conversion, and statistical analysis. The implementation in `scripts/csv_tool.py` uses only Python standard libraries (csv, json, statistics) and contains no network calls, obfuscation, or suspicious execution patterns. The `SKILL.md` instructions are well-aligned with the tool's functionality and do not contain any prompt injection attempts.
Capability Assessment
Purpose & Capability
Name/description (CSV operations) align with the included Python script and SKILL.md feature list. Required binaries/credentials/configs are none, which is proportionate for a pure-Python, stdlib-based tool.
Instruction Scope
SKILL.md and the script instruct reading and writing CSV files, converting formats, and producing stats — all expected. The script reads user-specified file paths and writes output files (and by default may overwrite the input file for some commands if no output is given), so users should be aware it operates on local files they point it at.
Install Mechanism
No install spec (instruction-only skill with an included script). No downloads, package installs, or archive extraction are declared, which minimizes install-time risk.
Credentials
The skill declares no environment variables, secrets, or external credentials and the code does not access os.environ or external services — proportional for a local CSV utility.
Persistence & Privilege
Skill is not always-enabled and does not request persistent/privileged system presence. It does not modify other skills or system-wide configs.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install csv-tool-pro - After installation, invoke the skill by name or use
/csv-tool-pro - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
- Initial release of CSV Tool Pro.
- View, filter, sort, merge, split, and deduplicate CSV files with pure Python.
- Convert CSV to JSON, YAML, TSV, Markdown, and HTML.
- Perform stats, frequency counts, and create pivot tables.
- Supports streaming for large files and auto-detects delimiter and encoding.
- No external dependencies required.
Metadata
Frequently Asked Questions
What is CSV Tool Pro?
Perform comprehensive CSV file operations including viewing, filtering, sorting, merging, splitting, deduplication, conversion (JSON/YAML/TSV/Markdown/HTML),... It is an AI Agent Skill for Claude Code / OpenClaw, with 49 downloads so far.
How do I install CSV Tool Pro?
Run "/install csv-tool-pro" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is CSV Tool Pro free?
Yes, CSV Tool Pro is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does CSV Tool Pro support?
CSV Tool Pro is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created CSV Tool Pro?
It is built and maintained by darbling (@darbling); the current version is v1.0.0.
More Skills