I will automate excel CSV export app using sql and python

Shafiul

Bangladesh

I speak English
Expert in SQL, Excel, Python & HTML. I provide data analysis, automation, custom scripts, dashboards, and responsive web design. Quality work, fast delivery, and clear communication.
About this Gig

Are you looking for a custom Windows desktop application that connects to your SQL Server database and automates data export to Excel with live refresh functionality?

Look no further!

I will develop a secure and efficient Python-based app tailored to your SQL Server setup.


App Features:

  • Password-protected access
  • ️ Manual database configuration (server, instance, DB name)
  • Test Connection validation
  • Export data to selected folder in Excel format
  • Set auto-refresh interval to keep data updated
  • Runs in the background continuously

Tech Used:

  • Python (Tkinter / PyQt / CustomTkinter for UI)
  • pyodbc / pymssql for SQL Server connection
  • pandas + openpyxl / xlsxwriter for Excel export

Ideal For:

  • Retail POS systems (like CRE)
  • Liquor store inventory/export automation
  • Internal business tools needing live SQL data access

What I Need From You:

  • Sample database/table or structure
  • Data columns you want to export
  • Your preferred UI labels or branding (optional)
Read More
automate excel CSV export app using sql and python
automate excel CSV export app using sql and python
Full Screen
Full Screen
automate excel CSV export app using sql and pythonautomate excel CSV export app using sql and pythonautomate excel CSV export app using sql and python

Technology:

Excel

•

Python

Expertise:

Data extraction

•

SQL

Related tags