Web-Based form viewer for spreadsheet data?

Factual Questions
1

Hi - I have a spreadsheet where each row has a unique product ID, and then attributes for that ID.

What I want to do is have people be able to go to a web link, enter the Product ID, press a submit button or something and then have all the product attributes displayed for that product.

I’m familiar with Google Forms, but that seems like that’s for collecting information and creating a spreadsheet row from each form whereas I want to display spreadsheet data in a form.

I have familiarity with WordPress, and I know I can import information from a csv into that, but I’m not sure how I would have someone enter an ID, press Enter, and see the associated attributes.

Anyone have any ideas? Can you point me in the right direction?

Thanks.

2

If I understand you correctly, you want to use a spreadsheet as a pseudo database to display individual records upon request, using a web page as the format.

Yup can be done. Rather easy to do in PHP. Using (as you state) a CSV version of the spreadsheet, where each row is a record, and each column in the record is a field (with the first one being the unique identifier).

There are a number of code snippet sites out there that can assist you.

This creates a simple table of all data in the data file.
Select/display data from a record in the file.

You need to work a code level to do this.

Sorry, I don’t do Wordpress.

3

Thanks Duckster - That was a great answer, and I was going down that path, and then I stumbled upon a Wordpress plugin that would let me do database functionality.

Thanks again!