I'm trying to create a survey/Google Form specifically to export data into an Excel sheet. This isn't very important because I can tweak the arrangement after the fact, but naturally I have a lot of data coming in.

Some of the questions will be things like:

Starting with most recent, please describe any education or achievements you have received:

But will require guidelines for the response and inputs, such as "Diploma," "Institution," "Location," and "Year." Each of these will require their own response box, but will apply to the same question. For example:

A sample of the question type I need

I thought of doing Page/Header breaks between question "groups" and entering multiple text items per break so that at least each topic was organized, but the result is sloppy:

What it looks like in Google Forms

If at the very least there were a way to move the title and help text alongside the response boxes, or minimize most of the spacing, it would look so much better. Even this sample is barely tolerable because of the example/help/description text in gray type. However this wouldn't be very useful for necessary fields like "Please include your contact information" (Name, Address 1, Address 2, City, State, Zip, Phone, Email, etc.) which would be tiny fields that don't need a whole page. After entering most of the items in either of these formats, the survey would be 10+ pages of drudgery when it should really only be three (including the instructions/introduction page).

I'm not above script editing but unfortunately I have a novice education on the subject and am limited to mimicking samples or tweaking a source. Any help on the matter would be greatly appreciated.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.