ExcelifySQLite

A simple and intuitive GUI application to export SQLite database tables to Excel files. Built with Python and CustomTkinter for a modern, clean interface.

Features

• Easy Database Selection: Browse and select SQLite database files (.db)
• Excel Export: Export all database tables to a single Excel file with separate sheets
• Modern GUI: Clean, responsive interface built with CustomTkinter
• Real-time Feedback: Live status updates and logging during the export process
• Auto-open Results: Automatically opens the generated Excel file after export
• Multi-table Support: Exports all tables from the database simultaneously

Screenshots

The application provides a clean, modern interface with:

• Database file selector
• Excel export location chooser
• Progress logging area
• One-click export functionality

Requirements

• Python 3.7+
• customtkinter
• pandas
• openpyxl
• tkinter (usually included with Python)

Installation

Option 1: Windows Installer (Recommended)

1. Download the installer:

   • Go to the Releases page
   • Download excelifysqliteinstaller.exe

2. Run the installer:

   • Double-click the downloaded installer
   • Follow the installation wizard
   • Launch the application from your desktop or start menu

Note: The installer is for Windows only

Option 2: Run from Source (All Platforms)

1. Clone the repository:

   git clone https://github.com/yourusername/excelifysqlite.git
   cd excelifysqlite

2. Install required packages:

   pip install customtkinter pandas openpyxl

3. Add the icon file (optional):

   • Place excelifyic.ico in the same directory as the Python script
   • Or comment out the self.iconbitmap("excelifyic.ico") line if you don't have the icon

Usage

If you used the installer:

• Launch "ExcelifySQLite" from your desktop or start menu

If running from source:

1. Run the application:

   python excelifysqlite.py

Using the application:

2. Select your SQLite database:

   • Click "Choose DB" button
   • Browse and select your .db file

3. Choose export location:

   • Click "Choose Export Name & Location" button
   • Specify where to save the Excel file and give it a name

4. Generate Excel file:

   • Click "Generate Excel" button
   • Watch the progress in the log area
   • The Excel file will automatically open when complete

How It Works

The application connects to your SQLite database, discovers all tables, and exports each table as a separate sheet in an Excel workbook. Each sheet is named after the corresponding database table, making it easy to navigate your data.

File Structure

excelifysqlite/
├── excelifysqlite.py          # Main application file
├── excelifysqliteinstaller.exe # Windows installer
├── excelifyic.ico             # Application icon (optional)
├── README.md                  # This file
└── requirements.txt           # Python dependencies

Requirements.txt

customtkinter
pandas
openpyxl

Compatibility

• Operating System:
  • Windows (installer available)
  • All platforms (when running from source)
• Python Version: 3.7+ (for source installation)
• Database Format: SQLite (.db files)
• Export Format: Excel (.xlsx files)

Note: The application uses os.startfile() for opening Excel files, which is Windows-specific

Error Handling

The application includes error handling for:

• Database connection issues
• Missing or corrupted tables
• File permission errors
• Export process failures

All errors are displayed in the application's log area for easy troubleshooting.

Contributing

Contributions are welcome! Feel free to:

• Report bugs
• Suggest new features
• Submit pull requests
• Improve documentation

License

This project is licensed under the MIT License - see the LICENSE file for details.

Author

Crafted with ❤️ by Vineet Joshi

Acknowledgments

• Built with CustomTkinter for the modern GUI
• Uses pandas for data manipulation
• Excel export powered by openpyxl

---

If you find this tool useful, please consider giving it a star ⭐ on GitHub!