XLSX Spreadsheet Manipulator
Skill AvertissementComprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
This extension leverages Python libraries like pandas and openpyxl to perform detailed spreadsheet operations, including formula creation and data analysis. It requires LibreOffice for formula recalculation and handles various Excel file formats.
Documentation
- info:Configuration & parameter referenceThe documentation outlines libraries and workflows but lacks explicit documentation for specific parameters or configuration options, relying on implicit knowledge of pandas and openpyxl.
License
- critical:License usabilityThe provided LICENSE.txt indicates 'Proprietary' usage governed by Anthropic's terms of service, with restrictions against extraction, reproduction, and distribution outside the Services, which conflicts with typical open-source OSS licenses.
Code Execution
- info:ValidationWhile pandas and openpyxl handle data internally, the `recalc.py` script directly processes the input filename without explicit validation of its type or content before passing it to subprocess commands.
- warning:Tool FallbackThe skill explicitly requires LibreOffice for formula recalculation, and while it attempts setup, there is no clear fallback path if LibreOffice is unavailable or unconfigurable.
Portability
- warning:Runtime stabilityThe skill requires LibreOffice to be installed and configured, which is a significant runtime dependency not universally available.
- warning:Stack assumptionsThe skill assumes Python, pandas, openpyxl, and importantly, LibreOffice are installed and configured on the user's system, which is a significant stack assumption.
Practical Utility
- info:Edge casesThe documentation mentions potential errors like #REF! and #DIV/0! and advises on fixing them, but it doesn't systematically list all failure modes and recovery paths.
Installation
npx skills add bilalmk/todo_correctExécute le CLI skills de Vercel (skills.sh) via npx — nécessite Node.js en local et au moins un agent compatible skills installé (Claude Code, Cursor, Codex, …). Suppose que le dépôt suit le format agentskills.io.
Extensions similaires
Excel Spreadsheet Operations
75Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
Data Analysis Skill
96Use this skill when the user uploads Excel (.xlsx/.xls) or CSV files and wants to perform data analysis, generate statistics, create summaries, pivot tables, SQL queries, or any form of structured data exploration. Supports multi-sheet Excel workbooks, aggregation, filtering, joins, and exporting results to CSV/JSON/Markdown.
XLSX Manipulation Skill
75Create, edit, and manipulate Excel spreadsheets programmatically using openpyxl
XLSX Spreadsheet Skill
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.
XLSX Generator
98Create and manipulate Excel XLSX files programmatically. Use when the user needs to generate spreadsheets, modify XLSX templates, extract spreadsheet content, or automate Excel workflows. Supports both template-based generation (for branding compliance) and from-scratch creation. Keywords: Excel, XLSX, spreadsheet, workbook, worksheet, data, report, template, financial, analysis.
Data Analysis Assistant
98Analyze spreadsheet data, generate insights, create visualizations, and build reports from Excel/CSV data.