nixCraft,
@nixCraft@mastodon.social avatar

Why do so many people treat Excel as a database? 🤔

trechnex,
@trechnex@social.trechnex.com avatar

@nixCraft because technically you can use any modern spreadsheet program to perform the same functions as a personal database (eg. filtering tables, generating reports, organising data, searching for records, etc)

It's a good thing that people don't have to learn Microsoft Access or LibreOffice Base to do that imho. 🙂

This idea that using spreadsheets as a database is a "noob" thing to do probably should have went away about 10-15 years ago.

0xf02d,
@0xf02d@mastodon.social avatar

@nixCraft It’s like phone camera vs dedicated camera: the tool you have with you and know how to use is the tool you end up using.

bargoderea,
@bargoderea@mastodon.social avatar

@nixCraft due to the lack of a more proper alternative

rthaar,

@nixCraft because you can actually use SQL in excel. Does the job fairly decent !!

expiredtoken,

@nixCraft The User Interface of Excel is pretty much like CLI: extremely flexible and versatile, excellent for building ad-hoc tools. That's hard to beat! The only serious alternative product that is not a full blown database requiring an army of developers to build a freaking form is Filemaker.

abimelex,
@abimelex@mastodon.social avatar

@nixCraft I see no problem there, but most people treat Excel as Word with tables. Actually only a fraction utilize some functions that also a DB would offer.

schrotthaufen,
@schrotthaufen@mastodon.social avatar

@nixCraft With power query it is🙊

h0m3,
@h0m3@mastodon.social avatar

@nixCraft Because a database is excell but harder to use hahahaha

alda,
@alda@topspicy.social avatar

@nixCraft because they need to get things done in an office environment without involving an external contractor or the IT department, which in turn is unfamiliar with or doesn't care about the task at hand and adds overhead that you can get away with.

It's the most popular functional programming environment for a reason — and people who use it don't even know it's programming!

alda,
@alda@topspicy.social avatar

@nixCraft also, PowerBI and the JSON connector that's built into Excel is amazingly powerful in the right hands.

longLiveCarryOn,
@longLiveCarryOn@mastodon.social avatar

@nixCraft

because is simple, easy use,

mikaellundin,
@mikaellundin@mastodon.social avatar

@nixCraft because the UI of databases usually sucks, so you try to avoid them until you can’t.

Ihazchaos,
@Ihazchaos@chaos.social avatar

@nixCraft It’s easy at first and they don’t know better.

sgsax,
@sgsax@mastodon.social avatar

@nixCraft Counterpoint: Why do so many people use Excel?

  • All
  • Subscribed
  • Moderated
  • Favorites
  • random
  • Durango
  • DreamBathrooms
  • thenastyranch
  • magazineikmin
  • khanakhh
  • InstantRegret
  • Youngstown
  • ngwrru68w68
  • slotface
  • rosin
  • tacticalgear
  • mdbf
  • kavyap
  • modclub
  • megavids
  • osvaldo12
  • ethstaker
  • cubers
  • normalnudes
  • everett
  • tester
  • GTA5RPClips
  • Leos
  • cisconetworking
  • provamag3
  • anitta
  • JUstTest
  • lostlight
  • All magazines