Excel Batch Merge Skill Usage Guide: Merge 100 Tables in 3 Minutes

Hello everyone, I'm Programmer Wanfeng, practicing various AI projects.

At the end of every month, finance, operations, and sales people all need to do one thing: merge dozens or even hundreds of Excel files into one.

Before, using Python to write code? Too complicated.
Now, install Excel Batch Merge Skill, done in 3 minutes.

---

1. Skill Introduction

Function Overview

Excel Batch Merge Skill can:

• ✅ Merge multiple Excel files into one
• ✅ Auto-recognize headers, intelligently align columns
• ✅ Support sorting by specified columns
• ✅ Support deduplication, filtering
• ✅ Preserve original formatting

Applicable Scenarios

Scenario	Example
Monthly report summary	Merge 30 daily sales reports
Data cleaning	Merge data files from multiple departments
Historical data archiving	Merge data from all years into one file
Data migration	Merge multiple files exported from old system

---

2. Install Skill

Coze Installation

1. Open Coze Official Website
2. Enter "Skill Store"
3. Search "Excel Batch Merge"
4. Click "Install"

OpenClaw Installation

openclaw skills install excel-tools

Feishu CLI

Feishu CLI doesn't support Excel processing yet, recommend using with Coze or OpenClaw.

---

3. Usage Tutorial

Basic Usage: Merge Multiple Files

Step 1: Prepare files
Put the Excel files to merge in the same folder, for example:

/data/
  ├── 2024-01-sales-data.xlsx
  ├── 2024-02-sales-data.xlsx
  ├── 2024-03-sales-data.xlsx
  └── ...

Step 2: Tell AI your needs

You: Help me merge all Excel files in /data/ directory into one

AI: I'll help you merge Excel files.
🔧 Using skill: excel-tools


## 🎓 AI 编程实战课程

想系统学习 AI 编程？程序员晚枫的 **AI 编程实战课** 帮你从零上手！

- 👉 **课程报名**：[点击这里报名，前3讲免费试听](https://r7up9.xetslk.com/s/1uP5YW)
- 👉 **免费试看**：[B站免费试看前3讲，先看看适不适合自己](https://www.bilibili.com/cheese/play/ss982042944)