How-to · Documents · By ClawHub Community

How to use Pans Excel in your AI agent

Install and use the Pans Excel skill in Claude Code, Cursor, Codex, Gemini CLI, OpenCode, and Windsurf — with sample prompts.

What you'll get

Pans Excel helps you work with spreadsheets without manual Excel work. Ask your AI assistant to create professional reports, add charts, clean messy data, or convert between formats. It handles everything from sales dashboards to financial statements, plus data validation and formatting.

Step 1 — Get the skill source URL

The Pans Excel skill lives at:

Step 2 — Add it to your AI agent

Copy one of these prompts and paste it into your AI tool. The agent will fetch and install the skill for you.

Claude Code

Add the agent skill from https://clawhub.ai/dashiming/pans-excel to my project.

Cursor

Install this agent skill: https://clawhub.ai/dashiming/pans-excel

Codex

Add this skill to .codex/skills/: https://clawhub.ai/dashiming/pans-excel

Gemini CLI

Add the skill at https://clawhub.ai/dashiming/pans-excel to my .gemini/skills/ directory.

OpenCode

Install this agent skill from https://clawhub.ai/dashiming/pans-excel

Windsurf

Add this skill: https://clawhub.ai/dashiming/pans-excel

Step 3 — Try these prompts

Once the skill is installed, ask your AI things like:

  • You need a sales dashboard or financial report but don't want to format it manually
  • You have messy data that needs cleaning, deduplication, or splitting into columns
  • Converting between spreadsheet formats (CSV to Excel, Excel to PDF)
  • You want professional charts and formatting without learning Excel formulas

What this skill does

  • Creates Excel files from data with professional formatting and color schemes
  • Generates 7 types of reports (sales dashboards, financial statements, project Gantt charts, reconciliation lists)
  • Adds 7 chart types (bar, line, pie, area, radar, combo, scatter) with custom styling
  • Cleans data by removing duplicates, filling blanks, trimming spaces, and converting formats
  • Converts between Excel, CSV, JSON, and PDF formats
  • Applies conditional formatting (heat maps, data bars, icons) and data validation rules
Made byClawHub Community
CategoryDocuments