A small GUI utility to merge, clean and generate PDF reports from Excel/CSV files ππ
Excel / CSV Automation Tool v1.0
π§° Built with Python & CustomTkinter
Source_File column)customtkinterπ Quick Start
pip install -r requirements.txt
Option 1: Direct Python (Always Works) π
python app.py
Option 2: Batch File Launcher π¨
Excel-CSV-Tool.bat
Option 3: Desktop Shortcut π±οΈ (Recommended)
Excel-CSV-Tool.lnk on your DesktopCopy and paste this in PowerShell:
$DesktopPath = [Environment]::GetFolderPath('Desktop')
$WshShell = New-Object -ComObject WScript.Shell
$Shortcut = $WshShell.CreateShortcut("$DesktopPath\Excel-CSV-Tool.lnk")
$Shortcut.TargetPath = "C:\Users\***\AppData\Local\Programs\Python\Python311\python.exe"
$Shortcut.Arguments = "`"c:\Users\***\OneDrive\Desktop\working projects by me\Excel csv work\app.py`""
$Shortcut.WorkingDirectory = "c:\Users\***\OneDrive\Desktop\***\Excel csv work"
$Shortcut.IconLocation = "C:\Users\***\AppData\Local\Programs\Python\Python311\python.exe,0"
$Shortcut.Save()
Write-Host "β
Desktop shortcut created successfully!"
C:\Users\****\AppData\Local\Programs\Python\Python311\python.exe "c:\Users\*****\OneDrive\Desktop\working projects by me\Excel csv work\app.py"
Excel-CSV-Tool πAlready created for you: Excel-CSV-Tool.bat
.bat file to run immediately!| π‘ Tip | Details |
|---|---|
| Pin to Taskbar | Right-click shortcut β Pin to Taskbar for quick access |
| Change Icon | Right-click β Properties β Change Icon (choose an icon from python.exe or custom .ico) |
| Run Minimized Console | Right-click β Properties β Advanced β Check βRun with reduced windowβ |
| Keyboard Shortcut | Right-click β Properties β Shortcut tab β Shortcut key (e.g., Ctrl+Alt+E) |
The app creates an output/ folder with timestamped subfolders for each run.
| β Issue | β Solution |
|---|---|
customtkinter import error |
Run: pip install customtkinter |
| Excel file wonβt open | Install: pip install openpyxl xlrd |
| PDF generation fails | Install: pip install fpdf2 |
| Shortcut wonβt work | Check Python path: python --version in PowerShell |
| βNo readable data foundβ | Ensure files have proper headers and data |
| Charts not displaying | Install: pip install matplotlib pillow |
All required packages are in requirements.txt:
pandas # π Data manipulation
matplotlib # π Chart generation
fpdf2 # π¨οΈ PDF creation
customtkinter # π₯οΈ GUI framework
openpyxl # π Excel support
xlrd # π Legacy Excel reader
Pillow # πΌοΈ Image handling
Install all at once:
pip install -r requirements.txt
This project is licensed under Creative Commons Attribution-NonCommercial 4.0 (CC BY-NC 4.0) π
See embedded license in app.py for full details.
| Command | Purpose |
|---|---|
python app.py |
π Launch the GUI |
Excel-CSV-Tool.bat |
π¨ Quick launcher (no terminal) |
Double-click Excel-CSV-Tool.lnk |
π±οΈ Desktop shortcut launch |
pip install -r requirements.txt |
π¦ Install dependencies |
πΉ Batch Processing: Select multiple CSV/Excel files at once for faster merging
πΉ Large Files: The tool handles thousands of rows efficiently
πΉ Custom Output: All reports are saved in organized timestamped folders
πΉ Reuse Sessions: Previous runs are accessible in the output/ folder
πΉ Keyboard Shortcuts: Set one up for lightning-fast access!