Who knows a free spreadsheet/database alternative to Excel?
Looking for a free way to create a table INCLUDING the function to create such dropdown columns AND filter the entire table header.
The background is that I want to create something like a simple little database-like table in which you can easily search for certain values entered in it.
(1 rating, 1 votes, rated)You need to be a registered member to rate this.
Loading...
like a database or actually a database? And databases consist of several tables (deities).
I'm very confused.
Do you need a database technology, a data structure or an alternative to Excel?
100 times the mantra " Excel is not a database " says.
Otherwise, this is generally nothing. 🤷 ♂️
If you do not want to use MS Office, LibreOffice is free of charge. Including the database application "Base".
Excel is not a database and not designed for it. The same applies to the free Excel alternative LibreOffice Calc, which I would have recommended.
Say: If you have a certain number of data and can map it very structured, you better take a correct database like PostgreSQL or Mariadb. However, since these are more complex for normal mortals, here is something simpler, similar (but better) to Microsoft Access: LibreOffice Base.
The advantage is that you can query your data with SQL. I don't know your requirements, but if you have the following tables, for example…
… you can easily find out which customer has often bought Article X.
This is also possible with spreadsheets.
Also from a database you get only that out what was previously entered.
Of course, it goes too, but very quickly becomes very confusing and also slow, depending on how much data you have. You can simply enter and run a SQL query, whereas a number of things have to be prepared for a table calculation.
What you don't say…
That's right when others work with Access is easier without annoying sheet protection etc.
I can't judge that. With too expected large volumes and even others, I also use Access.
There's nothing to destroy from others.
I don't and most of the ones working with Excel are talking about 50 rows here and about 10 columns. Much more rarely comes together when working with "Excel" databases.
If you are still using this data and which, for example, enters into special protocols depending on the line in which they occur or whatever criteria, you are a bit faster with Excel and can print it out directly. With Access you can build reports, but they are only a listing if necessary. is not that the desire, but a chronological use of these values.
I believe personally people who handle databases daily will never really understand the Excel a small database (usually replaced from a data source effortlessly and to lengths faster)
Similarly, people who work daily with Excel will never understand when the point has actually come to throw the database, as it has the nose at the front.
I'm just letting this assertion stand like that, even though I'm – so totally – don't share.
on the basis of the other answers, I have a little adapted:
Excel is just database-like and can do some things similar to a database, but actually only good and beautiful when this database consists of one to 2 sources (2 tables) once several are linked via key attributes, it becomes unsightly and clear in Excel.
So what exactly are you going to do?
If it is to be just a free Excel, then LibreOffice, GoogleSheets (as usual with Google, you are just the product), but think everyone is aware.
MariaDB, PostgreSQL, …
Excel and consortia (eg LibreOffice "Calc") for this purpose but not at all.
And simply, on real databases is rather little.
You're wrong. You can't stand that way.
Are 2 tables with 10 rows and 5 columns already databases or is this one more table? The mutual relations with each other.
But this is the highest of the feelings of what most people are talking about, talking about a database in combination and giving the letter and seal are you Access started I am almost finished with the evaluation of these data.
Travel books, hour tickets, travel expenses, yes you can do everything in Access as well, but it is much more bulky. But this is the daily bread of many in Excel.
Especially if not every entity can be assigned to another, because then the untrained as he now associates the sources.
This is the task of a database application, not a spreadsheet.
Excel, Calc and the same are provided for calculation tables.
What you want is a database….
"search for values" -> structured query language. There are SQL queries in databases that do exactly that.
It's not a rush, it's a fact.
Or do you buy a 40to truck because you want to drive to the supermarket in the city center and transport a head salad?
If you image databases in spreadsheets, you will find yourself in the foot.
Aha
that would be an argument not to use the truck (database) and the small vehicle (table calculation) because it could be sufficient.
open office should offer these features
you can also use exce online for free just a google account. dropdown menus definitely go about whether a filtering is included in the range of functions I don't know
Thank you very much for your human response and thank you for riding around here as the only not stupid on my description and the used word “database” 🙂
This is simply because people say database but actually mean table, because a real database is a little more bulky again and then all come out of the holes here and tell about the advantages of a database instead of just knocking off the application purpose (because not everyone is so definition-proof that he knows the differences between database and table) and asking what exactly the desire is and then access can be recognized very soon as a database application like eg
Table calculations can be what you asked…
…and more.
there is nothing to ride around you can put in excel vatenbanken or associate with it. always depends on the purpose and how big it should be off a certain degree disassembled it simply the calculator because it will eat too much ram