- Home
- Skills
- Data & Databases
- XLSX Toolkit: Read, Create, and Transform Excel Spreadsheets
XLSX Toolkit: Read, Create, and Transform Excel Spreadsheets
Complete skill for spreadsheet automation without needing Excel
Free
Works with the AI Agents you already use
XLSX Toolkit: Read, Create, and Transform Excel Spreadsheets
Example session with this skill installed
Create a 3-year revenue projection in a new Excel file. Use 2024 as the base year with $5M revenue and a 10% growth rate assumption. Use standard financial modeling colors.
- Read your context and instructions
- Compiled the xlsx toolkit
I have created 'projection.xlsx'. Cell B2 contains the $5,000,000 input (blue text), and C2 contains the formula '=B2*(1+$B$5)' (black text) for 2025. All formulas were verified with zero errors (#REF!, #DIV/0!) using the recalculation script.
Connects securely to your tools. The creator never sees your data.
About this skill
The problem
LLMs often struggle with structured spreadsheet tasks, frequently hardcoding values instead of formulas or producing broken cell references. Manual data cleaning and financial modeling in Excel are time-consuming and prone to human calculation errors.
What it does
- Generates dynamic .xlsx and .csv files using Python libraries like pandas and openpyxl.
- Implements industry-standard financial modeling practices including specific color-coding for inputs and formulas.
- Constructs live Excel formulas (SUM, AVERAGE, growth rates) rather than static values to ensure files remain updateable.
- Validates spreadsheet integrity by scanning for #REF!, #DIV/0!, and #VALUE! errors using a dedicated recalculation engine.
- Cleans messy tabular data, fixes malformed rows, and converts between spreadsheet formats.
Frameworks & tools
Python, pandas, openpyxl, and LibreOffice for formula recalculation.
Why this beats prompting it yourself
Standard prompts often yield static data snapshots that break when edited. This skill enforces strict formula-based construction and uses a verification loop to catch broken references before delivery, ensuring professional-grade financial models every time.
Use cases
- Build dynamic three-statement financial models with standardized color-coding and assumptions.
- Clean and restructure malformed CSV exports into formatted Excel reports.
- Automate repetitive spreadsheet updates while preserving existing stylistic templates.
- Perform bulk data analysis and visualization across multi-sheet workbooks.
Known limitations
Requires a local environment with LibreOffice installed to execute the mandatory formula recalculation script. Not intended for Google Sheets API integrations or generating Word/HTML reports.
Based on the open-source skill from Anthropic's anthropics/skills repository (Apache-2.0). See NOTICE.md.
For merging several documents into one, see Multi-Source Document Merger by Shogun Labs.
Requires a local environment with LibreOffice installed to execute the mandatory formula recalculation script. Not intended for Google Sheets API integrations.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
16 uses
Times used to date
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed 6 days ago
- Free with an Agensi account
Requires