Form Lookups With Google Sheets

You can use values from Google Sheets for your lookup tables. In this article, we'll show you how.

To begin, log into your Google account and navigate to Sheets and then to the specific Sheet you'd like to work with.  Your data should be formatted in columns, as shown below.  You can use Row 1 as your column header if you'd like, but this is not required.  While only one column is required for lookups, your sheet can have as many columns as you'd like and you can specify a second column for values in a later step.  

 

Screen_Shot_2017-03-08_at_11.25.09_AM.png

 

Once you've ensured that your data is formatted correctly and is ready for use, click the blue Share button in the upper right corner. 

 

Screen_Shot_2017-03-08_at_11.25.57_AM.png

 

Then, if you haven't done so already, click Get shareable link and copy it onto your clipboard.

 

Screen_Shot_2017-03-08_at_11.26.46_AM.png

 

Finally, inside Qrvey, paste the link and then click Select Entries to choose the sheet and columns you'd like to use. 

 

Screen_Shot_2017-03-08_at_12.17.22_PM.png

 

 

...