skills.rest
lawvable
lawvableOFFICIAL
Explore all skills by this author →
GitHub

xlsx-processing-anthropic

Create, edit, and analyze Excel workbooks while preserving formulas and templates.

630|79|Updated Dec 18, 2025
Search Tags:#visualization#openpyxl#formulas#excel#data-analysis#xlsx
One-click install
npx skills add https://github.com/lawvable/awesome-legal-skills --skill xlsx-processing-anthropic
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx-processing-anthropic
Source: https://github.com/lawvable/awesome-legal-skills/tree/main/%F0%9F%9B%A0%EF%B8%8F/xlsx-processing-anthropic
Command: npx skills add https://github.com/lawvable/awesome-legal-skills --skill xlsx-processing-anthropic

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) components.

What problem does it solve?

This Skill provides a turnkey solution for creating, editing, and analyzing Excel workbooks while preserving existing formulas and templates, enabling teams to automate routine spreadsheet workflows without breaking established formats.

Core Features & Use Cases

  • Automated workbook creation with formulas, formatting, and data validation to ensure consistency across projects.
  • Data analysis and visualization capabilities that read data, perform calculations, and render insights while maintaining cell formulas for dynamic updates.
  • Template preservation and safe updating of existing workbooks, with automatic recalculation to keep outputs in sync with inputs.

Quick Start

Use the xlsx-processing-anthropic skill to process your workbook 'sales-q1.xlsx': preserve formulas, apply standard formatting, and recalculate all formulas.

Frequently Asked Questions about xlsx-processing-anthropic

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I edit an Excel workbook and preserve existing formulas?▼

To edit an Excel workbook and preserve existing formulas, you can use openpyxl for template preservation combined with a LibreOffice-based recalculation script to ensure formulas remain live and outputs stay in sync.

How do I automate Excel workbook creation with formulas and formatting?▼

Automate Excel workbook creation by using openpyxl to programmatically apply formulas, standard formatting, and data validation, ensuring consistency across projects while generating new .xlsx or .xlsm files.

Can I read and analyze data from .csv and .tsv files using openpyxl?▼

Yes, you can read and analyze data from .csv and .tsv files. The skill processes these formats alongside .xlsx and .xlsm to perform calculations and render insights while maintaining cell formulas.

What is the best way to recalculate Excel formulas after updating data?▼

The best way to recalculate Excel formulas after updating data is using a LibreOffice-based recalculation script, which maintains live formulas and keeps spreadsheet outputs accurately synchronized with new inputs.

Does this approach support data visualization within Excel spreadsheets?▼

Yes, this approach supports data visualization within Excel spreadsheets. It reads data, performs necessary calculations, and renders visual insights directly in the workbook while maintaining underlying cell formulas.

Related Skills

Explore More Data & Analytics Skills→
AndersHsuehAndersHsueh

xlsx

Create, edit, and analyze Excel workbooks with Python and LibreOffice recalculation.

Community
Advanced
eddie-292eddie-292
52

xlsx

Create, edit, clean, convert, and validate xlsx, xlsm, csv, and tsv workbooks.

Community
Advanced
logeshv586-codelogeshv586-code

xlsx

Analyze spreadsheet data and create charts with openpyxl, pandas, and matplotlib.

Community
Advanced
vasilyu1983vasilyu1983
73

document-xlsx

Create, edit, and analyze Excel workbooks with formulas and charts.

Community
Advanced