Recalculate and validate formulas in Excel workbooks across spreadsheet formats.
npx skills add https://github.com/POBIM/Claude-Skill-Teach --skill xlsx-pobim
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/POBIM/Claude-Skill-Teach/tree/main/.claude/skills/xlsx Command: npx skills add https://github.com/POBIM/Claude-Skill-Teach --skill xlsx-pobim
Manually handling complex spreadsheets, ensuring formula integrity, and performing repetitive data operations can be time-consuming and error-prone. This skill automates these tasks, from creation to analysis and error checking, allowing you to focus on insights rather than mechanics.
.xlsx files with formulas and formatting, ensuring they remain dynamic and easily updateable.#REF!, #DIV/0!, #VALUE!) to ensure data integrity and accuracy..xlsx template, insert new data, update formulas, recalculate all values, and report any errors, ensuring the model is accurate and ready for review.Use the xlsx skill to create a new spreadsheet named 'quarterly_report.xlsx'. Include columns for 'Month', 'Revenue', and 'Expenses'. Add a 'Profit' column with a formula to calculate Revenue - Expenses. Populate with sample data for Q1.
High-intent search queries and answers about installing and using this skill.
Automatically recalculate and validate formulas by loading your .xlsx file, applying formula updates, and running error detection to eliminate #REF!, #DIV/0!, and #VALUE! errors. The skill uses LibreOffice for in-process recalculation and openpyxl to preserve templates while enforcing zero-formula-error output.
Yes, pandas and openpyxl allow you to read, analyze, and modify .xlsx, .xlsm, .csv, and .tsv data while preserving original formulas and formatting. Changes to data automatically propagate through formula-based calculations without disrupting template structure.
Automate spreadsheet creation, data insertion, and formula recalculation in a single workflow. Load an existing template, update data values, recalculate all formulas, validate for errors, and report results—ideal for quarterly reports or financial models requiring accuracy and consistency.
Yes, LibreOffice is required for in-process formula recalculation via the recalc.py script to ensure all formulas compute correctly and errors are caught. openpyxl and pandas handle data access and manipulation independently.
The skill automatically identifies common Excel errors during formula recalculation and generates error reports. Batch process multiple .xlsx, .xlsm, .csv, and .tsv files to validate formula integrity and surface issues before sharing models.
The skill supports .xlsx, .xlsm, .csv, and .tsv formats. It preserves formatting and formulas in native Excel files while enabling data analysis and modification across multiple tabular formats.
JetBrainsCreate, edit, and validate Excel spreadsheets with openpyxl and LibreOffice.
boshi-xixixiCreate and edit .xlsx, .xlsm, .csv, and .tsv spreadsheets with formulas and pandas.
el2060Automate Excel data manipulation, analysis, and formatting with pandas and openpyxl.
Sampi314Audit Excel financial models for formula, formatting, link, and code issues.