CSV Tool Pro

Perform comprehensive CSV file operations including viewing, filtering, sorting, merging, splitting, deduplication, conversion (JSON/YAML/TSV/Markdown/HTML),...

Security Scan

The skill's code, instructions, and requirements are consistent with a local CSV processing tool and do not request unrelated credentials, network access, or elevated persistence.

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.

Assessment

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.

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