🧠 CSV ↔ Excel Cheatsheet
⚙️ PowerShell
powershell
Install-Module ImportExcel -Scope CurrentUser -Force
Import-Csv -Path result.csv | Export-Excel -Path result.xlsx -AutoSize -WorksheetName "Sheet1"🐍 Python (Pandas)
python
import pandas as pd
# CSV → XLSX
df = pd.read_csv("input.csv", encoding="utf-8")
df.to_excel("output.xlsx", index=False)
# XLSX → CSV
df = pd.read_excel("input.xlsx")
df.to_csv("output.csv", index=False, encoding="utf-8")
# CSV UTF-8 → CSV GBK
df = pd.read_csv("input_utf8.csv", encoding="utf-8")
df.to_csv("output_gbk.csv", index=False, encoding="gbk")🛠 CMD + LibreOffice
cmd
"C:\Program Files\LibreOffice\program\soffice.exe"
soffice.exe --headless --convert-to xlsx:"Calc MS Excel 2007 XML" input.csv
soffice.exe --headless --convert-to "csv:Text - CSV (.csv):44,34,GBK" input_utf8.csv🔄 Pandoc
bash
# install pandoc
scoop install pandoc
# CSV → XLSX (via intermediate Markdown)
pandoc input.csv -f csv -t markdown -o temp.md
pandoc temp.md -f markdown -t xlsx -o output.xlsx
# XLSX → CSV (via intermediate Markdown)
pandoc input.xlsx -f xlsx -t markdown -o temp.md
pandoc temp.md -f markdown -t csv -o output.csv📦 Summary
| Task | Tool/Command |
|---|---|
| CSV → XLSX | PowerShell / Pandas / LibreOffice / Pandoc |
| XLSX → CSV | Pandas / LibreOffice / Pandoc |
| CSV UTF-8 → CSV GBK | Pandas / LibreOffice |
| Headless Batch Convert | LibreOffice |
| Markdown Bridge | Pandoc |