Here we will show you how to do upload data to Intellectus from Qualtrics.

There are three steps to follow when creating a new project by uploading data from Qualtrics:

  1. Downloading the data
  2. Preparing the data
  3. Uploading the data

Downloading the Data

Intellectus allows users to import data from various types of saved files, including comma-separated (.CSV), Excel (.XLSX), SPSS (.SAV), Statistical Analysis Software (SAS), and Stata (.DTA).

The image shows the 5 data types supported by Intellectus.

Qualtrics allows users to export data in a variety of formats. Although Intellectus Statistics accepts a few of these, we suggest downloading your data as either an Excel (XLSX) file or a Comma Separated Value (CSV) file. For simplicity, we will walk you through how to download, prep, and import your data using an Excel file.

To download your data from Qualtrics, follow the steps below:

Step 1: Under “Data & Analysis,” select the “Data” tab.

User is selecting the data tab with is within the data & analyses tab.

Step 2: Here you will find the option to “Export & Import” data. Selecting this prompts a dropdown with the option to “Export Data…”. If you cannot find this tab you may either (a) have a free account that does not allow data export, or (b) have an institution or work account and need to request permission from your brand administrator.

User is selecting the export option which is located inside the export & import menu.

Step 3: Select the type of file you would like to download. In this example, we will be using an Excel file. Once selected, click download at the bottom of the page.

The user has selected to download all fields and use choice text. The user is then clicking download.

Preparing the Data

Step 1: After downloading your file from Qualtrics, within your zip file you can open your saved data. If prompted, select “Enable Editing.”

User is disableing protected view in Microsoft Excel Sheets by selecting enable edting.

Step 2: To prepare your data for use in Intellectus Statistics, make sure your dataset is organized into columns with the variable names at the top and that all data pertaining to a single participant is entered into only their one corresponding row in the worksheet. You may notice that at the top of your Excel file there are a couple of extra rows above your data, one stating the question number and the other with the question itself. Delete these rows, and in their place add the variable names. Qualtrics also exports data with several extra columns. Only retain the columns that you wish to conduct analyses on and delete the rest.

Before:

The data before cleaning it up. It contains extra columns and rows.

After:

The data after cleaning. Only the necessary rows and columns are presnt.

Step 3: Save your changes.

Uploading the Data

Once you have the Excel file prepped, you can sign in to Intellectus Statistics. After logging in, follow the steps below to upload data to Intellectus from Qualtrics:

Step 1: Navigate to the “Projects” tab.

User is selecting the projects tab from the left most naviagtion bar in the intellectus statistics application.

Step 2: Click the “Upload a Data File” button in the “Create a Project” panel.

In the create a project panel of intellectus, the user is selecting the upload a data file button.

Step 3: Specify how you would like your file saved after downloading your data as Qualtrics supports multiple file types. Click the option that reflects your save file type.

The image shows the 5 data types supported by Intellectus.

Step 4: Click “Choose File” and find the file you would like to upload. After selecting the data file, click “Upload File.”

In the new project window, the user has already choosen the file that they would like to upload and is clicking upload file.

If you are having trouble uploading your file into Intellectus Statistics, check to make sure your document is not in “Protected View.” If your document is, you can open your save file and “Enable Editing.”

User is disableing protected view in Microsoft Excel Sheets by selecting enable edting.

Step 5: Intellectus will autodetect which level of measurement you used. If this is done incorrectly, or if you would like to change the measurement type, select the correct one from the drop-down underneath the heading “Level of Measurement.” Within this drop-down, you also have the option of managing your data. Here you can add, merge, and delete the levels of your variables.

In the levels of measurement window, all the variable names are listed on the left. For each variable there is a drop down on the right allowing the user to select the level of measurement and manage the variable.

Step 6: Click “Continue,” and then you are ready to start analyzing your data!

Want more information? Consider checking out these related posts:

What level of measurement should I choose for my analysis?

What do you mean by nominal, ordinal, and scale level variables?

Uploading Data to Intellectus From Survey Monkey

Uploading Data to Intellectus From Google Forms

Here we will show you how to do upload data to Intellectus from Survey Monkey.

