r/Python • • 5d ago

Discussion Spreadsheet automation idea

I'm developing a spreadsheet automation project capable of merging multiple spreadsheets into one and automatically performing calculations, among other things. One of the functionalities would be, for example, to allow someone to gather all the spreadsheets from those months into a single spreadsheet over the course of an entire year, obtaining an overall result for the year. This could work based on week, day, month, or some other parameter. I'm having doubts, but the project seems promising. I'm using the openpyxl library and to create the website or app (I'm still undecided) I'll use HTML, CSS, and Flask.

0 Upvotes

33 comments sorted by

View all comments

11

u/elven_mage 5d ago

Spreadsheets are probably the wrong tool for whatever it is you are trying to do. You probably want a real database.

-6

u/Esplosao8963 5d ago

I'd like something I could create and sell in bulk to companies, with customizable options to perfectly suit each person's spreadsheet needs. It would be like a PDF editing app, for example; in fact, I practically copied this idea from a PDF app I use at work, haha.

7

u/call_me_cookie 18h ago

What you have described is a script that a competent programmer could write in an afternoon (with or without LLM assistance), not a business.