4 ms·
At my current job, I've really come to hate Excel. Business is completely addicted to it. Despite Data Quality being an explicit concern that we're supposed to
by mcv 6y ago
At my current job, I've really come to hate Excel. Business is completely addicted to it. Despite Data Quality being an explicit concern that we're supposed to work on, they love maintaining their hand-typed data in Excel sheets, referring to other data with hand-typed names instead of proper foreign keys, and then I'm supposed to load and connect all that crap.
And nobody is using it for actual calculations, which is what spreadsheets are for.
I would really, really like a flexible database with an Excel-like front-end and easily-definable columns that make use of foreign keys, so we can actually maintain some data quality here. And what I'm looking for sounds so obvious that I have a hard time believing there's not already a good open-source solution for it, but I have no idea what it is. I'm this close to just building it myself. Anything to wean these people off their Excel addiction.