Can I Upload Existing Excel Data to Qualtrics

Importing survey information and other structured data from Excel spreadsheets

With MAXQDA you lot can import structured documents from an Excel spreadsheet in XLS/S format, during which individual table cells volition be automatically coded. In improver, variable values can be assigned to the individual texts. This is particularly useful when importing (online) surveys with standardized and open answers.

How should the Excel table be structured?

When imported into MAXQDA, each row of the table becomes a new document, wherein the contents of the cells grade the document content and are coded with the corresponding column header. The structure of the Excel tabular array corresponds to the principle of a data matrix of a standardized survey. This logic is illustrated in the table below:

Certificate Group	ID [Certificate Name]	Positive Feedback [Open Question 1]	Negative Feedback [Open Question 2]	Age [Variable 1]	Pre-knowledge [Variable 2]
Group A	Person 1	Great conference!	The catering was a chip tight	22	high
Group A	Person 2	Best keynote I accept heard in a long time		25	medium
Group B	Person 3	I peculiarly enjoyed the pre-conference workshop	none	21	medium
Group B	Person 4	Great chore – keep going!	Please make workshops longer in the future	31	depression

Each row of the table contains a instance, and the columns "Open Question one" and "Open Question 2" comprise the respondent's responses to the respective questions. The "Variable" columns contains standardized information for each case in the grade of variables. Of particular importance are the first two columns "Certificate group" and "Certificate Name", which assign the individual rows of the table to documents in MAXQDA'southward "Document System".

Please annotation: 1. It is not admittedly necessary to accept a column for the "Certificate Group" as MAXQDA can also create a new document group, into which all documents are imported, during the import procedure. Still, at least one cavalcade is required, which contains the document name.
2. MAXQDA supports i sublevel for document groups. These can exist created and addressed during import using the backslash, due east.g. "Survey\New York". 3. The column headings should exist short and concise, every bit this is much more practical for further work and MAXQDA only imports the first 63 characters of the headings. But if the column headings differ in the first 63 characters, MAXQDA will exist able to handle the columns as different.

Starting the import process

To import Survey data from an Excel file, go to the Import tab and select the Survey data> Import information from Excel spreadsheet function. You lot can likewise import documents from an Excel spreadsheet on the Import tab from Excel spreadsheets. In principle, nevertheless, both calls lead to the same result.

Selecting import settings

Afterward calling up the function, the desired Excel file must be selected from the file dialog box. This opens a window where you can enter the settings for the import.

The two top settings determine which columns contain the Certificate Group and the Document Name. If the names "Document group" and "Document Name" are used in your tabular array as column headings, MAXQDA volition automatically select them, but this selection can be changed at any time.

If yous select [Create new document group] for the entry "Document grouping", MAXQDA volition automatically import all documents into a new document group. MAXQDA automatically selects this pick, if your table doesn't contain a column with the heading "Document Grouping".

Tip: When importing survey information, it is recommended that you select the ID'southward of the respondents as a cavalcade for the document names. In this way, yous can avoid any ambiguity in the association of responses to cases, even during the subsequent consign of data into statistical software.

In the centre section, you can select the columns to be imported as coded text or as variables.

If both "Code" and "Variable" are selected, MAXQDA will import the contents of this column every bit both as coded text and as a variable. This may be useful, for case, you do not wish to view the variable information of a certificate each time equally a tooltip over a document proper noun or in the Data Editor for document variables, but rather view, for example, how old a respondent is and whether he has children, directly in the text.

Please note: When the dialog box opens, MAXQDA will have marked all the columns in the Excel table which vary a lot as coded text, since these are about likely to be responses to open questions.

If neither "Code" nor "Variable" are selected, MAXQDA will ignore the cavalcade during the import process.

In the lower section, farther options are available:

Code empty cells: When this option is selected, MAXQDA will import and code cells without content as empty paragraphs; these cells would otherwise not be coded.

You lot tin can as well make up one's mind how MAXQDA should handle documents that were already included in the project before the import. MAXQDA considers that a document already exists in the project if the document name and document group are identical.

Import: When this selection is selected, existing documents will be included in the import, and therefore may announced twice in the respective document group.

Ignore for import: Select this option if documents that already exist in the project should not be taken into account during the import.

Add text to existing documents: Information technology is also possible to add text to existing documents. For example, data from different points in time in a longitudinal study tin can be added to the original certificate. Existing variable entries in existing documents volition be updated. Empty variable values in the Excel table are ignored when importing.

Delight annotation: For documents whose proper noun appears repeatedly in a document grouping, the text will exist added to the offset document of the aforementioned name.

Selecting other settings for importing variables

If you lot cull to import variables, a 2d window will open after you click OK.

Source: Past selecting this option, you can over again decide which variables will be imported.

Target: If at that place is already a document variable with the same name in the projection, MAXQDA assigns the variable to it automatically and no other choice is available. If there is no variable with the same name in the project, you can specify the type of variable. Options include: Boolean (true/false), date/time, decimal, integer, and text.

Preview data blazon: This column displays a preview of how an entry will appear in the advisable column in the information editor.

A concluding report window confirms the import of documents from the table and lists how many texts, codes, and variables were imported, as well as how many documents may have been ignored during the import.

Imported texts in MAXQDA

After importing the tabular array from the example into an empty MAXQDA project, information technology will announced as follows:

When importing, MAXQDA proceeds as follows:

• Document groups that do not yet be volition exist created.
• The headings of the code columns will run from left to right and will be inserted from top to lesser in the code system as new code names, as long every bit they do non yet be. All text segments from the code columns will be coded with the respective column headings. The consummate heading of each column is recorded in the code memo.
• If a variable does non nevertheless exist, it will exist created. Each certificate volition exist assigned the variable value from the variable column.

In the section "Categorize Survey Data" you will detect data on how to analyze the imported survey data in MAXQDA.

taylorfacce1988.blogspot.com

Source: https://www.maxqda.com/help-mx20/import/importing-text-from-a-tablespreadsheet-e-g-answers-to-open-questions

Share this post