XLSX / Spreadsheet Skill

Name: XLSX / Spreadsheet Skill
Rating: 85 (1 reviews)
Author: openakita

Trust Score 85/100

Handle creation, editing, cleaning, and conversion of spreadsheet files (.xlsx, .xlsm, .csv, .tsv) with robust formulas, formatting, and recalculation workflows

triggers:xlsxspreadsheet filerecalculate formulaszero formula errorsclean tabular data

GitHub SKILL.md

What it does

This skill equips an agent to create, edit, analyze, and correct spreadsheet files (Excel .xlsx/.xlsm and delimited .csv/.tsv). It enforces professional formatting, preserves templates, and insists on delivering files with zero formula errors by using Excel formulas rather than hardcoded values. The skill includes guidance for number and date formatting, color-coding conventions for financial models, and workflows that combine pandas for data manipulation with openpyxl for formulas and formatting. It also documents a recalculation step using a provided scripts/recalc.py that leverages LibreOffice to evaluate formulas and report any errors.

When to use it

Trigger this skill when the user explicitly references a spreadsheet file (by name or path) or asks for a deliverable that must be an actual spreadsheet file — creating reports, cleaning tabular data, adding formulas, building financial models, or converting between tabular formats. Do NOT trigger when the primary deliverable is a Word doc, HTML report, standalone script, database pipeline, or a Google Sheets API integration.

What's included

Scripts: includes scripts/recalc.py and other helpers for formula recalculation and verification (has_scripts=true).
References: none listed.
Instructions: detailed requirements on fonts, number formats, color conventions for inputs vs formulas, formula construction rules, testing strategies, and a checklist for verifying formula correctness. The skill prescribes using formulas inside Excel (openpyxl) and pandas for data prep, and mandates running the recalculation step before delivery.

Compatible agents

Matches agents and toolchains that can run Python and manipulate files (e.g., Codex/Copilot-style agents or any agent with Python and file I/O).

Audit Summary

XLSX/spreadsheet skill with comprehensive SKILL.md covering creation, editing, formula workflows, and financial modeling standards. The bundled recalc.py script provides LibreOffice-based formula recalculation with error scanning, but fails to run standalone because it imports from 'office.soffice' — a module from the parent openakita package not included in the skill bundle. The SKILL.md itself is well-structured with clear triggers, detailed examples, and useful checklists.

Watch Out

Requires 'office' Python package (openakita internal) — not installable via pip independently
LibreOffice must be installed for formula recalculation
Script assumes it's run from within the openakita repo structure

Missing Dependencies

office (openakita internal package)

Notes

Well-crafted skill with good domain coverage. Main issue is the unbundled dependency on office.soffice — the skill should either bundle this module or clearly document it as a prerequisite. No security concerns whatsoever.

Information

Repository: openakita
Stars: 1,766

Trust Score

Overall85

Security95

Code Quality72

Architecture78

Usefulness82

More from openakita

Gmail Automation via Rube MCP

Automate Gmail actions (send, reply, search, labels, drafts, attachments) through a Rube MCP Gmail toolkit with best-practice tool sequences and pitfalls noted.

Nano Banana 2 — Gemini 3.1 Flash Image Preview

Run Google Gemini 3.1 Flash Image Preview via inference.sh CLI: text-to-image, image editing, multi-image input, and Google Search grounding.

PDF Processing (OpenAkita)

Process PDFs: extract text and tables, merge/split/rotate pages, OCR scanned PDFs, manipulate metadata, protect or watermark files, and generate new PDFs progra

Baidu Search

Enable agents to perform real-time Chinese web and image searches via Baidu Qianfan API, including time filtering and relevance/authority signals.

PPTX — Presentation (.pptx) Skill

Create, read, edit, and QA .pptx presentations: extract text, generate thumbnails, edit templates, and convert slides for visual QA and exports.

Related Skills

Bounty Hunter — Atlas

Persona skill: 'Atlas' — a profit-focused developer persona for discovering, evaluating and executing paid bounties or freelance tasks with ROI-aware workflows.

FastAPI Project Templates

Creates production-ready FastAPI project scaffolds with async patterns, DI, middleware, and testing best practices for high-performance APIs.

LBO Model (Excel)

Build professional leveraged buyout (LBO) Excel models from templates, including sources & uses, debt schedules, cash sweeps, and IRR/MOIC sensitivity analysis.

Doc Cleaner

Convert PDF, DOCX, XLSX and text files into clean, structured Markdown with CJK and table support; supports offline or AI-enhanced modes.

Prompt Engineering Patterns

A practical collection of prompt engineering techniques and patterns for building reliable, controllable LLM prompts: CoT, few-shot, structured outputs, templat

Office & Design Toolkit

Comprehensive toolkit for processing and producing DOCX, PPTX, XLSX and PDF files plus design guidance and quality checks for professional office documents and

Confluence Expert

Manage Confluence spaces, templates, permissions and documentation workflows; create page hierarchies, macros and governance for team knowledge bases.

Create & Configure Agents

Helpers and templates to scaffold agent directories, generate agent.yaml, and author SOUL.md and RULES files for new agents.

Back to Skills