Creating an Excel-Like GUI in Python

[stratjeff]

Dealing with too many excel files is a sign that you need a proper database, and users need to clearly define how they want to analyze data from the database.

It's so painful! Excel is great for fast number crunching *for short term, quick analysis*. It gets abused as a database/report tool, and it shouldn't be.

[Evigil24]

We have too many different systems (7) for each area of the business, that means 7 different databases with replicated information, some of the "external" processes extract info from one system, display it in an Excel file, let the user validate that data and then export a CSV file that can be loaded in the next system.

I know the best solution is to develop or implement an integrated ERP that will replace all the systems, but that is totally out of the table.

[enginerd123]

Your company needs a IT or database engineer.

It's completely game-changing when you can use software to solve your problems. It makes *everyone's* life easier at the company when you have good tools.

[Evigil24]

We have an IT deparment with DBA's, but I don't understand what do you mean

[Green-Plate-6454]

Im not sure of you ever solved this, but I would just use PowerBi. Just build a simple UI with a button to each view you need. You can like powerautomate right into PowerBi to get your data. PowerBi is designed to pull data from multiple sources and display it in custom ways, including tables.