A simple desktop app that converts CSV files into formatted Excel (.xlsx) files.
- Upload any CSV file via file dialog
- Auto-adds a row number column (
No) if not present - Formats
amountcolumn with 2 decimal places and thousands separator - Styled Excel output:
- Blue header row with white bold text
- Alternating row fill colors
- Auto-sized column widths (max 40 characters)
- Frozen header row
- Thin cell borders
- Python 3.x
- pandas
- openpyxl
Install dependencies:
pip install pandas openpyxl
python csv2excel.py
- Open
run_csv2excel.batand set the paths:PYTHON_EXE— path to yourpython.exe(runwhere pythonin cmd to find it)SCRIPT— full path tocsv2excel.py
- Double-click
run_csv2excel.batto launch
- Open
run_csv2excel.shand set the paths:PYTHON_EXE— path to Python (runwhich python3in terminal)SCRIPT— full path tocsv2excel.py
- Make it executable and run:
chmod +x run_csv2excel.sh
./run_csv2excel.sh
- Click Upload CSV and select your CSV file
- Click Convert to Excel
- Choose where to save the output
.xlsxfile