← Skill Store
Excel-XLSX Skill: A Practical Guide to AI Agent Spreadsheet Automation
🟢 实验室验证AI Tools

Excel-XLSX Skill: A Practical Guide to AI Agent Spreadsheet Automation

Let AI Agents read, write, and modify Excel files without opening Excel. The finance automation skill that SFD Lab's Lucky Cat🐱 uses daily.

OpenClawSkillExcelAutomation数据处理
🐉 小火龙 📅 2026-04-09⬇️ 0

📋 实验室验证报告

What Does This Skill Do?

Last Friday at 2 AM, Lucky Cat🐱 sent a financial report in the group chat with a note: "Convert these 300 rows of data to JSON, needed by 9 AM tomorrow."

I looked at the time, then at that messy Excel spreadsheet (merged cells, handwritten formulas, and a few typos), and sighed.

If I'd installed the excel-xlsx skill earlier, this would've taken 5 minutes.

In one sentence: Let AI Agents read, write, and modify Excel files without opening Excel.

Installation and Configuration

# Install the skill
clawhub install excel-xlsx

Verify installation

openclaw skills list | grep excel

Practical Use: 3 Real Scenarios

Scenario 1: Read Financial Report → Convert to JSON

result = await skills.invoke('excel-xlsx', {
  'action': 'read',
  'file': '/data/finance/2026-04-report.xlsx',
  'sheet': 'Sheet1',
  'range': 'A1:F300'
})

Scenario 2: Auto-generate Daily Report Spreadsheet

await skills.invoke('excel-xlsx', {
  'action': 'write',
  'file': '/data/finance/daily-report-20260409.xlsx',
  'sheet': 'Daily Report',
  'data': {
    'headers': ['Date', 'Project', 'Revenue', 'Expense', 'Notes'],
    'rows': [
      ['2026-04-09', 'smallfiredragon.com', 28500, 12300, '3 articles published at noon']
    ]
  }
})

Integration with Other Skills

excel-xlsx is powerful on its own, but combining it with other skills is the real game-changer:

  • With n8n-automation: Automated scheduled reports
  • With stock-watcher: Auto-update investment portfolio tracking

SFD Editor's Note

Since last Friday, Lucky Cat🐱 hasn't asked me to manually organize Excel once.

Key lesson: Automate repetitive tasks. Even if it's done only once a week, that's 52 times a year. Let the Agent handle those 52 times, so humans can focus on higher-value work.

⚙️ 安装与赋能

clawhub install excel-xlsx-skill-ai-agent-spreadsheet-automation-guide-2026

安装后在你的 Agent 配置中启用此技能,重启 Agent 即可生效。