Import surveys from MS Forms

Use our MS Forms integrations to access and analyze all your quantitative data in Marvin. Search across thousands of survey responses, make notes on the data and add participant information to the Research Panel. Read on to find out more.

Head over to the Integrations tab and look for MS Forms.

Once you click "Connect", you’ll see a pop-up window* to log in to your Microsoft Account. Remember that the integration only works with Microsoft work and school accounts.

*Please check that your browser settings allow pop-up windows.

Please enter your credentials and grant Marvin access to MS Forms to proceed.
​

You can also integrate your accounts the first time you try to import surveys from MS Forms.

In any project, navigate to “Add new files”, select “Surveys”, and then click “Import MS Forms survey”.
​

Choose a personal or group survey. Click "Import" to proceed.

You can choose to import data from specific or all questions in the survey. Each question is imported as a separate column.

If you want to remove columns, uncheck the ones you want to leave out.

To begin, you need to identify the columns that contain participant data, such as names and email addresses. Marvin will auto detect the column using AI.

In case it hasn't detected it correctly, click "Select from all columns". Select any other column that you want Marvin to consider as responses for participant names

If you don't have the names of respondents, click "Survey doesn't contain respondent names" to proceed.

Similarly, Marvin will detect the column that contains emails.

To choose another column, click "Select from all columns".

If you don't have respondent emails, click "Survey doesn't contain respondent emails" to proceed.

You can also add these participants to your Research Panel in Marvin. We recommend you do this to maintain your participant database. You can also keep track of all the interactions each user has with the different teams and channels in your company.

Marvin will use AI to automatically categorize each question in the survey as open-ended, NPS, single choice, card sort, and ranking.

You can check the AI mapping for each question. Marvin will highlight the ones where you need to confirm the categorization. If Marvin has correctly identified the type of question, click "Yes".

To change the categorization, click "No" and choose the right type of question.

Complete the import once you've checked all the questions. You can also check and revise after the survey has been uploaded.

It may take a few minutes to complete the import. The task will continue running in the background even if you navigate away. You'll find the survey in the project files once the upload is complete.

You can view survey data in three convenient formats on Marvin:

In this tab, you’ll see all responses grouped by question. You'll see each question categorized as participant data, a single/multi-choice response, NPS, or an open-ended response.

Select a question in the left panel to see all the corresponding responses in the right panel.

You categorize questions while importing surveys. You can change this at any point if you chose incorrectly while importing.

You can visualize all close-ended responses as raw data, pie charts, or bar graphs.

Add these graphs to Insight reports to share key data with other stakeholders.

Marvin will create notes for each open-ended response. You can add labels to categorize them. Combine these survey notes with other project notes on the Analyze tab.

Use this view to see all responses from a single participant on the right. Scroll through participants on the left.

In this tab, you can view close-ended responses from all participants in a single table on the left. You’ll see open-ended responses as individual notes on the right when you click on a participant name.

To know more about analyzing surveys in Marvin, check out our help center article.