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 "Next" 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 choose to automatically update survey data, Marvin will fetch responses twice a day.

All the data you import from a survey is segmented into three parts:

Participants names and email addresses are participant data. If the survey collects respondents' emails, Marvin will automatically identify it. Otherwise, you can select which column it should consider as the participant emails.

You can also choose to automatically add participant data from this survey to your Research Panel.

Let Marvin know which questions in the survey are open-ended. Choose the questions that have qualitative data. These answers are subjective and are usually unique to each participant.

All the remaining questions or columns will be imported as survey metadata. This is usually quantitative data. You can filter by metadata while analyzing the survey.

Once you’ve segmented your survey responses, you’ll see a confirmation screen. Click "Confirm import" to go ahead.

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.