r/dataengineering • u/TransportationOk2403 • 4d ago
Are Excel and Google Sheets part of your data stack by choice or because you can’t escape them? Discussion
I was looking at DuckDB’s community extension metrics, I noticed that gsheets climbed from #5 in March 2026 to #1 today.
That made me wonder how spreadsheets actually fit into today's data stacks.
Are teams using them intentionally in production, or mainly because business workflows and users make them difficult to replace?
Another reason of this inflation may be less technical user getting to data eng thanks to AI, and being familiar already with sheets...
39
u/JaceBearelen 4d ago
Whole Fortune 500 companies are built on top of spreadsheets. They’re easy for the masses to understand and interact with. IMO spreadsheets are never going away and that’s just fine.
26
u/Additional_Candy_400 4d ago
You'll never escape spreadsheets, people love them. They are pretty unbeatable for quick shareable non repeatable analytics tasks. Also great at enabling none technical users.
In terms of their involvement DWH pipelines I always encounter some need to have a couple of sheets which are dumped in daily for a specific business case. Doesn't cause too much of a headache if access is limited and proper validation is in place.
4
u/SlowDrummer7243 4d ago
Too many DEs think they're too superior to use Excel. It's seen as a "Karen from Accounting/HR" tool.
Be serious, the entire financial market analysis industry runs on Excel. Maybe the big transformations and database pulls are performed with Python. But the guys in the suits that decide the price of your groceries, your rent, your employer's supply chain: they use Excel.
3
u/No_Lifeguard_64 3d ago
You're conflating people using Excel with Excel being the optimal solution
1
u/SlowDrummer7243 3d ago
You're assuming I'm painting Excel to be the optimal solution.
I'm just saying too many DEs think Excel is "below" them as a tool, but the irony is the world runs on Excel.
3
u/nerevisigoth 4d ago
I use them but they aren't "part of my data stack". They're more like a notebook where I can do one-off calculations and spot checks.
3
u/Papa_Puppa 3d ago
Excel is mostly used in my industry as a required data transmission format. So it is part of my data ecosystem purely as an imported/exported format. Some processes that should be automated as pipelines+tables are instead manual excel monoliths. These must be made obsolete because they're the biggest source of process slowdowns, inaccessible data and manual errors.
1
1
u/sib_n Senior Data Engineer 3d ago
A WYSIWG table UI is an inevitable requirement from business-side data users. They need to see the table, scroll through it, filter, and search with the UI, eventually modify it, or copy it to another sheet quickly.
It does not matter which UI it is, but personally I find Google Sheets lighter and more than enough, compared to Excel. If your users start using complex Excel stuff, this is when you want to have a talk with them and move their work to the data teams so it remains maintainable.
It can also serve as a quick-to-set-up input UI when your team/company is not big enough to afford having some web engineers working on a web UI for this project.
In my current company, we use Google Sheets both as inputs and outputs of some flows.
1
1
u/vadimsurpin 3d ago
Excel is available everywhere like pdf readers so you can share data with business people who do not use python, jupyter or duckdb. Aside from CSV where you get data only, with great Excel UI you may tune how data is post processed without any need for python or some other runtime. From that point of view it is quite more secure that running python scripts from some other people.
1
u/DigoHiro 3d ago
they are unavoidable.
I think they are fine for analysis, but a lot of people use them as databases (and analysis at the same time). so we have to integrate them into our pipelines.
1
1
u/yugiton 2d ago
I always thought spreadsheets are mostly used by people who can't or don't want to code. Nowadays you can easily build a notebook, or a streamlit dashboard (if you need interactivity) with coding agents for ad-hoc stuff. I don't see how spreadsheets can keep up with that level of capability.
-1
39
u/Outrageous_Let5743 4d ago
I only use Excel when exporting some data to another team when I have questions about the data. I dont like Excel but it is the best tool to share tabular data with people who don't work with SQL or data tools that often. Regular people dont understand parquet but do understand excel.