# website/excel questions

**URL:** https://boards.straightdope.com/t/website-excel-questions/820550
**Category:** In My Humble Opinion
**Created:** [August 31, 2018, 12:56am UTC](https://boards.straightdope.com/t/website-excel-questions/820550 "2018-08-31T00:56:38Z")
**Posts on this page:** 10
**Page:** 1

<div class="post-metadata">

### Author: ![zydecat](https://avatars.discourse-cdn.com/v4/letter/z/e480ec/32.png) [@zydecat](https://boards.straightdope.com/u/zydecat)
#### Post date: [August 31, 2018, 12:56am UTC](https://boards.straightdope.com/t/website-excel-questions/820550/1 "2018-08-31T00:56:38Z")

</div>

I hope I am correct forum. I am so clueless, I don’t know where to start… Given: I have no coding skills but have time to learn some basics. I’d rather use existing templates/software as opposed to building my own. I don’t need to reinvent the wheel. I own a website and am playing with Wordpress to publish content.

I have a spreadsheet that I want to put online in a website. The spreadsheet requires users to answer questions…select a choice from a list, enter numbers… and then the spreadsheet makes calculations based on that input. After all of the questions (user input) is complete, the website will take you to a page that shows the “what-if” of their input". What is the best way (by that I mean attractive looking and ease of use to ask the question and then input that answer into a spreadsheet cell? I would like to have 1 question on a page with a “next” button that takes you to the next question. I might also want to “Flow chart” the questions…ie. if you answer "yes "to a question, you go to following question A, but if you answer “no”, it takes you to question B.

I just need to know what software I should be looking at to get the job done. I’ll work on figuring out how to use it.

---

<div class="post-metadata">

### Author: ![Panther\_Modern](https://avatars.discourse-cdn.com/v4/letter/p/ac8455/32.png) [@Panther\_Modern](https://boards.straightdope.com/u/Panther_Modern)
#### Post date: [August 31, 2018, 4:05am UTC](https://boards.straightdope.com/t/website-excel-questions/820550/2 "2018-08-31T04:05:21Z")

</div>

Perhaps you could try Google Forms?

---

<div class="post-metadata">

### Author: ![zoid](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/zoid/32/336_2.png) [@zoid](https://boards.straightdope.com/u/zoid)
#### Post date: [August 31, 2018, 7:34am UTC](https://boards.straightdope.com/t/website-excel-questions/820550/3 "2018-08-31T07:34:38Z")

</div>

Yeah, what you want are forms and a rudimentary database - I’d guess it can be done in excel but I’m betting it’d be a pain

---

<div class="post-metadata">

### Author: ![GreenWyvern](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/greenwyvern/32/2834_2.png) [@GreenWyvern](https://boards.straightdope.com/u/GreenWyvern)
#### Post date: [August 31, 2018, 7:52am UTC](https://boards.straightdope.com/t/website-excel-questions/820550/4 "2018-08-31T07:52:22Z")

</div>

You can’t directly convert your spreadsheet for a website. There is no automatic way to do it.

The spreadsheet logic needs to be re-written by a programmer, with forms, buttons, pages, etc. for the web. You’ll need to hire a freelance programmer to do it for you.

---

<div class="post-metadata">

### Author: ![zydecat](https://avatars.discourse-cdn.com/v4/letter/z/e480ec/32.png) [@zydecat](https://boards.straightdope.com/u/zydecat)
#### Post date: [August 31, 2018, 4:45pm UTC](https://boards.straightdope.com/t/website-excel-questions/820550/5 "2018-08-31T16:45:49Z")

</div>

I saw Google Forms. Yes that is exactly what I was thinking of…except… I think Google Forms is more of a survey. It seems to tabulate your responses into a running count of which answer is selected. I don’t think it takes your answer to a question and deposit that data into a cell. Correct me if I’m wrong.

I was afraid that I’d have to hire someone. There’s a lot of hours involved that probably makes this impractical.

Assuming that I want to put in the time and do this myself- much of the coding is repetitive with only slight nuanced change (the nuanced change and need for regular updates is what makes this not cost effective to hire out)- what software do I start learning? Dreamweaver? Can this be done on Wordpress?

---

<div class="post-metadata">

### Author: ![GIGObuster](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/gigobuster/32/421_2.png) [@GIGObuster](https://boards.straightdope.com/u/GIGObuster)
#### Post date: [August 31, 2018, 5:32pm UTC](https://boards.straightdope.com/t/website-excel-questions/820550/6 "2018-08-31T17:32:35Z")

</div>

> [@zydecat](#):
>
> I saw Google Forms. Yes that is exactly what I was thinking of…except… I think Google Forms is more of a survey. It seems to tabulate your responses into a running count of which answer is selected. I don’t think it takes your answer to a question and deposit that data into a cell. Correct me if I’m wrong.

No, answers are not selected unless you tell the spreadsheet where the data is saved from forms to do so. There is a way to select different answers on a form before hand: one can set it up like a quiz for students at school, the answers chosen go the spreadsheet after one submits a form with the selections made already. After each form submission the spreadsheet grows a row.

> **[Google Forms: A guide for how to create Google Form surveys | Zapier](https://zapier.com/blog/how-to-use-google-forms/)**
>
> Ready to take your surveys to the next level? Discover how to effortlessly create, manage, and share surveys using tools and features on Google Forms.

> [@zydecat](#):
>
> I was afraid that I’d have to hire someone. There’s a lot of hours involved that probably makes this impractical.
> 
> Assuming that I want to put in the time and do this myself- much of the coding is repetitive with only slight nuanced change (the nuanced change and need for regular updates is what makes this not cost effective to hire out)- what software do I start learning? Dreamweaver? Can this be done on Wordpress?

I usually end up doing basic work with the editor of [Seamonkey](https://www.seamonkey-project.org/) and then I embed or link to the google forms I make on the web-page, then I check the spreadsheets with the data that was made with the forms in google drive.

---

<div class="post-metadata">

### Author: ![zydecat](https://avatars.discourse-cdn.com/v4/letter/z/e480ec/32.png) [@zydecat](https://boards.straightdope.com/u/zydecat)
#### Post date: [September 1, 2018, 12:09am UTC](https://boards.straightdope.com/t/website-excel-questions/820550/7 "2018-09-01T00:09:35Z")

</div>

GIGObuster… thanks. I originally designed the spreadsheets in Google Sheets. I played with Google Forms and like the look but I didn’t know for sure whether it would do what I want. I’ll dig deeper now that I know it will. Do you have any websites I could go to to look at an embed vs a link?

---

<div class="post-metadata">

### Author: ![kenobi\_65](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/kenobi_65/32/13178_2.png) [@kenobi\_65](https://boards.straightdope.com/u/kenobi_65)
#### Post date: [September 1, 2018, 12:16am UTC](https://boards.straightdope.com/t/website-excel-questions/820550/8 "2018-09-01T00:16:51Z")

</div>

I don’t have any good advice on how to do what you want to do, zydecat, but your guess that this might not be the right forum is right. Cafe Society is really for entertainment topics (movies, TV, music, books, etc.), and this sounds more like a topic for the General Questions forum. I’ll flag this thread for a moderator to look at, and move to the more appropriate forum.

---

<div class="post-metadata">

### Author: ![kenobi\_65](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/kenobi_65/32/13178_2.png) [@kenobi\_65](https://boards.straightdope.com/u/kenobi_65)
#### Post date: [September 1, 2018, 12:19am UTC](https://boards.straightdope.com/t/website-excel-questions/820550/9 "2018-09-01T00:19:22Z")

</div>

Actually, on further thought, it sounds a lot like you’re wanting to essentially do a custom survey. You may want to look at survey websites like SurveyMonkey. One issue is that formatting the survey pages to look like your website (if that’s what you want to do) may cost some money.

---

<div class="post-metadata">

### Author: ![Chronos](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/chronos/32/134_2.png) [@Chronos](https://boards.straightdope.com/u/Chronos)
#### Post date: [September 1, 2018, 1:14am UTC](https://boards.straightdope.com/t/website-excel-questions/820550/10 "2018-09-01T01:14:50Z")

</div>

[Moderating]

> [@](#):
>
> I hope I am correct forum. I am so clueless, I don’t know where to start…

You might start by reading the forum descriptions. This forum is about the arts and culture, which does not include database design. Moved to IMHO.