There are three steps to follow when creating a new project using data from Survey Monkey:

  1. Downloading the data
  2. Preparing the data
  3. Uploading the data

Downloading the Data

Intellectus allows users to import data from various types of saved files, including comma-separated (.CSV), Excel (.XLSX), SPSS (.SAV), Statistical Analysis Software (SAS), and Stata (.DTA).

The image shows the 5 data types supported by Intellectus.

Survey Monkey allows users to export data in a variety of formats*. Although Intellectus Statistics accepts a few of these, we suggest downloading your data as either an Excel (XLS) file or a Comma Separated Value (CSV) file. For simplicity, we will walk you through how to download, prep, and import your data using an Excel file.

*Only paid plan users are allowed to export data from Survey Monkey.

To download your data from Survey Monkey, follow the steps below:

Step 1: In Survey Monkey, navigate to “Analyze Results.”

In the navigation tab of Survey Monkey a user is selecting the analyze results section.

Step 2: In the upper right-hand corner, click: “Save As” > “Export file” > “All responses data.”

User is selecting all responses data from the save as drop down in survey monkey.

Step 3: The default selections are “XLS,” Condensed,” and “Actual Answer Text.” For our purposes, we will leave these as are. Click “Export.”

User is using the export data option in survey monkey to save their file as an excel file.

Step 4: Now that Survey Monkey has generated the export file, a notification will pop up in the right-hand corner of the screen. Here you can click “Download.”

There is a message signifying that the Export is complete and the user has the option of downloading the data.

Preparing the Data

Step 1: After downloading your file from Survey Monkey, within your Zip folder you can open your saved data. If prompted, “Enable Editing.”

User is disableing protected view in Microsoft Excel Sheets by selecting enable edting.

Step 2: To prepare your data for use in Intellectus Statistics, make sure your dataset is organized into columns with the variable names at the top and that all data pertaining to a single participant is entered into only their one corresponding row in the worksheet. You may notice that at the top of your Excel file there are a couple of extra rows above your data, one stating the question and the other stating the type of measurement. Delete these rows and in their place add the variable names. Survey Monkey also exports data with several extra columns. Only retain the columns that you wish to conduct analyses on and delete the rest.

Before:

The data before cleaning it up. It contains extra columns and rows.

After:

The data after cleaning. Only the necessary rows and columns are presnt.

Step 3: Save your changes.

Uploading the Data

Once you have the Excel file prepped, you can sign in to Intellectus Statistics. After logging in, follow the steps below to upload your data to Intellectus from Survey Monkey:

Step 1: Navigate to the “Projects” tab.

User is selecting the projects tab from the left most naviagtion bar in the intellectus statistics application.

Step 2: Click the “Upload a Data File” button in the “Create a Project” panel.

In the create a project panel of intellectus, the user is selecting the upload a data file button.

Step 3: Specify how you would like your file saved after downloading your data as Survey Monkey supports multiple file types. Click the option that reflects your save file type.

The image shows the 5 data types supported by Intellectus.

Step 4: Click “Choose File” and find the file you would like to upload. After selecting the data file, click “Upload File.”

In the new project window, the user has already choosen the file that they would like to upload and is clicking upload file.

If you are having trouble uploading your file into Intellectus Statistics, check to make sure your document is not in “Protected View.” If your document is, you can open your save file and “Enable Editing.”

User is disableing protected view in Microsoft Excel Sheets by selecting enable edting.

Step 5: Intellectus will autodetect which level of measurement you used. If this is done incorrectly, or if you would like to change the measurement type, select the correct one from the drop-down underneath the heading “Level of Measurement.” Within this drop-down, you also have the option of managing your data. Here you can add, merge, and delete the levels of your variables.

In the levels of measurement window, all the variable names are listed on the left. For each variable there is a drop down on the right allowing the user to select the level of measurement and manage the variable.

Step 6: Click “Continue,” and then you are ready to start analyzing your data!

Want more information? Consider checking out these related posts:

What level of measurement should I choose for my analysis?

What do you mean by nominal, ordinal, and scale level variables?

Uploading Data to Intellectus From Google Forms

Uploading Data to Intellectus From Qualtrics

