Possible to populate a Google Form's Questions with a Spreadsheet / CSV?

forms csv google-sheets spreadsheet google-forms
Dan picture Dan · May 8, 2017 · Viewed 8k times · Source

I have scoured the internet, and although I am fairly sure this just isn't possible yet due to the design of forms by google, but if anyone has a way to do it, be it through running a script or just a clever work around, it would help me so much!

Allow me to break down kind of what I am trying to get done:

I have a spread sheet, with about 600+ entries in it.

I need to take, and populate a form with each question being a row form the spreadsheet, and each question having a blank short-text answer.

I am trying to populate the questions with English phrases, so a third party can easily fill in the spanish translation in the Answer spaces.

I can only find way to populate the Answer with spreadsheet data (by copy pasting a column into multiple choice answer, for example), but I need it to populate the Question, leaving blank answers.

TL:DR I want to be able to make a 600 question form, with each question being populated from a row in my .csv/spreadsheet.

Is this possible? I do feel like I could've worded this question better, if anyone is confused as to what I'm asking please let me know and i will revise!

Thanks

Answer

Related questions

jQuery AJAX submit form

I have a form with name orderproductForm and an undefined number of inputs. I want to do some kind of jQuery.get or ajax or anything like that that would call a page through Ajax, and send along all the …

Read More
JavaScript post request like a form submit

I'm trying to direct a browser to a different page. If I wanted a GET request, I might say document.location.href = 'http://example.com/q=a'; But the resource I'm trying to access won't respond properly unless I use …

Read More
Set the value of an input field

How would you set the default value of a form <input> text field in JavaScript?

Read More