The question is, do the same firms ban Excel? Excel spreadsheets often end up as shadow databases in unlikely places.

hermitShell 6 hours ago | parent | next [-]

The sane thing would be to ban Excel and promote SQLite. Excel is often used for tabulated text (issue tracking) not calculations. Perfect use case for a relational db

▲

harvie 2 minutes ago | parent | next [-]

or reimplement excel with sqlite as a backend :-D

BTW sqlite can run SQL queries on CSV files with relatively simple one-liner command...

▲

rswail an hour ago | parent | prev | next [-]

Excel has sheets for tables, columns and rows, primary keys (UNIQUE), foreign key references etc if you squint.

It doesn't require you use all of that properly, but it's there.

▲

frollogaston 6 hours ago | parent | prev | next [-]

Excel is made for calculations. But if you make it hard to make a DB, people will abuse Excel as a DB.

	▲	TJSomething 3 hours ago \| parent [-]
		I mean, it might have been at first, but Microsoft figured out that the majority of users for lists without formulas in 1993 and they've strategized around that. IMHO, the biggest concession to this was when they added Power Query to core Excel in 2016.

▲

0123456789ABCDE an hour ago | parent | prev [-]

and excel has gui for forms

	▲	rantingdemon 17 minutes ago \| parent [-]
		Only where VBA is available. Not available for MacOs versions if I'm correct?

▲

silon42 3 hours ago | parent | prev | next [-]

IMO, almost any Excel more than a month old should become readonly.

▲

Spooky23 6 hours ago | parent | prev | next [-]

They generally cannot. But they do banish Access.

	▲	pasc1878 2 hours ago \| parent [-]
		Now that is different. Access gets used for a shared DB and that is quite easy to corrupt. It is much more cost effective to have that in a proper central database (I supse SQLLite is better here as well)

▲

4 hours ago | parent | prev | next [-]

[deleted]

▲

DeathArrow 4 hours ago | parent | prev [-]

Do companies ban text files? Text files are used to store data.

	▲	yard2010 43 minutes ago \| parent \| next [-]
		Do companies ban data centers? It's crazy to send PII to other computers on the line.
	▲	altmanaltman an hour ago \| parent \| prev [-]
		Do companies ban brains? Brains are used to store data.