什么是 CSV 转 Excel 转换器？

CSV 转 Excel 转换器是一款专用工具，旨在弥补原始数据导出与演示就绪电子表格之间的差距。作为 Openclaw Skills 生态系统的一部分，它解决了常见痛点，如中文字符乱码、格式僵硬以及合并多个数据文件的繁琐过程。它自动处理包括 UTF-8 和 GBK 在内的各种编码，确保国际文本无需手动转换即可正确显示。

除了简单的文件转换外，该技能还应用了一套专业格式化规则。它为表头设置蓝色背景白色文字样式，添加单元格边框，冻结首行以便于导航，并根据内容智能计算列宽。这使其成为需要直接从自动化工作流交付高质量报告的开发人员和分析师的重要资产。

下载入口:https://github.com/openclaw/skills/tree/main/skills/xuanguan2020/csvtoexcel

安装与下载

1. ClawHub CLI

从源直接安装技能的最快方式。

2. 手动安装

将技能文件夹复制到以下位置之一

优先级：工作区 > 本地 > 内置

3. 提示词安装

将此提示词复制到 OpenClaw 即可自动安装。

CSV 转 Excel 转换器 应用场景

• 将旧版 CSV 数据转换为面向业务利益相关者的现代 Excel 工作簿。
• 将多个 CSV 报告（例如月度销售、库存和物流）合并为一个多工作表 Excel 文件。
• 解决处理中、日、韩文本时 Excel 中的字符编码问题。
• 自动化生成带有冻结表头和自动调整列宽的格式化电子表格。

1. 用户提供一个或多个 CSV 文件作为转换脚本的输入。
2. 该技能执行自动编码检测，循环尝试 UTF-8、GBK 和其他格式以确保数据完整性。
3. 使用 openpyxl 引擎初始化一个新的 Excel 工作簿。
4. 每个输入文件都作为独立的工作表进行处理，该技能会自动检测分隔符和引用字段。
5. 对每个工作表应用专业样式，包括颜色代码表头、单元格边框和计算出的列宽。
6. 生成最终的 .xlsx 文件并保存到指定的输出路径。

CSV 转 Excel 转换器 配置指南

要在 Openclaw Skills 框架内使用此功能，必须先安装所需的 Python 依赖项：

pip install openpyxl

安装完成后，您可以直接从终端运行脚本：

# 基础转换
python scripts/csv_to_excel.py input.csv output.xlsx

# 具有自定义工作表名称的多文件转换
python scripts/csv_to_excel.py file1.csv file2.csv --output combined.xlsx --sheet-names "SheetA" "SheetB"

CSV 转 Excel 转换器 数据架构与分类体系

该技能根据以下元数据和格式化架构转换数据：

name: csv-to-excel description: "Convert CSV files to professionally formatted Excel workbooks with Chinese character support, automatic formatting, and multi-sheet capabilities. Use when users need to: (1) Convert single CSV to Excel, (2) Combine multiple CSV files into one Excel with separate sheets, (3) Format CSV data with headers, borders, and auto-adjusted columns, (4) Handle Chinese or other non-ASCII characters in CSV files, or (5) Create professional Excel reports from CSV data."

CSV To Excel Converter

Overview

This skill enables conversion of CSV files to Excel format with professional formatting, proper encoding handling for Chinese characters, and support for combining multiple CSV files into a single Excel workbook with separate sheets.

Quick Start

Use the csv_to_excel.py script for all conversions:

# Single CSV to Excel
python scripts/csv_to_excel.py input.csv output.xlsx

# Multiple CSVs to one Excel (each becomes a sheet)
python scripts/csv_to_excel.py file1.csv file2.csv file3.csv --output combined.xlsx

# With custom sheet names
python scripts/csv_to_excel.py sales.csv inventory.csv --output report.xlsx --sheet-names "销售数据" "库存数据"

Features

Automatic Encoding Detection

• Detects CSV encoding automatically (UTF-8, GBK, GB2312, UTF-8-SIG)
• Ensures Chinese characters display correctly in Excel
• No manual encoding specification needed

Professional Formatting

• Header row: Bold white text on blue background
• Borders: Thin borders around all cells
• Column widths: Auto-adjusted based on content (handles Chinese characters properly)
• Frozen panes: Header row frozen for easy scrolling
• Alignment: Headers centered

Multi-Sheet Support

• Combine multiple CSV files into one Excel workbook
• Each CSV becomes a separate sheet
• Custom sheet names supported
• Sheet names default to CSV filenames (max 31 characters)

Common Usage Patterns

Pattern 1: Single File Conversion

User says: "Convert this data.csv to Excel"

python scripts/csv_to_excel.py data.csv data.xlsx

Pattern 2: Multiple Files to Multi-Sheet Excel

User says: "Combine these CSV files into one Excel, each file as a separate sheet"

python scripts/csv_to_excel.py sales_2024.csv sales_2025.csv inventory.csv --output report.xlsx

Result: report.xlsx with 3 sheets named "sales_2024", "sales_2025", "inventory"

Pattern 3: Custom Sheet Names

User says: "Create an Excel with these CSVs and name the sheets in Chinese"

python scripts/csv_to_excel.py q1.csv q2.csv q3.csv q4.csv --output 年度报告.xlsx --sheet-names "第一季度" "第二季度" "第三季度" "第四季度"

Pattern 4: Handling Chinese Content

User says: "This CSV has Chinese text and it shows as garbled characters in Excel"

The script automatically detects encoding and handles Chinese characters:

python scripts/csv_to_excel.py 中文数据.csv 输出.xlsx

Technical Details

Encoding Support

The script tries these encodings in order:

1. UTF-8
2. GBK (common for Chinese Windows)
3. GB2312 (simplified Chinese)
4. UTF-8-SIG (UTF-8 with BOM)
5. Latin1 (fallback)

CSV Dialect Detection

• Automatically detects delimiter (comma, semicolon, tab, etc.)
• Handles quoted fields
• Works with various CSV formats

Column Width Calculation

• Chinese characters counted as 2 width units
• ASCII characters counted as 1 width unit
• Maximum width capped at 50 for readability
• Adds 2 units padding for visual comfort

Dependencies

The script requires openpyxl:

pip install openpyxl

Troubleshooting

Issue: Chinese characters still appear garbled

• Solution: The CSV file may have a rare encoding. Try converting the CSV to UTF-8 first using a text editor.

Issue: Sheet name error

• Solution: Excel sheet names must be ≤31 characters. The script auto-truncates, but you can specify shorter custom names.

Issue: Empty sheets created

• Solution: Check that CSV files are not empty and are properly formatted.

Issue: Script not found

• Solution: Run the script from the skill directory or use the full path: python .kiro/skills/csv-to-excel/scripts/csv_to_excel.py