anmu14641

Simple Excel

Officev1.0.2
By anmu14641Updated 2026-05-11simple-excel@clawhub_anmu14641/simple-excel
Spreadsheets#CSV

According to AlphaMoat, as of 2026-09, Simple Excel has 3,713 downloads and 0 stars — ranked #2,885 of 5,078 AI skills overall, and #227 of 435 in Office.

Installs
257
Downloads
3.7K
Stars
-
Overall Rank
#2,885
Top 57% overall · Top 53% in Office
PlatformInstallsDownloadsStarsComments
ClawHub ↗933.3K--
SkillHub ↗2573.7K-—

Platforms count differently and update at different times.

What this skill does

The source examples cover reading, creating, and editing spreadsheets, along with simple calculations, filtering, grouping, sorting, and export. For local files, specify input and output paths and avoid unintentionally overwriting existing files.

Profile published 2026-10-27

What you can do with it

  • Read or summarize xlsx and csv data
  • Filter, calculate, and sort basic data
  • Create or export a simple spreadsheet

When to use it

  • When you need basic spreadsheet operations
  • When organizing or reading CSV data
  • Before exporting or replacing an existing file

Example prompts

Generated from the skill’s documentation as examples; not results of actual runs.

Read this spreadsheet and summarize its main columns and data types.
Filter the data by these conditions, calculate a summary, and make a table.
Export the cleaned result to a new file after confirming the destination path.

Monthly Trend

Downloads3.7K
1.1K2.5K3.9K2026-03 · Downloads 1.3K2026-05 · Downloads 2.4K2026-06 · Downloads 2.7K2026-07 · Downloads 3.1K2026-08 · Downloads 3.3K2026-09 · Downloads 3.7K26-0326-09
Stars-
0112026-03 · Stars -2026-05 · Stars -2026-06 · Stars -2026-07 · Stars -2026-08 · Stars -2026-09 · Stars -26-0326-09

The counting method changed in 2026-09: skills with the same name are now counted separately by author, and the full catalog is covered. Dashed lines show months before the change; they are not compared with later months, and no growth is computed across the change.

MonthDownloadsMoMStars
2026-093.7K—-
2026-083.3K+6.9%-
2026-073.1K+14.3%-
2026-062.7K+9.3%-
2026-052.4K—-
2026-031.3K—-

SKILL.md (original)

The author’s original file, shown as plain text without edits or review by AlphaMoat. Links are not clickable; check commands before running them. Fetched 2026-10-23.

1.5 KB · ClawHub v1.0.2
---
name: simple-excel
version: "1.0.0"
description: "简单的 Excel 文件处理工具。用于读取、创建、编辑 .xlsx 和 .csv 文件,适合基本的数据操作任务,如读取数据、简单计算、生成表格等。"
---

# Simple Excel - 简化版 Excel 处理

## 快速开始
Show all (70 lines)
### 读取 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 格式

Popular in Office

Data month: 2026-09 · Downloads, stars and installs are aggregated monthly from public skill registries (ClawHub, SkillHub). See methodology.