Here we will show you how to download, prepare, and upload survey data from Google Forms and Google Sheets.

There are three steps to follow when creating a new project by uploading survey data from a Google Survey:

  1. Downloading the data
  2. Preparing the data
  3. Uploading the data

Downloading the Data

Intellectus allows users to import data from various types of saved files, including comma-separated (.CSV), Excel (.XLSX), SPSS (.SAV), Statistical Analysis Software (SAS), and Stata (.DTA).

The 5 data types supported by Intellectus.

To download your data from Google Forms, follow the steps below:

Step 1: Navigate to the “Responses” tab.

User naviagting to the respoonses tab on Google Forms.

Step 2: Click the more options button (three vertical dots) located to the right side of the number of responses. This will open a drop-down menu.

More options for responses tab in Google Forms, signified by three vertical dots.

Step 3: Select “Download responses (.csv)” from the list.

User selecting dowload responses (.csv) from the more options for responses menu.

To download your data from Google Sheets, follow the directions below:

Google Sheets offers two different types of save files that are compatible with Intellectus Statistics: Microsoft Excel (.XLSX) and Comma-separated values (.CSV). We suggest using the .XLSX file as it typically retains the most functionality.

To download, click:

“File” > “Download” > either “Microsoft Excel (.XLSX)” or a “Comma-separated values (.CSV)”.

User is choosing Microsoft excel as their download file format in Google Sheets.

Preparing the Data

Step 1: After downloading your file from Google Forms or Google Sheets, within your Zip folder you can open your saved data. If prompted, “Enable Editing.”

User is disableing protected view in Microsoft Excel Sheets by selecting enable edting.

Step 2: To prepare your data for use in Intellectus Statistics, make sure your dataset is organized into columns with the variable names at the top and that all data pertaining to a single participant is entered into only their one corresponding row in the worksheet. You may notice that at the top of your Excel file the first row states the survey question. Replace these with the variable names you wish to use. There may also be extra columns, such as a timestamp. Only retain the columns that you wish to conduct analyses on and delete the rest.

Before cleaning the data:

The data before cleaning it up. It contains extra columns and rows.

After cleaning the data:

The data after cleaning. Only the necessary rows and columns are presnt.

Uploading the Survey Data Into Intellectus Statistics

Once you have the Google file downloaded and prepped, you can sign in to Intellectus Statistics. After logging in, follow the steps below to upload your survey data:

Step 1: Navigate to the “Projects” tab.

User is selecting the projects tab from the left most naviagtion bar in the intellectus statistics application.

Step 2: Click the “Upload a Data File” button in the “Create a Project” panel.

In the create a project panel of intellectus, the user is selecting the upload a data file button.

Step 3: Specify the type of save file you choose when downloading your data. Data from Google applications can be exported as either “XLSX” or ”CSV.”

In the new project window, Intellectus asks what type of file you would like to upload, the user is selecting an XLSX file.

Step 4: Click “Choose File” and find the file you would like to upload. For Google applications, your save should be under either “.XLSX” or “.CSV.” After selecting the data file, click “Upload File.”

In the new project window, the user has already choosen the file that they would like to upload and is clicking upload file.

If you are having trouble uploading your file into Intellectus Statistics check to make sure your document is not in “Protected View.” If your document is, you can open your save file and “Enable Editing.”

User is disableing protected view in Microsoft Excel Sheets by selecting enable edting.

Step 5: Intellectus will autodetect which level of measurement you used. If this is done incorrectly, or if you would like to change the measurement type, select the correct one from the drop-down underneath the heading “Level of Measurement.” Within this drop-down, you also have the option of managing your data. Here you can add, merge, and delete the levels of your variables.

In the levels of measurement window, all the variable names are listed on the left. For each variable there is a drop down on the right allowing the user to select the level of measurement and manage the variable.

Step 6: Click “Continue,” and then you are ready to start analyzing your data!

Want more information? Consider checking out these related posts:

What level of measurement should I choose for my analysis?

What do you mean by nominal, ordinal, and scale level variables?

Uploading Data to Intellectus From Survey Monkey

Uploading Data to Intellectus From Qualtrics