I'm looking for simple web based database software

In My Humble Opinion
1

I used to use Microsoft Works back in the early 90s and I thought it was what I needed. But that’s basically gone now.

Say I have a spreadsheet with 10 columns and 100 rows.

I want to be able to select one option from each column all the way down, and see what matches the critieria.

So Column 1 is Vendors, I pick “Company A”. Column 2 is Styles, I pick “Style” B. Column 3 is color, I pick “Color C”.

Then it shows me the results that match? Anything that can do that online without a download and maybe for free? heh

Thanks

2

I would look into Google Sheets - Wikipedia. It should do what you describe and is free.

Sounds like a fairly simple IF AND AND formula and Sheets does that.

There is free access Word, Excel, and PowerPoint using Microsoft 365 for the web (formerly Office). But I understand with ads.

3

The “Data table” feature in Excel does exactly that. Select your header row and block of data rows below, click the Filter button and viola: The heders turn into dropdowns and the list filters based on which values you restrict in which columns.

I don’t know that Excel online is free, but it’s a darn good bet that definitely-free Google Sheets has a very similar capability although probably with slightly different terminology.

4

Thank you both

5

@Eleusis, can I also put in a good word for Airtable.com? I’m not affiliated with them, but they offer a very nice service, like a modern web-based Access that’s super easy to use and share, and has a generous free plan.

Example that I made for you in a few minutes: Airtable - Airtable Demo

You can easily mix & match column filters there, link to related tables (like companies), or show the same data in a gallery view (and still apply filters), etc.

We had another poster recently use it for a large catalog of items for sale, too, to good effect: I come again, humbly, for advice: photo hosting site (with conditions) - #9 by Reply

It’s a really good product and way better than Google Sheets or Excels if you want something more database-like than spreadsheet-like.

6

Thank you, that is perfect. Very much appreciated. I wanted the spreadsheet that breaks out into a single page