Stats
Actions
Tags
From ai-skills
Read and extract data from Excel (.xlsx) files efficiently using Python. Use when opening, reading, analyzing, or inspecting xlsx/Excel spreadsheets, extracting tabular data to JSON, inspecting sheet structure or headers, converting spreadsheet data for processing, or any task involving .xlsx files. Triggers on references to xlsx, Excel, spreadsheet files, or data extraction from workbooks.
How this skill is triggered — by the user, by Claude, or both
Slash command
/ai-skills:xlsx-readerThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Read xlsx files with `scripts/read_xlsx.py`. Uses `uv run` for automatic dependency management.
Read xlsx files with scripts/read_xlsx.py. Uses uv run for automatic dependency management.
# Get structure without data (always start here)
uv run ${SKILL_DIR}/scripts/read_xlsx.py file.xlsx --mode info
# Preview first 10 rows
uv run ${SKILL_DIR}/scripts/read_xlsx.py file.xlsx --rows 10
# Read specific sheet
uv run ${SKILL_DIR}/scripts/read_xlsx.py file.xlsx --sheet "Sheet2"
# Read cell range
uv run ${SKILL_DIR}/scripts/read_xlsx.py file.xlsx --mode range --range B2:D50
# Full data (avoid for large files)
uv run ${SKILL_DIR}/scripts/read_xlsx.py file.xlsx --mode full
# Force/disable header detection
uv run ${SKILL_DIR}/scripts/read_xlsx.py file.xlsx --headers
uv run ${SKILL_DIR}/scripts/read_xlsx.py file.xlsx --no-headers
| Mode | Use Case | Output Size |
|---|---|---|
info | Structure, sheets, dimensions, headers | Minimal |
preview | First N rows (default 20) | Small |
range | Specific cells (e.g., A1:C10) | Targeted |
full | All data | Large - use sparingly |
--mode info to understand structure--mode preview with appropriate --rows for context--mode range for targeted extraction--mode full on large files (>1000 rows)All modes return JSON. Preview/full modes with detected headers return data as objects:
{
"mode": "preview",
"sheet": "Sheet1",
"headers": ["Name", "Value", "Status"],
"data": [
{"Name": "item_1", "Value": 10, "Status": "active"},
{"Name": "item_2", "Value": 20, "Status": "inactive"}
],
"total_rows": 500,
"showing": 2,
"has_more": true
}
Without headers (or --no-headers), data is arrays of arrays. Duplicate header names get _2, _3 suffixes automatically.
Errors return {"error": "message"} with exit code 1. Common cases:
--range for range mode → clear error messagenpx claudepluginhub inromualdo/ai-skills --plugin xlsx-readerEdits, creates, fixes .xlsx/.csv/.tsv spreadsheets: clean data, add formulas/charts, apply financial formatting standards with zero errors.
Creates, edits, analyzes spreadsheets (.xlsx, .xlsm, .csv, .tsv) with formulas, formatting, data analysis, visualization. Applies financial model standards for colors, numbers, error-free formulas.
Creates, edits, analyzes spreadsheets (.xlsx, .xlsm, .csv, .tsv) with formulas, formatting, data analysis, visualization. Applies financial model standards for colors, numbers, error-free formulas.