---

name: "document-processor-xlsx" description: "Create, edit, and analyze Excel spreadsheets with formulas, charts, pivot tables, and data analysis (Official Anthropic skill)" version: "1.0.0" author: "Anthropic (Adapted for CemaPay)" category: "documents" tags: ["xlsx", "excel", "spreadsheet", "data-analysis", "charts", "office"] requiresAuth: true source: "anthropic-official"

Excel Document Processor Skill

🎯 PURPOSE

Official Anthropic skill for Microsoft Excel spreadsheet manipulation (.xlsx files). Supports:

• Data Creation: Generate spreadsheets from structured data
• Formula Processing: Complex calculations, VLOOKUP, pivot tables
• Chart Generation: Line, bar, pie, scatter plots
• Data Analysis: Statistical analysis, trend detection
• Import/Export: CSV, JSON, database integration

🔍 WHEN TO USE THIS SKILL

Trigger when users mention:

• "create spreadsheet", "Excel", "xlsx", "data analysis"
• "generate report", "financial model", "budget"
• "pivot table", "formulas", "calculate", "chart"

📋 CAPABILITIES

1. Spreadsheet Creation

CopycreateSpreadsheet({
  sheets: [
    {
      name: "Q4 Transactions",
      headers: ["Date", "Amount", "Currency", "Status"],
      rows: [
        ["2025-10-01", 1000000, "XAF", "Completed"],
        ["2025-10-02", 500000, "XAF", "Pending"]
      ],
      formulas: {
        "E2": "=SUM(B:B)", // Total amount
        "F2": "=AVERAGE(B:B)" // Average transaction
      }
    }
  ]
});

2. Financial Analysis

• Revenue reports
• Transaction summaries
• Budget vs actuals
• Profit & loss statements
• Cash flow analysis

3. Advanced Features

• Conditional formatting
• Data validation
• Pivot tables
• Charts and graphs
• Multi-sheet workbooks

💡 INTEGRATION EXAMPLE

User: "Create an Excel report of all October transactions"

AI Response:

CopyI'll generate a comprehensive transaction report.

Sheet 1: Transaction Summary
- Total Transactions: 125,430
- Total Volume: 1.2B XAF
- Average Transaction: 9,567 XAF
- Top 10 merchants included

Sheet 2: Daily Breakdown
[Pivot table by date]

Sheet 3: Currency Analysis
[Chart showing XAF vs NGN vs USD]

Sheet 4: Raw Data
[All 125,430 transactions]

Generated: October_Transactions_2025.xlsx
File size: 2.3 MB
Download ready!

🔧 TECHNICAL DETAILS

• Library: exceljs (Node.js) or openpyxl (Python)
• Supported Formats: .xlsx, .csv, .xls (legacy)
• Max Rows: 1,000,000 (Excel limit: 1,048,576)
• Max Columns: 16,384 (Excel limit)

📚 DOCUMENTATION

Official Anthropic Documentation: https://docs.anthropic.com/en/docs/build-with-claude/agent-skills

---

Version: 1.0.0
Source: Anthropic Official Skills Library
Last Updated: October 24, 2025