A robust utility to transform raw CSV files into polished, multi-sheet Excel workbooks with automatic encoding detection and professional styling.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install csvtoexcel
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 csvtoexcel 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 CSV to Excel Converter?
The CSV to Excel Converter is a specialized tool designed to bridge the gap between raw data exports and presentation-ready spreadsheets. As part of the Openclaw Skills ecosystem, it addresses common pain points such as garbled Chinese characters, rigid formatting, and the tedious process of merging multiple data files. It automatically handles various encodings including UTF-8 and GBK, ensuring that international text is displayed correctly without manual conversion.
Beyond simple file conversion, this skill applies a suite of professional formatting rules. It styles headers with white text on a blue background, adds cell borders, freezes the top row for easier navigation, and intelligently calculates column widths based on content. This makes it an essential asset for developers and analysts who need to deliver high-quality reports directly from their automated workflows.
CSV to Excel Converter Use Cases
- Converting legacy CSV data into modern Excel workbooks for business stakeholders.
- Merging several CSV reports (e.g., monthly sales, inventory, and logistics) into a single, multi-sheet Excel file.
- Fixing character encoding issues in Excel when dealing with Chinese, Japanese, or Korean text.
- Automating the generation of formatted spreadsheets with frozen headers and auto-adjusted columns.
How CSV to Excel Converter Works
- The user provides one or more CSV files as input to the conversion script.
- The skill performs automatic encoding detection, cycling through UTF-8, GBK, and other formats to ensure data integrity.
- A new Excel workbook is initialized using the openpyxl engine.
- Each input file is processed as a separate sheet, with the skill automatically detecting delimiters and quoted fields.
- Professional styling is applied to every sheet, including color-coded headers, cell borders, and calculated column widths.
- The final .xlsx file is generated and saved to the specified output path.
CSV to Excel Converter Setup
To use this feature within the Openclaw Skills framework, you must first install the required Python dependency:
pip install openpyxl
Once installed, you can run the script directly from your terminal:
# Basic conversion
python scripts/csv_to_excel.py input.csv output.xlsx
# Multi-file conversion with custom sheet names
python scripts/csv_to_excel.py file1.csv file2.csv --output combined.xlsx --sheet-names "SheetA" "SheetB"
CSV to Excel Converter Data Schema & Taxonomy
The skill transforms data according to the following metadata and formatting schema:
| Property | Specification |
|---|---|
| Output Format | Excel Workbook (.xlsx) |
| Sheet Limits | Sheet names truncated to 31 characters (Excel standard) |
| Styling | Bold white text on blue background for headers; centered alignment |
| Layout | Frozen top row; thin borders on all active cells |
| Width Calculation | Chinese characters (2 units), ASCII (1 unit), max width 50 |
| Encodings | UTF-8, GBK, GB2312, UTF-8-SIG, Latin1 |
CSV to Excel Converter Advanced Features
- Smart Encoding Detection: Automatically resolves issues with Chinese characters and non-ASCII text without user input.
- Multi-Sheet Consolidation: Combine an unlimited number of CSV files into a single workbook with distinct tab naming.
- Intelligent Auto-Sizing: Calculates visual width for both standard and double-byte characters to ensure columns are perfectly fitted.
- CLI Integration: Designed to be called as a subprocess within larger Openclaw Skills automation pipelines for batch processing.
SKILL.md
Loading
Related Openclaw Skills
OpenClaw Skill Manager
A powerful command-line utility for discovering, installing, and configuring additional capabilities for OpenClaw agents.
ComfyUI Runner
A streamlined utility for programmatically managing the lifecycle and health of local ComfyUI servers.
comfyui-request
A bridge between AI agents and ComfyUI that allows users to programmatically trigger workflows and retrieve generated image assets.
Stealth Browser
A high-performance web navigation tool designed to bypass advanced anti-bot systems using stealth-optimized browser instances.
Requirements Analysis Expert
A specialized AI skill that transforms high-level ideas into comprehensive technical specifications through guided dialogue and industry-standard frameworks.
Trip Assistant
A conversational AI agent for seamless querying and booking of flights, trains, and hotels using natural language.
Featured*
