Skip to main content

Upload and analyze CSV surveys

Include data from surveys stored in CSV files in your projects

Updated this week

Marvin can read survey data that is stored in CSV files and add it to your project. You can analyze responses, make notes on them and add participant data to the research panel.

Multiple apps allow you to export survey data in CSV files. Follow the steps in this article to include CSV survey files in a project in Marvin.

How do I import CSV files?

Please navigate to the project to which you want to add a survey.

  • In the "Files" tab, click "Add new files". Select "Upload survey".

You’ll see guidelines on how to prepare your CSV for upload. Once the file is correctly formatted, click ‘Browse file’ and upload it from your computer.

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

How Marvin segments survey data

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

  1. Participant data

  2. Open-ended questions

  3. Survey metadata

Participant data

Participants names and email addresses are participant data. You can let Marvin know which column to read as participant data.

You can also add these participants to your research panel in Marvin.

Open-ended questions

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.

Survey metadata

You’ll see an option to specify the date and time when the survey was created.

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.

Viewing the data in Marvin

Marvin presents all the survey data in three tabs – Summary, Individual Respondents and, Responses.

Summary

You’ll see all the data grouped by question in the Summary tab.

Individual respondents

Use this tab to view all the responses of one participant in a single table. Easily navigate between respondents by clicking on their name

Responses

To view all responses in one, easy-to-read table, head to the Responses tab. You can add file tags and edit data directly from the table.

Filter data

You have a few options to filter and analyze the survey data.

Click the drop down menu against "Filter responses by" to see filters for individual questions. You can choose to view data of specific responses to questions. You can apply multiple filters here. For example, you can focus on a data set of users who "Use your product twice a week" and are "Windows users".

Similarly, you can choose to see only the single-choice, multiple-choice, NPS or ranking responses when you click the drop down menu that says "Single choice".

Visualize data

Marvin can arrange all the metadata or quantitative data in a bar graph or pie chart (or notes in case of open-ended questions) when you click "Pie Chart". You'll see the open-ended responses or qualitative data as notes in case of open-ended questions. Use these notes for analysis and cross-project analysis.

You’ll also have an option to add a survey question as a field to the research panel.

Analyze with Ask AI

To derive insights, type in any questions and prompts into the Ask AI field. Marvin will search across questions to find you relevant answers.

You can use this to identify trends, patterns and outliers. Use it to speed up your analysis, focus on specific questions or participants, and surface hard-to-identify insights.

Did this answer your question?