csv-to-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