← Back to r/Python
r/Python • • 6d ago Discussion

Spreadsheet automation idea

▲ 1 points 💬 35 comments Reddit Source ↗

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.

Discussion (35)

Sort:
u/elven_mage • ▲ 14 • 6d ago (+12 replies collapsed)

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

u/Glittering-Poet-9116 • ▲ 7 • 6d ago (+2 replies collapsed)

I was deep in spreadsheet hell at my last job, merging monthly reports by hand and it was the worst part of my week

This project would've saved me so much time, don't let anyone talk you out of building it just because a database exists in theory

u/AJohnnyTruant • ▲ 3 • 1d ago (+1 replies collapsed)

DuckDB and Polars

u/Esplosao8963 OP • ▲ -5 • 6d ago (+9 replies collapsed)

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.

u/likethevegetable • ▲ 21 • 6d ago (+1 replies collapsed)

I doubt you're going to make money but good luck

u/Papa_Puppa • ▲ 17 • 4d ago (+1 replies collapsed)

This is such a bad business idea.

Either excel sheets have:

  1. consistent schema and you can simply ingest them via a timer or blob scheduled pipeline into a database, or

  2. inconsistent schema and you're just going to reinvent power automate, DAX and PowerBI, providing new tools into a crowded space to solve a problem that is actually a procedure/workflow problem.

Save years of your life and drop this idea.

u/call_me_cookie • ▲ 10 • 2d ago (+1 replies collapsed)

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

u/umairshariff23 • ▲ 8 • 6d ago (+1 replies collapsed)

Yeah, this is not profitable as anyone who is doing this kind of work already knows powerquery or can find out about it very easily. You'd need to find clients that refuse to touch computers for this to be feasible

u/Gankcore • ▲ 6 • 6d ago (+1 replies collapsed)

Why would my organization pay money for this when I can do the exact same thing you are doing?

u/elven_mage • ▲ 3 • 6d ago (+2 replies collapsed)

I wouldn't be bragging about copying ideas from work but you do you

u/Esplosao8963 OP • ▲ 0 • 6d ago (+1 replies collapsed)

I'm not bragging, especially since the app does this with PDFs but doesn't have an option for spreadsheets; I just took the inspiration from it.

u/snugar_i • ▲ 3 • 4d ago (+1 replies collapsed)

customizable options to perfectly suit each person's spreadsheet needs

Good luck, you'll need about one trillion configuration options for that.

u/likethevegetable • ▲ 23 • 6d ago (+7 replies collapsed)

K

u/Esplosao8963 OP • ▲ -1 • 6d ago (+6 replies collapsed)

?

u/likethevegetable • ▲ 12 • 6d ago (+5 replies collapsed)

What's the goal of your post?

u/Esplosao8963 OP • ▲ 0 • 6d ago (+4 replies collapsed)

I just wanted to know what people think. I've never done projects with this before and I'm looking for some guidance. This was just one of the ideas I had, and since I didn't find it very reliable and I believe something like this must already exist, I went looking for information.

u/likethevegetable • ▲ 16 • 6d ago (+1 replies collapsed)

Of course, it's called working on a job that uses spreadsheets and needing some high level tools that Excel doesn't have. Many people develop these things every day. 

u/GreenPandaPop • ▲ 10 • 2d ago (+1 replies collapsed)

You haven't actually asked a question anywhere.

u/dudeplace • ▲ 2 • 2d ago (+1 replies collapsed)

Things like this do exist, but they all exist for a specific purpose. Your idea sounds like it could help you, you should do it.

u/JohneeFyve • ▲ 7 • 6d ago (+2 replies collapsed)

If you were going to do this in Excel, Power Query would be a better tool for the task than Python, imo

u/ianitic • ▲ 1 • 6d ago (+1 replies collapsed)

Yup was thinking the same but in either case, it is very quick to do. I doubt there's any money at all in this.

u/Zenin • ▲ 6 • 6d ago (+2 replies collapsed)

You mention in a comment that you'd like something you could, "sell in bulk to companies".

As a personal project and/or help your own work, this is a fine project to tackle. Rock on!

As a product to sell? No chance unfortunately. The problem is it's 2026: Copy/Pasting your post almost verbatim into corporate AI will solve the same problem better than your tool likely ever could. I know because I both do this myself on the daily and support business users of all stripes that practically live in ChatGPT these days.

In 2020 you'd have had a good product idea, but today you have a prompt template.

u/ConceptJunkie • ▲ 6 • 2d ago (+1 replies collapsed)

Maybe in 1997.

u/denehoffman • ▲ 4 • 6d ago (+3 replies collapsed)

What would that provide that polars and pandas don’t already give us?

u/Esplosao8963 OP • ▲ 0 • 6d ago (+2 replies collapsed)

That's exactly what I'm thinking, which is why I went looking for more opinions.

u/denehoffman • ▲ 1 • 6d ago (+1 replies collapsed)

I guess it can be more graphical, but then you’re just designing excel or numbers, I guess with maybe more unique features, but that could be a big task.

u/GeNiuSRxN • ▲ 4 • 6d ago (+1 replies collapsed)

I don't understand the underlying premise of this idea. Is there some value add that openpyxl or xlsxwriter can't achieve?

u/BranchLatter4294 • ▲ 4 • 6d ago (+1 replies collapsed)

Anyone who wants this done can have ChatGPT write a script for it in a couple of minutes. It's not something you're going to be able to sell. But if you need it for your own use, the go for it.

u/ben_1987_ro_uk • ▲ 1 • 6d ago (+1 replies collapsed)

You don't need python for this, you can use visual studio and make an add in for excel it shall spear as a ribbon

u/THEPASSWORDISDOLPHIN • ▲ 1 • 6d ago (+1 replies collapsed)

The idea is useful but excel power query already merges files from a folder and it's free

u/OddsRelay • ▲ 1 • 6d ago (+1 replies collapsed)

For the merging and yearly totals I'd let pandas do the heavy lifting. Read each file with read_excel, concat them with a column for the month, and a groupby gets you week, month or year in a line. Keep openpyxl for the formatting side, it's painful for calculations

u/zztopsboatswain • ▲ 1 • 2d ago (+1 replies collapsed)

I made an app that does this, but for the company I work at. It's useful when the employees who need to use it don't have a clue how to use python themselves. Just go for it

u/c1-c2 • ▲ 1 • 2d ago (+1 replies collapsed)

No UI needed. Provide folders to users to copy/paste source files to. Use watchdog or cron to auto-gen result files. Users replace files/throw in more files, results get updated.

u/Captian_crime • ▲ 1 • 1d ago (+1 replies collapsed)

If it benefits your company cool I have built several auromation scripts with or without LLMs. With LLMs its super easy now

u/zomerbk • ▲ 1 • 1d ago (+1 replies collapsed)

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.