
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.
📋 实验室验证报告
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 即可生效。