A zero-dependency Python toolkit for manipulating, filtering, and converting CSV files directly from the command line.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install csv-toolkit
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 csv-toolkit 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 CSV Toolkit?
CSV Toolkit is a lightweight, pure Python utility designed for seamless tabular data management without the overhead of external libraries. As a versatile part of the Openclaw Skills ecosystem, it provides developers and data analysts with a robust set of commands to inspect, clean, and transform CSV files using a simple CLI interface.
Whether you are dealing with spreadsheet exports or preparing data for machine learning, this skill bridges the gap between raw text files and structured data. It excels at quick data exploration and integrates perfectly into automated pipelines where dependencies must be kept to a minimum.
CSV Toolkit Use Cases
- Inspecting large CSV exports as formatted tables directly in the terminal.
- Cleaning datasets by removing duplicates or filtering rows based on specific column conditions.
- Converting tabular data to JSON format for web application integration or vice versa.
- Generating quick statistical summaries (mean, median, min/max) for numeric columns without opening a spreadsheet GUI.
- Merging multiple CSV files with identical headers into a single unified dataset.
How CSV Toolkit Works
- The toolkit reads the source CSV file using the specified delimiter and encoding (defaulting to UTF-8 and commas).
- User-specified commands (like filter, sort, or select) are applied to the data stream in-memory.
- For numeric operations like stats or sorting, the tool automatically detects and casts data types to ensure mathematical accuracy.
- The processed result is either rendered as a human-readable ASCII table in the stdout or written to a structured output file.
CSV Toolkit Setup
To use this within your Openclaw Skills environment, ensure you have Python 3.x installed. No additional pip installations are required.
# Clone or copy the script to your project
# Ensure the script is executable
chmod +x scripts/csv_toolkit.py
# Run a basic check to verify installation
python3 scripts/csv_toolkit.py --help
CSV Toolkit Data Schema & Taxonomy
The skill processes standard delimited text files and produces structured outputs.
| Data Type | Description |
|---|---|
| Input | CSV or TSV files (configurable delimiter). |
| Output | Formatted CLI tables, JSON arrays, or new CSV files. |
| Metadata | The tool identifies headers from the first row to map column names for filtering and stats. |
Supported filter operators include: > (greater than), == (equal to), != (not equal), and <= (less than or equal).
CSV Toolkit Advanced Features
- Advanced numeric-aware sorting that distinguishes between string and integer ordering.
- Multi-condition filtering using the -w flag where multiple arguments are treated as logical AND operations.
- Seamless TSV support by utilizing the -d '\t' delimiter flag.
- Automated JSON transformation that handles data type detection for numeric values.
- Streamlined merging capabilities for batch processing multiple source files into a single output.
SKILL.md
Loading
Related Openclaw Skills
Video Script Generator
An automated AI agent skill that transforms product descriptions and target audience data into structured video scripts and shot-by-shot storyboards.
Quant Data Platform
A robust quantitative data infrastructure providing real-time quotes, historical K-lines, and alternative sentiment data for the Chinese A-share market.
Twitter Browser Controller
A powerful browser-based automation tool for Twitter/X that operates like a human user via Chrome without requiring API keys.
Traffic Lights
A visualization skill for building multi-criteria assessment charts using traffic lights, Harvey balls, and weighted scoring models.
Memory Palace
A universal memory activation tool that enables AI agents to inherit your personal knowledge, methodology, and digital identity.
Tongyi Qianwen API Integration
A professional developer guide for integrating Alibaba's Tongyi Qianwen (Qwen) models via the DashScope platform with full OpenAI SDK compatibility.
Featured*
