Import survey data
With the Survey import function you can easily upload data from previous suppliers to your Netigate account.
There are two things you need in order to use this functionality:
- The questions to your survey in an easy to use format such as PDF, Excel or Word. This is what you will use to create the survey.
- The answers you want to upload as a Rawdata file, saved in Excel format. This is what you will upload to your survey in Netigate. Important: The Excel Raw-data file needs to be with numerical values.
The first thing you will have to do is create the survey and all of its questions. Go through it one extra time to make sure the questions are created the right way, such as double checking that your multi-choice questions are saved as Checkboxes and single-choice questions as Radiobuttons.
Prepare the Rawdata file by making sure it is set up with the respondents email address in Column A. If it is an anonymous survey, make sure you have unique values in the first column. For example: email@example.com, firstname.lastname@example.org etc. Or just number: 1, 2, 3, 4 etc. See attached example in the screenshot below.
Important: Make sure that you remove any non-breaking spaces from the cells unless it is open text answers.
Next thing to check is that your excel file only contains one sheet with data. For example you can not have data you want to upload on sheet 1 and other data on sheet 2 as that will interfere with the upload.
The upload proccess:
- Go to the account settings of your Netigate account and click “Survey Import“.
- Click “Add file” and browse your computer for the file you wish the upload.
- When the file is selected, make sure tomatch it to the correct survey. Select the survey you want to upload data to from the drop down list that is shown.
- Now we get to match each column from the excel file to all of the questions in the survey, Netigate will pre-define which column that will be upload to which question by default, but we can change this if needed. By default Netigate will match column B in the excel file with the first quesiton in the survey, Column C with the next one and so on. This may change if you use a multi-choice question or a matrix as a first question in a survey.
- Click upload.
- Q: Why did only some of the answers get uploaded and not all? – A: There is most likely a mismatch between the Excel file and the Netigate survey, it can be that you still have som plain text in one of the columns that is not an open text question or you have non-breaking spaces in them perhaps so double check that and try again.
- Q: Can I remove the answers and try again? – A: Yes you can! go to the respondent tab in the report of the survey and remove the answers from there.
- Q: Can I use labels instead of values when I upload – A: No, you have to use values (numerical values) to upload answers to a survey in Netigate.
- Q: Can I upload 10 000 answers? – A: Yes and even more, we have uploaded 100 000 responses before. It’s just the loading time that takes longer.
- Q: If a respondents has not answered a question what should the cell contain? – A: The cell should in this case be empty, it should not contain a 0 (zero) or any other type of character as those are values of some sort.
- Q: Something went wrong and I accidently uploaded answers to the wrong questions, what should I do? – A: Easy, just make a new copy of the survey and delete the old one and upload your data again (You can have as many surveys in your Netigate account as you want, there is no limit).
- Q: Can I upload answers to an already existing survey? – A: Yes, you can.But we recommend you do it to an empty copy of your survey that does not contain any answers.
Tips & Tricks:
- A good tip is to go through all the columns and match them before clicking the upload button to make sure the match is correct, i.e. that the corresponding column is connected to the right question.
- Make sure that your multi choice questions are seperate in to one column for each option, for example if you have 10 options in a multichoice that should then be shown as 10 columns in the raw data, if a respondent has answered the question it should be shown with the number 1 (one) in the column corresponding to the option they answerd.
- If you have matrix questions they should also be presented in different columns in your raw data where each column is one of the rows with in the matrix question. So if you have a matrix question with 4 rows it should then appear has four columns in the raw data.
- If you want to reset your upload before finishing it just click Upload a new document at the top and you will have the choice to reset your entire upload and start again.
Was this article helpful?
Thank you for helping us improve this article!