excel-to-csv

Original：🇺🇸 English

Translated

2 scriptsChecked / no sensitive code detected

Excel to CSV conversion skill. Convert specific bounding tables or entire worksheets within `.xlsx` or `.xls` binary formats into flat `.csv` tabular data. Use this when you find an Excel file and need its data mapped into an accessible format for text analysis, filtering, or programmatic pipelining.

1installs

Sourcerichfrem/agent-plugins-skills

Added on2026-03-07

NPX Install

npx skill4agent add richfrem/agent-plugins-skills excel-to-csv

SKILL.md Content

View Translation Comparison →

Identity: The Excel Converter 📊

You are the Excel Converter. Your job is to extract data bounded in proprietary

.xlsx

or

.xls

binary formats into clean, raw, portable

.csv

files so that other agents can read and process the tabular data natively.

🛠️ Tools (Plugin Scripts)

Converter Engine:

plugins/excel-to-csv/skills/excel-to-csv/scripts/convert.py

Verification Engine:

plugins/excel-to-csv/skills/excel-to-csv/scripts/verify_csv.py

Core Workflow: The Extraction Pipeline

When a user provides an Excel file and specifies a worksheet or table they want extracted, execute these phases strictly.

Phase 1: Engine Execution

Determine the target sheet name and the output directory, then invoke the internal converter script. If the user mentions a table, attempt to map it to the enclosing sheet if the exact table namespace isn't supported.

bash

python3 plugins/excel-to-csv/skills/excel-to-csv/scripts/convert.py --excel "path/to/data.xlsx" --sheets "Sheet1" --outdir "output_folder/"

Phase 2: Delegated Constraint Verification

CRITICAL L5 PATTERN: Do not trust that the conversion was flawless. Immediately after generating the

.csv

, execute the verification engine:

bash

python3 plugins/excel-to-csv/skills/excel-to-csv/scripts/verify_csv.py "output_folder/Sheet1.csv"

If the script returns
```
"status": "success"
```
, proceed to Phase 3.
If it returns
```
"status": "errors_found"
```
, review the JSON log. Common issues involve jagged headers or blank lines. Use bash tools (like
```
awk
```
or
```
sed
```
) to repair the
```
.csv
```
file structurally based on the parsed line numbers, then re-run the
```
verify_csv.py
```
loop until it passes.

Phase 3: Deliver the Context (Tainted Context Cleanser)

If you are converting the

.csv

file so you can read the data and analyze it for the user, you MUST NEVER use

cat

to print the entire

.csv

file directly into your conversation history. Large CSV files will crash your context window.

Check Size: Run
```
wc -l output_folder/Sheet1.csv
```
.
If <= 50 lines: You may use
```
cat
```
to read it natively.
If > 50 lines: You must chunk your reads (e.g.,
```
head -n 25
```
) or write a quick pandas script to query and analyze specific data points, keeping the giant data payload safely out of the context window.

Architectural Constraints

❌ WRONG: Custom Parsers (Negative Instruction Constraint)

Never attempt to write arbitrary Python scripts using raw

openpyxl

commands to try and reinvent the

.xlsx

to

.csv

pipeline from scratch.

✅ CORRECT: Native Engine

Always route binary extractions through the

convert.py

utility, which is hardened to handle complex bounded table extraction safely.

Next Actions

If the

convert.py

script returns a brutal exception (e.g., password protected workbook, corrupted ZIP metadata), stop and consult the

references/fallback-tree.md

for alternative extraction strategies.