Skip to content

README.md

Latest commit

 

History

History
60 lines (43 loc) · 1.33 KB

README.md

File metadata and controls

60 lines (43 loc) · 1.33 KB

CSV to Excel Converter

A simple desktop app that converts CSV files into formatted Excel (.xlsx) files.

Features

  • Upload any CSV file via file dialog
  • Auto-adds a row number column (No) if not present
  • Formats amount column 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

Requirements

  • Python 3.x
  • pandas
  • openpyxl

Install dependencies:

pip install pandas openpyxl

Usage

Run directly with Python

python csv2excel.py

Run with the batch file (Windows)

  1. Open run_csv2excel.bat and set the paths:
    • PYTHON_EXE — path to your python.exe (run where python in cmd to find it)
    • SCRIPT — full path to csv2excel.py
  2. Double-click run_csv2excel.bat to launch

Run with the shell script (macOS/Linux)

  1. Open run_csv2excel.sh and set the paths:
    • PYTHON_EXE — path to Python (run which python3 in terminal)
    • SCRIPT — full path to csv2excel.py
  2. Make it executable and run:
chmod +x run_csv2excel.sh
./run_csv2excel.sh

How to Use the App

  1. Click Upload CSV and select your CSV file
  2. Click Convert to Excel
  3. Choose where to save the output .xlsx file