"Comprehensive 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"
The xlsx skill provides comprehensive functionalities for creating, editing, and analyzing spreadsheet files in various formats such as .xlsx, .xlsm, .csv, and .tsv. This skill addresses the common challenges faced by users when managing spreadsheets, particularly those involving complex formulas and data analysis. By ensuring that all generated spreadsheets are free of formula errors and adhere to specific formatting standards, it enhances the reliability and usability of the output files.
The xlsx skill supports .xlsx, .xlsm, .csv, and .tsv file formats.
LibreOffice must be installed to allow for formula recalculation using the provided `recalc.py` script.
The skill mandates thorough checks for all cell references, consistent formulas, and testing with edge cases to prevent formula errors.
Yes, the skill can modify existing templates while preserving their format, style, and conventions.
The skill utilizes pandas for data analysis, allowing users to read, manipulate, and visualize data from Excel files.
Quick Setup:
.claude/skills/Repository
ComposioHQ/awesome-claude-skills