Local Database Login & Signup System — Python + Tkinter + Excel

A secure Login and Signup System in Python using Tkinter GUI and Excel (openpyxl) as a local database. Perfect beginner project for learning authentication, data validation, and GUI design without SQL or APIs.
signup page

Built With

Explore the Full Project

Detailed Description

This Python-based Login and Signup System provides a fully functional user authentication interface using Tkinter for GUI and Excel (via openpyxl) for local data storage.

It enables users to create accounts, store credentials securely, and log in — all handled locally without the need for an online database or external APIs.
It’s an ideal learning project for beginners exploring Python GUI, data storage, and form validation logic.


⚙️ Core Features

  • 🔑 Signup & Login Functionality: Users can create new accounts or log in using saved credentials.

  • 📁 Local Database: Credentials are stored in an Excel sheet (data.xlsx) using openpyxl.

  • 🧠 Validation System: Prevents duplicate UIDs and ensures all fields are filled before proceeding.

  • 🔁 Dynamic Interface: Seamlessly switches between Login and Signup pages within the same window.

  • 🧩 Error Handling: Uses message boxes to notify users of incorrect credentials or missing data.

  • 🖼️ Polished GUI: Includes background images and clean, minimal color tones for a modern desktop app look.


🧰 Tech Stack

  • Language: Python 3+

  • Libraries:

    • tkinter — GUI interface

    • openpyxl — local Excel-based database

    • os — file management

    • messagebox — error and info dialogs


💡 Highlights

  • No internet or SQL database required — completely offline & local.

  • Modular and easy to expand with password hashing, user roles, or profile data.

  • Demonstrates real-world GUI navigation and data persistence.

  • Excellent example of state management in Tkinter apps.

Project Preview