Can You Edit Excel Sheets Uploaded Into Maxqda

In that location are several situations in which you might want to import certificate variables into MAXQDA, such every bit:

• If y'all want to analyze responses to open-ended questions in combination with the quantitative socio-demographic information that you acquired for each of those who filled out the survey. Usually, you will already have this quantitative information in a matrix of some sort, and re-entering that information into MAXQDA would just cause you unnecessary piece of work.
• If yous did statistical analysis on material that you exported from MAXQDA and at present desire to reimport the results of your statistical assay into MAXQDA. You could, for instance, have done a cluster analysis for 40 interviews and now desire to import the cluster assignments from each private interview.

Importing document variables from Excel

MAXQDA can import information from XLS/Ten files. The data must be organized as follows:

Document group	Certificate proper name	Variable 1	…	Variable Northward
Group 1	Text 1	Variable value for Text 1		Variable value for Text one
Group 1	Picture one	Variable value for Motion-picture show 1		Variable value for Picture i

The first ii column headers serve equally markers for assigning variable values to the documents and are required for successful import. Every row must have an entry for the document grouping and document name columns. Only if these exact group and document names are found in the "Certificate Organisation" of the MAXQDA project, will the variables and variable values be imported. You tin then include as many different variable columns as you wish.

Please annotation: The variable values for documents that do not belong to a document group tin also exist imported. In order to do then, the appropriate cell in the "Document Group" column must be left empty.

After preparing and saving the document, you can start the import procedure by going to Variables > Import Certificate Variables. Alternatively, yous tin click on the Import data (document variables) symbol in the "List of document variables."

A dialog field appears in which you can specify the source and target variables forth with the type of variables to exist imported.

MAXQDA does the post-obit during the import:

• All variables in the import file that did not yet be in the MAXQDA project are created.
• Variables that already existed will be updated with the new values in the import file.
• Empty values ("organisation missings") for variable types integer and decimal will be imported equally -999.

Tip: An easy way to prepare an Excel file for importing new values is to first export the variable data matrix as an Excel file past clicking on the Excel icon in the toolbar of the variable list. An Excel file with all of the current variables will open upward, and you can then add new columns for new variables and update variable values that you want changed. All yous have to do later that is save the Excel file and import it into MAXQDA.

Importing document variables from SPSS

You can likewise import a data matrix for the certificate variables from a SPSS data file (extension SAV). For the import MAXQDA needs to match the cases oft he SPSS data file with the document names in the opened MAXQDA project. Therefor it is necessary, that the data file contains a variable (a column) for the document grouping as well equally a variable for the document name.

1. Please start the import procedure by going to Variables > Import Document Variables. Alternatively, you can click on the Import data (document variables)  symbol in the Listing of Document Variables.
2. Then choose a SPSS data file in the appearing file dialog.
3. A new dialog will appear, that allows y'all to set several options:

In the upper part you can select which variables (= columns) contain the data nigh the document group and the document name to match the cases with the appropiate certificate name. MAXQDA volition choose the first ii columns of the SPSS data file, if the data file doesn't contain variables that are labelled with "DocGroup" and "DocName." You will detect the variable labels in brackets behind the variable names for better navigation in the list of variables.

Furthermore, you can switch on two additional options:

Import variable characterization instead of variable name – If y'all choose this selection, MAXQDA won't import the variable names, but their labels, which are usually longer and easier to read and to understand. You should apply this pick, if you want to import a SPSS data file that has been created past exporting the document variables from MAXQDA. Then it will be easy to update a variable which values have been changed in SPSS. Delight annotation that the length of variable names in MAXQDA is limited to 63 characters, so a longer proper name may be truncated.

Import value labels instead of values – normally, standardized answers will be represented in SPSS by numbers, e.thousand. a 1 may be used for "female" and a 2 for "male". If yous see these numbers only in MAXQDA without knowing what a "1" and "two" means, it won't be very useful, then this selection should just be deactivated if you are sure you lot want to import the values instead.

A dialog field appears in which you tin specify the source and target variables along with the blazon of variables to exist imported.

MAXQDA does the following during the import:

• All variables in the import file that did not notwithstanding exist in the MAXQDA projection are created.
• Variables that already existed will be updated with the new values in the import file.
• If you have defined missing values in SPSS merely the first missing value (divers in section "Discrete missing values" in the SPSS dialog) will be imported (just for variable types integer and floating).
• Organization variables won't be changed.
• If the import file contains identical document names in the same document group, the last case will overwrite the previous ones.
• Empty values ("system missings") for variable types integer and decimal will be imported as -999.

Importing lawmaking variables from Excel

MAXQDA can import data from XLS/X files. The data must exist organized equally follows:

Code	Variable 1	…	Variable N
Parent code 1Code 1	Variable value for code one		Variable value for code 1
Parent code 1 Lawmaking 2	Variable value for code 2		Variable value for subcode 2

The kickoff cavalcade heading is the unambiguous assignment of variable values to a code, so this column and its heading are mandatory. Each line must designate a code in the corresponding column. For subcodes, the entire path must be specified in the code system, in which the codes are separated by a backslash.

Tip: To insert a backslash "" on a Mac, apply the keyboard command option+⇧+7.

Merely when a code, which matches this data exactly, is found in the "Lawmaking System" will the variable be imported. You tin can add together as many variables every bit required in the subsequent columns.

After preparing and saving the import data, you tin so start the import procedure by going to Variables > Import Code Variables. Alternatively, you tin can click on the Import data (code variables) button in the List of Code Variables.

A dialog field appears in which you lot can specify the source and target variables along with the type of variables to exist imported.

MAXQDA does the post-obit during the import:

• All variables in the import file that did not still exist in the MAXQDA project are created.
• Variables that already existed will be updated with the new values in the import file.

Tip: An easy way to set an Excel file for importing new values is to first export the variable data matrix as an Excel file by clicking on the Excel icon in the toolbar of the variable list. An Excel file with all of the current variables will open up, and you can then add together new columns for new variables and update variable values that you want changed. All you lot have to do later that is save the Excel file and import it into MAXQDA.

angellshavithe.blogspot.com

Source: https://www.maxqda.com/help-mx20/variables/importing-data-excel-spss

Share this post