Excel Spreadsheets

🌐Community
by aws-samples · vlatest · Repository

This skill allows you to generate and manipulate Excel spreadsheets directly within your workflow, streamlining data analysis and reporting.

Install on your platform

We auto-selected Claude Code based on this skill’s supported platforms.

1

Run in terminal (recommended)

terminal
claude mcp add excel-spreadsheets npx -- -y @trustedskills/excel-spreadsheets
2

Or manually add to ~/.claude/settings.json

~/.claude/settings.json
{
  "mcpServers": {
    "excel-spreadsheets": {
      "command": "npx",
      "args": [
        "-y",
        "@trustedskills/excel-spreadsheets"
      ]
    }
  }
}

Requires Claude Code (claude CLI). Run claude --version to verify your install.

About This Skill

What it does

This skill allows AI agents to interact with and manipulate Excel spreadsheets. It can read data from existing files, create new spreadsheets, perform calculations within cells using formulas, and write updated data back to files. The agent can understand instructions related to cell selection, formula application, and data formatting.

When to use it

  • Data Analysis: Extracting key metrics and insights from a spreadsheet containing sales figures or customer demographics.
  • Report Generation: Automatically updating a report by pulling data from an Excel file and generating new charts or tables.
  • Financial Modeling: Creating and modifying financial models, including calculating loan payments or projecting investment returns.
  • Inventory Management: Updating inventory levels in a spreadsheet based on sales transactions.

Key capabilities

  • Reading data from existing Excel files (.xlsx)
  • Creating new Excel spreadsheets
  • Writing updated data to Excel files
  • Applying formulas to cells (e.g., SUM, AVERAGE)
  • Cell selection and manipulation

Example prompts

  • "Can you open 'sales_data.xlsx' and tell me the total sales for Q3?"
  • "Create a new spreadsheet called 'budget.xlsx' and add columns for 'Category', 'Planned Amount', and 'Actual Amount'."
  • “In ‘inventory.xlsx’, update the quantity of product ID 123 to 50.”

Tips & gotchas

  • The agent requires access to the Excel files you want it to work with. Ensure proper file paths are provided.
  • Complex formulas or advanced formatting options may require more detailed instructions for optimal results.

Tags

🛡️

TrustedSkills Verification

Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.

Security Audits

Gen Agent Trust HubPass
SocketPass
SnykPass

Details

Version
vlatest
License
Author
aws-samples
Installs
5

🌐 Community

Passed automated security scans.