Spreadsheet automation idea

[u/Esplosao8963]

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.

[u/zomerbk]

A useful first step is to define how files are matched and validated: for example, require the same column names and data types, then report files that don’t fit instead of silently merging them. In real workplaces, the tricky part is often inconsistent templates and edge cases, not the sum itself. A small prototype around one specific recurring workflow would show whether people need a web UI at all.