Automate Mixpanel tasks via Rube MCP (Composio): events, segmentation, funnels, cohorts, user profiles, JQL queries. Always search tools first for current schemas.
Xlsx
The XLSX skill is designed for robust interaction with spreadsheet files, serving as the primary tool for any task involving opening, reading, editing, or generating `.xlsx`, `.xlsm`, `.xltx`, `.csv`, or `.tsv` files. It handles a wide array of operations, from adding columns and computing formulas to advanced formatting, charting, and cleaning messy data. This skill is particularly adept at creating new spreadsheets from scratch or diverse data sources, and converting between various tabular file formats.
It should be triggered whenever a user explicitly references a spreadsheet file by name or path, even casually, and desires an action to be performed on it or a spreadsheet to be produced. Additionally, it excels at cleaning and restructuring malformed tabular data, transforming it into proper, well-structured spreadsheets. The core deliverable for any task utilizing this skill must always be a spreadsheet file.
Crucially, this skill enforces strict quality standards for all outputs, including professional fonts, zero formula errors, the use of formulas over hardcoded values, literal adherence to user specifications, and thorough documentation of assumptions. It also provides specific guidance for financial models, covering formatting, numbering conventions, and structural best practices.
What It Does
This skill provides comprehensive tools for interacting with spreadsheet files, including .xlsx, .xlsm, .xltx, .csv, and .tsv formats. It allows you to open, read, edit, and generate spreadsheets, performing operations like adding columns, computing formulas, advanced formatting, charting, and cleaning messy data. You can also create new spreadsheets from various data sources or convert between different tabular file formats.
When To Use
- You need to add new columns or compute formulas within an existing .xlsx spreadsheet.
- You want to create a new spreadsheet from scratch or by combining data from different sources.
- You have a .csv or .tsv file and need to convert it into an .xlsx format.
- You need to clean and restructure messy tabular data, such as malformed rows or misplaced headers, into a proper spreadsheet.
- You are working on a financial model and need to apply specific formatting, numbering conventions, and structural best practices.
- You need to perform advanced formatting or charting on spreadsheet data.
Inputs
- spreadsheet_file: This is the existing spreadsheet file that the skill will open, read, edit, or fix.
- user_specifications: These are the literal instructions from the user regarding tab names, column headers, formulas, and formatting for the desired output.
Outputs
- spreadsheet_file: This is the resulting spreadsheet file, which can be a new creation, an edited version of an existing file, or a converted tabular data file.: .xlsx, .xlsm, .xltx, .csv, or .tsv file
Limitations
Installation
Copy to ~/.claude/skills/Configure in API settingsAdd to ~/.gemini/skills/Register as MCP toolWhat people say, and where to get help
No ratings yet. If you have used this skill, yours would be the first.
Sign in to leave a rating
An account keeps your review with your name on it, and lets you edit it later. Sign in or create one free.
No reviews yet
This skill has not been rated. If you have run it, a short note about what you used it for helps the next person more than any description can.
Related Skills You May Like
Discover more AI agent skills in the same category to enhance your workflow automation.
Interact with Azure Data Lake Storage Gen2 using Python for hierarchical file systems, big data analytics, and file/directory operations.
Master prompt evaluation techniques for AI models using Anthropic API, Workbench, and promptfoo across nine comprehensive lessons.
A comprehensive guide to using Claude's Skills feature for document generation, data analysis, and business automation.
A comprehensive tutorial series on building sophisticated general-purpose AI agents using the Claude Agent SDK, from basic research to multi-agent orchestration.
Search and analyze your OpenClaw agent's session logs (older conversations) using jq and rg.
Have a Skill to Share?
Join the community and help AI agents learn new capabilities. Submit your skill and reach thousands of developers.