simple-excel

简单的 Excel 文件处理工具。用于读取、创建、编辑 .xlsx 和 .csv 文件,适合基本的数据操作任务,如读取数据、简单计算、生成表格等。

3,891 stars

Best use case

simple-excel is best used when you need a repeatable AI agent workflow instead of a one-off prompt.

简单的 Excel 文件处理工具。用于读取、创建、编辑 .xlsx 和 .csv 文件,适合基本的数据操作任务,如读取数据、简单计算、生成表格等。

Teams using simple-excel should expect a more consistent output, faster repeated execution, less prompt rewriting.

When to use this skill

  • You want a reusable workflow that can be run more than once with consistent structure.

When not to use this skill

  • You only need a quick one-off answer and do not need a reusable workflow.
  • You cannot install or maintain the underlying files, dependencies, or repository context.

Installation

Claude Code / Cursor / Codex

$curl -o ~/.claude/skills/simple-excel/SKILL.md --create-dirs "https://raw.githubusercontent.com/openclaw/skills/main/skills/anmu14641/simple-excel/SKILL.md"

Manual Installation

  1. Download SKILL.md from GitHub
  2. Place it in .claude/skills/simple-excel/SKILL.md inside your project
  3. Restart your AI agent — it will auto-discover the skill

How simple-excel Compares

Feature / Agentsimple-excelStandard Approach
Platform SupportNot specifiedLimited / Varies
Context Awareness High Baseline
Installation ComplexityUnknownN/A

Frequently Asked Questions

What does this skill do?

简单的 Excel 文件处理工具。用于读取、创建、编辑 .xlsx 和 .csv 文件,适合基本的数据操作任务,如读取数据、简单计算、生成表格等。

Where can I find the source code?

You can find the source code on GitHub using the link provided at the top of the page.

Related Guides

SKILL.md Source

# Simple Excel - 简化版 Excel 处理

## 快速开始

### 读取 Excel 文件
```python
import pandas as pd

# 读取 xlsx 或 csv
df = pd.read_excel('file.xlsx')
df = pd.read_csv('file.csv')

# 读取指定sheet
df = pd.read_excel('file.xlsx', sheet_name='Sheet1')
```

### 写入 Excel 文件
```python
import pandas as pd

# 保存为 xlsx
df.to_excel('output.xlsx', index=False)

# 保存为 csv
df.to_csv('output.csv', index=False)
```

### 简单数据处理
```python
import pandas as pd

# 筛选数据
df[df['列名'] > 10]

# 添加新列
df['新列'] = df['列1'] + df['列2']

# 分组统计
df.groupby('类别').sum()

# 排序
df.sort_values('金额', ascending=False)
```

## 常用操作

| 操作 | 代码 |
|------|------|
| 查看前几行 | `df.head()` |
| 查看数据类型 | `df.dtypes` |
| 统计摘要 | `df.describe()` |
| 选择列 | `df[['列A', '列B']]` |
| 筛选行 | `df[df['列'] > 100]` |
| 删除列 | `df.drop('列名', axis=1)` |
| 重命名列 | `df.rename(columns={'旧名': '新名'})` |
| 填充空值 | `df.fillna(0)` |
| 导出指定sheet | `df.to_excel('file.xlsx', sheet_name='新sheet')` |

## 注意事项

- 使用 `index=False` 避免导出索引列
- 中文字符在 Excel 中通常能正常显示
- 大文件建议使用 csv 格式

Related Skills

simple-tech-analyzer - 简易技术分析器

3891
from openclaw/skills

**版本**: 1.0.0

Finance & Trading

excel-finance

3891
from openclaw/skills

Excel 财务模型技能 - Excel 财务模型模板、自动化报表生成

excel-data-import

3891
from openclaw/skills

Import, merge, and transform data from Excel (.xlsx/.csv) files using YAML-driven configuration. Use when the user asks to: (1) import data from Excel/CSV into a template, (2) batch-process multiple files in a directory, (3) merge/consolidate data from multiple sources, (4) map and transform columns with validation rules, (5) do incremental data updates on existing spreadsheets. 当用户要求导入Excel、CSV导入、表格数据导入、Excel数据合并、批量处理Excel、字段映射、数据校验、 表头自动检测、增量更新Excel、多sheet合并时使用此技能。 Supports Chinese field names, multi-layer merged cell headers, auto header detection, CSV (auto-encoding), custom validators, and multi-source imports.

Excel

3891
from openclaw/skills

The Spreadsheet Operator. Not a tutorial, but a diagnostic engine. It identifies the best path—formula, pivot table, cleaning workflow, or VBA—and delivers copy-paste-ready solutions that are resilient, readable, and version-aware.

li-etl-handle-safe - 安全版 Excel/CSV ETL 处理技能

3891
from openclaw/skills

## 功能描述

---

3891
from openclaw/skills

name: article-factory-wechat

Content & Documentation

humanizer

3891
from openclaw/skills

Remove signs of AI-generated writing from text. Use when editing or reviewing text to make it sound more natural and human-written. Based on Wikipedia's comprehensive "Signs of AI writing" guide. Detects and fixes patterns including: inflated symbolism, promotional language, superficial -ing analyses, vague attributions, em dash overuse, rule of three, AI vocabulary words, negative parallelisms, and excessive conjunctive phrases.

Content & Documentation

find-skills

3891
from openclaw/skills

Helps users discover and install agent skills when they ask questions like "how do I do X", "find a skill for X", "is there a skill that can...", or express interest in extending capabilities. This skill should be used when the user is looking for functionality that might exist as an installable skill.

General Utilities

tavily-search

3891
from openclaw/skills

Use Tavily API for real-time web search and content extraction. Use when: user needs real-time web search results, research, or current information from the web. Requires Tavily API key.

Data & Research

baidu-search

3891
from openclaw/skills

Search the web using Baidu AI Search Engine (BDSE). Use for live information, documentation, or research topics.

Data & Research

agent-autonomy-kit

3891
from openclaw/skills

Stop waiting for prompts. Keep working.

Workflow & Productivity

Meeting Prep

3891
from openclaw/skills

Never walk into a meeting unprepared again. Your agent researches all attendees before calendar events—pulling LinkedIn profiles, recent company news, mutual connections, and conversation starters. Generates a briefing doc with talking points, icebreakers, and context so you show up informed and confident. Triggered automatically before meetings or on-demand. Configure research depth, advance timing, and output format. Walking into meetings blind is amateur hour—missed connections, generic small talk, zero leverage. Use when setting up meeting intelligence, researching specific attendees, generating pre-meeting briefs, or automating your prep workflow.

Workflow & Productivity