Advanced CSV and Excel operations with GUI and CLI
A powerful Python tool for CSV/Excel file operations including merging, joining, unions, and conversions.
- 📊 CSV ↔ Excel Conversion: Seamless bidirectional conversion
- 🔀 Data Merging: Combine multiple CSV/Excel files
- 🔗 Join Operations: Inner, left, right, outer joins with key columns
- �� Union Operations: Combine files with same structure
- 📈 Auto Column Width: Automatic Excel column sizing
- 🎨 GUI Interface: User-friendly Tkinter GUI
- ⚡ CLI Tool: Command-line interface for automation
- 🌐 Web Interface: Optional Streamlit web app
# Install from wheel (recommended)
pip install dist/iloveexcel-*.whl
# Or install from source
pip install -e .GUI (Graphical Interface)
iloveexcelCLI (Command Line)
csvexcel --help
csvexcel convert input.csv output.xlsxWeb Interface (Optional)
pip install streamlit
streamlit run streamlit_app.py./scripts/build_wheel.sh./scripts/install_from_wheel.sh
# Or: pip install dist/iloveexcel-*.whl# Install with dev dependencies
pip install -e .[dev]
# Run tests
pytest
# Code formatting
black src/ tests/
# Type checking
mypy src/pytest tests/
pytest --cov=iLoveExcel tests/ # With coverage- Python: 3.10+
- Core Dependencies: pandas, openpyxl, xlsxwriter, click
- GUI: Tkinter (included with Python)
- Optional: streamlit (for web interface)
For detailed documentation, see:
README.detailed.md- Comprehensive guidecleanup/removed_files/docs_redundant/- Archived detailed docs- Examples in
examples/directory
Contributions are welcome! Please:
- Fork the repository
- Create a feature branch
- Make your changes
- Run tests:
pytest - Submit a pull request
MIT License - see LICENSE file for details
- Repository: https://github.com/monkcoders/iLoveExcel
- Issues: https://github.com/monkcoders/iLoveExcel/issues
Convert CSV to Excel:
from iLoveExcel import csv_to_excel
csv_to_excel("data.csv", "data.xlsx")Join Two CSV Files:
from iLoveExcel import join_csvs
join_csvs("file1.csv", "file2.csv", "output.csv",
join_key="id", join_type="inner")Launch GUI:
from iLoveExcel import launch_gui
launch_gui()Version: 0.1.0
Last Updated: November 2025