[Solved] How can I import data from my google spread sheet?


We are creating a collapsing hierarchy of questions. 

I found the “Data Import” menu in the “Tools” bar, and I selected my file in the CSV file select option. When I see the preview, the data is not there. I am worried I may have formatted it wrong. I included a screenshot of our data.Could you provide me with a link to how to format my spreadsheet? What should I do in the “Map Fields” page that I am directed to before the preview?


Thanks a lot for your help! 



vfimturk asked

    Best answer


    When using the Data Import Took, your data definitely has to be formatted in a very specific. I have linked to the SG Data Import Documentation below (specifically the formatting section):


    The way your data will need to be formatted is dependent on the types of questions that you are mapping to. I find the best way to go about this is to submit a response to your survey in SurveyGizmo and then create an export.

    The export will give you a file that is formatted and ready to import and you can use that as a template to build your file from scratch.

    Dominic Sharpe answered


      Question stats

      • Active
      • Views2508 times
      • Answers1 answer
      • Followers0 followers