An automated utility to consolidate multiple Excel sheets into a single, structured summary by dynamically matching key fields, filtering noise, and aggregating values.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install excel-multi-table-merge
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install excel-multi-table-merge using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Excel Multi-Table Merge Tool?
The Excel Multi-Table Merge Tool is designed to address a common administrative bottleneck: manually consolidating various shipping lists, delivery sheets, or inventory summaries spread across multiple sheets in a single workbook. Built to handle realistic file discrepancies, this skill dynamically identifies varying header structures, parses calculated values instead of raw formulas, and groups similar components systematically.
By deploying this automation, developers and operators can easily filter out irrelevant structural noise (such as administrative rows, taxes, or packaging notes) and consolidate item quantities automatically. As a standout tool in the library of Openclaw Skills, it provides a programmatic, openpyxl-driven solution to replace hours of error-prone manual copy-pasting.
Excel Multi-Table Merge Tool Use Cases
- Consolidating multiple monthly shipping manifests or delivery notes into a single master ledger.
- Merging manufacturing or material lists where column layouts vary slightly between sheets.
- Standardizing and cleaning engineering component schedules (sorting beams, columns, plates) while filtering out accessory hardware like bolts and brackets.
- Extracting final calculated results from complex spreadsheets containing embedded Excel formulas.
How Excel Multi-Table Merge Tool Works
- Load Workbook with Data Resolution: The utility loads the Excel workbook using openpyxl in
data_only=Truemode to ensure formula cells are read as their final calculated values. - Dynamic Header Analysis: It scans the first few rows of each worksheet to identify the correct header row containing key columns like '序号' (Serial No.), and determines column mappings for Item Name, Specifications, Pieces, and Quantity.
- Data Filtering and Parsing: The tool processes rows, skipping packaging or administrative noise, and filters out configured irrelevant items (e.g., brackets, expansion bolts).
- Aggregation: Matching records are consolidated based on a unique tuple of Name and Specification, grouping pieces and summing quantities.
- Priority Sorting and Exporting: Items are sorted by specific structural prefixes and written to a fresh, beautifully formatted workbook complete with professional cell alignments, custom widths, and table borders.
Excel Multi-Table Merge Tool Setup
Ensure you have Python installed, along with the required openpyxl library. You can install the dependencies and deploy this component from Openclaw Skills easily.
# Install the openpyxl library
pip install openpyxl
Save the core merge script to your workspace, then execute it against your target Excel files:
# Example invocation
python excel_multi_table_merge.py
Excel Multi-Table Merge Tool Data Schema & Taxonomy
The input data dynamically detects column structures. However, the output consolidated file conforms to a strict, standardized format:
Consolidated Sheet Data Model
| Column | Header Name | Description |
|---|---|---|
| A | 序号 (Index) | Incremental serial number starting from 1 |
| B | 项目名称及特征 (Project Name & Features) | Standardized item name consolidated across sheets |
| C | 生产规格 (Production Specifications) | Specification or sizing description |
| D | 合计件数 (Total Pieces) | Summed integer or floating count of pieces |
| E | 合计数量 (Total Quantity) | Summed physical volume/length, rounded to 2 decimal places |
Filter Configuration
- Ignore Keywords:
['支架', '膨胀', '螺丝', '镀锌'](Brackets, Expansion Bolts, Screws, Galvanized accessories) - Skip Rows:
['包装', '合计', '税金', '总计', '说明', '甲方', '现场', '施工', '制单人'](Administrative metadata and totals)
Excel Multi-Table Merge Tool Advanced Features
- Calculated Value Extraction: Configured to read final computed values under
data_only=Trueinstead of formula text. - Custom Priority Sorting: Orders output rows dynamically based on domain-specific keyword weight (e.g., sorting beams '梁' and columns '柱' first).
- Structural Cleaning Rules: Built-in automated ignore filters block mechanical noise and metadata rows, transforming raw shipping sheets into a clean analytical database.
- Adaptive Indexing: Dynamic structural detection allows the tool to run successfully even when source sheets have varied column indices.
SKILL.md
Loading
Related Openclaw Skills
AutoGLM File Upload
Automates local file uploads to the AutoGLM server to provide resource URLs for multi-agent workflows.
BlackClaw RWA Tokenization Advisor
A multi-jurisdictional Real-World Asset (RWA) tokenization consultant agent designed to architect legally compliant and commercially viable asset-backed token structures.
AutoGLM Image Recognition
An advanced image analysis and OCR skill leveraging the AutoGLM API to automatically describe images and extract text from public URLs or local files.
GitHub CLI
A high-performance Openclaw Skills integration for executing GitHub operations like PR checks, runner logs, and custom API queries using the gh CLI.
Gingiris Growth Finder
A high-performance meta-router that diagnoses product growth bottlenecks and dynamically invokes the precise marketing and launch playbooks.
SEO & GEO Dual-Engine Playbook (gingiris-seo-geo)
A dual-engine SEO and GEO growth playbook designed to get your content ranked on traditional search engines while maximizing citations in AI search engines.
Featured*
