What does this skill do?

XLSX Skill is the ultimate Excel tool for Claude. Create spreadsheets with complex formulas, edit files while preserving the formulas, analyze data, and generate visualizations, budgets, and financial models.

Quotes
Spreadsheets with automatic formulas and annual projections.
Data Analysis
Processing and analyzing datasets using statistics and visualizations.
Dashboards
Interactive dashboards with KPIs, charts, and real-time metrics.
Planning
Gantt charts, project planners, and calendars in Excel.

Usage examples

💰 Budget
Create an annual budget spreadsheet with categories for expenses, income, and monthly profit.
📈 Analysis
Analyze this sales CSV file and create an Excel spreadsheet with pivot tables and trend charts.
📊 Dashboard
Generate a financial dashboard with KPIs and a 12-month forecast.
📅 Gantt
Create a Gantt chart with milestones, dependencies, and project leads.

Features

Complex Formulas VLOOKUP, INDEX/MATCH, SUMIF, and advanced functions.
Formula Preservation Edit files without breaking existing formulas.
Automatic Recalculation Verify the results of complex formulas.
Data Analysis Descriptive statistics, correlations, and trends.
Multiple Sheets Excel workbooks with multiple interconnected sheets.

Frequently asked questions

Yes. It converts CSV files to Excel while preserving formatting, formulas, and structure.
Yes. Always make a backup before modifying critical files.
Claude can write basic VBA. He checks the macros before running them.
XLSX skill Claude