# Web-Based form viewer for spreadsheet data?
**URL:** https://boards.straightdope.com/t/web-based-form-viewer-for-spreadsheet-data/710636
**Category:** Factual Questions
**Created:** [January 23, 2015, 1:03am UTC](https://boards.straightdope.com/t/web-based-form-viewer-for-spreadsheet-data/710636 "2015-01-23T01:03:46Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@aaelghat](https://boards.straightdope.com/u/aaelghat)
#### Post date: [January 23, 2015, 1:03am UTC](https://boards.straightdope.com/t/web-based-form-viewer-for-spreadsheet-data/710636/1 "2015-01-23T01:03:46Z")
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.
---
### Author:  [@Duckster](https://boards.straightdope.com/u/Duckster)
#### Post date: [January 23, 2015, 4:21am UTC](https://boards.straightdope.com/t/web-based-form-viewer-for-spreadsheet-data/710636/2 "2015-01-23T04:21:29Z")
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](https://stackoverflow.com/questions/518795/dynamically-display-a-csv-file-as-an-html-table-on-a-web-page).
[Select/display data from a record in the file](http://www.webdeveloper.com/forum/showthread.php?150890-How-do-I-select-only-one-row-from-a-csv-file).
You need to work a code level to do this.
Sorry, I don’t do Wordpress.
---
### Author:  [@aaelghat](https://boards.straightdope.com/u/aaelghat)
#### Post date: [January 23, 2015, 10:55pm UTC](https://boards.straightdope.com/t/web-based-form-viewer-for-spreadsheet-data/710636/3 "2015-01-23T22:55:53Z")
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!