Export your spreadsheet as a CSV file (this will be in your Save As, Export or Download menu)
Choose a project on Makerble to save the information in
Map the columns to the fields (questions) on Makerble and that’s it

Considerations for

...

Respondent Name

You should not need add a question called Respondent Name to your survey on Makerble. This is because Makerble has an internal field called Name (sometimes displayed as Full Name) which is used to store the name of the respondent. This is covered in Step 5 of the import process.
If you want your survey responses on Makerble to be anonymous and not contain the name of the respondent, that’s fine. Alternatively if you want to use another identifier rather than name, for example Email Address, you can do that instead.
- Before you do the import: ensure there is a field in your spreadsheet that is called Name but in that field, put a random ID number or a respondent ID number. This is because Makerble does need a name to associate each response with, but it doesn’t have to be a person’s name. It can be any string of characters.
- When you reach step 5, select the column that you have designated to store the Name (which in practice might actually contain a Respondent ID Number or a random string of unique characters)

Makerble lets you distinguish between the internal and external names of the questions in your survey
- For quantitative survey questions (Multiple Choice, Tickbox, Numerical) are saved in your account as Progress Trackers.
  - Progress Trackers typically have short punchy titles. E.g. “Confidence Level”
  - But you can change the Ask - i.e. the way that the question is worded when it appears within a survey - so that it sounds more inviting, e.g. “How would you rate your level of confidence?”
In your spreadsheet it doesn’t matter whether your column titles are
- identical to the names of the Progress Trackers
- or identical to the Ask (the way the question is worded in the survey to a respondent)
- or written altogether differently
This is because when you are on the Match Columns tab, you get to confirm which columns should be matched to which fields (Progress Trackers and Fields) on Makerble
There’s an advantage in setting your column titles as identical to the Progress Tracker names, because Makerble will automatically match up those columns to those spreadsheets using character-matching. But you can override those choices as you see fit.
For more information on the distinction between your Progress Trackers and the way they appear to respondents in a survey, refer to this article:Metrics versus Survey Questions: 3 key points to understand the difference between them

...