Create an advanced GUI app with PySimpleGUI (Full Tutorial)

In this tutorial, I'm going to walk you through the process of creating a GUI app with Python. I'll show you how to create an advanced Graphical User Interface complete with buttons, input boxes, user settings and a custom menu bar. I'll start with a simple GUI app that has just two buttons. Then, we'll create a more advanced GUI app to retrieve and save user settings. Finally, we will implement a custom menu bar and convert our code into a standalone executable file.

In the final application, you can convert a selected Excel sheet into a CSV file. Additionally, you could specify the separator & decimal value for the CSV file.

Features

• Load/Save user settings
• Custom Toolbar
• Convert Excel Files to CSV

Screenshots

Main Window:
Settings Window:

Video Tutorial

Requirements

Install the dependecies with pip

openpyxl==3.0.10
pandas==1.3.5
PySimpleGUI==4.60.1

Usage

# [Vanilla Terminal] Run the application
python main.py

🤓 Check Out My Excel Add-ins

I've developed some handy Excel add-ins that you might find useful:

• 📊 Dashboard Add-in: Easily create interactive and visually appealing dashboards.
• 🎨 Cartoon Charts Add-In: Create engaging and fun cartoon-style charts.
• 🤪 Emoji Add-in: Add a touch of fun to your spreadsheets with emojis.
• 🛠️ MyToolBelt Add-in: A versatile toolbelt for Excel, featuring:
  • Creation of Pandas DataFrames and Jupyter Notebooks from Excel ranges
  • ChatGPT integration for advanced data analysis
  • And much more!

🤝 Connect with Me

• 📺 YouTube: CodingIsFun
• 🌐 Website: PythonAndVBA
• 💬 Discord: Join our Community
• 💼 LinkedIn: Connect with me
• 📸 Instagram: Follow me

Support My Work

Love my content and want to show appreciation? Why not buy me a coffee to fuel my creative engine? Your support means the world to me! 😊

Feedback

Got some thoughts or suggestions? Don't hesitate to reach out to me at [email protected]. I'd love to hear from you! 💡