Requirements
- Target platform
- OpenClaw
- Install method
- Manual import
- Extraction
- Extract archive
- Prerequisites
- OpenClaw
- Primary doc
- SKILL.md
Tencent SkillHub · Data Analysis
csv to excel
Convert CSV files to professionally formatted Excel workbooks with Chinese character support, automatic formatting, and multi-sheet capabilities. Use when us...
skill openclawclawhub Free
Convert CSV files to professionally formatted Excel workbooks with Chinese character support, automatic formatting, and multi-sheet capabilities. Use when us...
⬇ 0 downloads ★ 0 stars Unverified but indexed
Install for OpenClaw
Quick setup
- Download the package from Yavira.
- Extract the archive and review SKILL.md first.
- Import or place the package into your OpenClaw setup.
Package facts
- Download mode
- Yavira redirect
- Package format
- ZIP package
- Source platform
- Tencent SkillHub
- What's included
- SKILL.md, scripts/csv_to_excel.py
Validation
- Use the Yavira download entry.
- Review SKILL.md after the package is downloaded.
- Confirm the extracted package contains the expected setup assets.
Install with your agent
Agent handoff
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
- Download the package from Yavira.
- Extract it into a folder your agent can access.
- Paste one of the prompts below and point your agent at the extracted folder.
New install
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.
Upgrade existing
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.
Trust & source
Release facts
- Source
- Tencent SkillHub
- Verification
- Indexed source record
- Version
- 1.0.0
Provenance
- Publisher
- xuanguan2020
- Source page
- View original listing
- Canonical URL
- Open canonical page
Documentation
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 "销售数据" "库存数据"
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)
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
Encoding Support
The script tries these encodings in order: UTF-8 GBK (common for Chinese Windows) GB2312 (simplified Chinese) UTF-8-SIG (UTF-8 with BOM) 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
Category context
Data access, storage, extraction, analysis, reporting, and insight generation.
Source: Tencent SkillHub
Largest current source with strong distribution and engagement signals.
Package contents
Included in package
1 Docs1 Scripts
- SKILL.md
- scripts/csv_to_excel.py