← Back to Skills Marketplace
233
Downloads
0
Stars
1
Active Installs
1
Versions
Install in OpenClaw
/install csv-toolkit
Description
Manipulate CSV files from the command line — view, filter, sort, select columns, convert CSV to/from JSON, compute statistics, deduplicate, and merge files....
README (SKILL.md)
CSV Toolkit
Command-line CSV manipulation — view, filter, sort, select, convert, stats, dedup, and merge. Pure Python, no dependencies.
Quick Start
# View as formatted table
python3 scripts/csv_toolkit.py view data.csv
python3 scripts/csv_toolkit.py view data.csv --head 10
# Filter rows
python3 scripts/csv_toolkit.py filter data.csv -w 'age>30' 'city==Chicago'
# Sort
python3 scripts/csv_toolkit.py sort data.csv --by salary --desc
# Select columns
python3 scripts/csv_toolkit.py select data.csv -c "name,email,salary"
# Convert to JSON
python3 scripts/csv_toolkit.py to-json data.csv -o data.json
# Convert JSON back to CSV
python3 scripts/csv_toolkit.py from-json data.json -o data.csv
# Column statistics
python3 scripts/csv_toolkit.py stats data.csv -c "age,salary"
# Remove duplicates
python3 scripts/csv_toolkit.py dedup data.csv -o clean.csv
# Merge files
python3 scripts/csv_toolkit.py merge file1.csv file2.csv -o combined.csv
Commands
| Command | Description |
|---|---|
view |
Display CSV as a formatted table. Use --head N / --tail N to limit rows. |
filter |
Filter rows with -w conditions: col>val, col==val, col!=val, col\x3C=val. Multiple conditions = AND. |
sort |
Sort by column with --by col. Add --desc for descending. Numeric-aware. |
select |
Pick columns with -c "col1,col2". |
to-json |
Convert CSV to JSON array of objects. Auto-detects numbers. |
from-json |
Convert a JSON array of objects to CSV. |
stats |
Column statistics: count, unique values, min/max/mean/median for numeric columns. |
dedup |
Remove duplicate rows. |
merge |
Concatenate multiple CSV files (same headers). |
Global Options
| Flag | Description |
|---|---|
-d, --delimiter |
Field delimiter (default: ,). Use -d ' ' for TSV. |
--encoding |
File encoding (default: utf-8). |
-o, --output |
Write result to file instead of stdout. |
Usage Guidance
This appears to be a straightforward local CSV toolkit that operates on files you supply. Before installing or running it: (1) Inspect the remainder of scripts/csv_toolkit.py (the provided excerpt was truncated) to confirm there are no network calls, subprocess.exec/OS.exec usage, or code that reads unexpected system paths. (2) Run the tool in a sandbox or on non-sensitive sample files first. (3) Be cautious when opening CSV outputs in spreadsheet software (Excel/Sheets) because malicious CSV cells starting with =,+,- or @ can trigger formula execution in spreadsheet apps; sanitize if you plan to open outputs in such apps. If you want, provide the full script (untruncated) and I can re-check and raise confidence to high.
Capability Analysis
Type: OpenClaw Skill
Name: csv-toolkit
Version: 1.0.0
The csv-toolkit skill is a standard utility for manipulating CSV files, providing features like filtering, sorting, and format conversion. The Python script (scripts/csv_toolkit.py) uses only standard libraries and contains no evidence of malicious intent, data exfiltration, or unauthorized execution; its behavior is entirely consistent with its documented purpose in SKILL.md.
Capability Assessment
Purpose & Capability
Name/description match the SKILL.md and the included script: view, filter, sort, select, convert, stats, dedup, merge. The required resources (none) are proportionate to the stated purpose.
Instruction Scope
SKILL.md instructs the agent to run the local Python script against user-supplied files and standard CLI flags. The instructions only read/write files provided via arguments and do not direct data to external endpoints, request additional environment variables, or instruct the agent to read unrelated system files.
Install Mechanism
No install spec — instruction-only with a shipped Python script. There are no downloads, package installs, or extraction steps that would write or execute remote code.
Credentials
The skill requests no environment variables, credentials, or config paths. The code shown uses only Python standard library modules and reads/writes only files passed on the command line.
Persistence & Privilege
The skill is not always-enabled and does not request persistent privileges or modify other skills or system-wide agent settings. It runs only when invoked.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install csv-toolkit - After installation, invoke the skill by name or use
/csv-toolkit - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release of csv-toolkit.
- Manipulate CSV files via command line: view, filter, sort, select columns, deduplicate, and merge.
- Convert CSV data to/from JSON.
- Compute column statistics including count, unique, min, max, mean, and median.
- Supports custom delimiters, file encoding, and output files.
- Pure Python implementation with zero external dependencies.
Metadata
Frequently Asked Questions
What is Csv Toolkit?
Manipulate CSV files from the command line — view, filter, sort, select columns, convert CSV to/from JSON, compute statistics, deduplicate, and merge files.... It is an AI Agent Skill for Claude Code / OpenClaw, with 233 downloads so far.
How do I install Csv Toolkit?
Run "/install csv-toolkit" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Csv Toolkit free?
Yes, Csv Toolkit is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Csv Toolkit support?
Csv Toolkit is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Csv Toolkit?
It is built and maintained by John Wang (@johnnywang2001); the current version is v1.0.0.
More Skills