Import Codes and Code Memos from Excel

MAXQDA can create a code system from the rows in an Excel spreadsheet. The reading of a code system from a table is useful when you want to define multiple codes in advance.

The first row of the table must include the keywords “Code” and “Memo”. Each additional row corresponds to a new code and associated Memo. In the “Code” column, you can define subcodes using a backslash “\”.

Tip: To insert a backslash “\” on a Mac, press option++7.

To start the import, select the function Import Codes and Memos from Excel Spreadsheet from the Codes tab.

Example

Code

Memo

Codename 1

Here is a text, e.g. with the code definition

Codename 1Subcode 1.1

Here is a text with the code definition

Codename 2Subcode 2.1Subcode 2.1.1

Here is a text with the code definition

 

When importing a table, MAXQDA proceeds as follows:

  1. Unless they already exist in the MAXQDA project, five codes are created: “Codename 1” and “Codename 2” are created at the top level. “Codename 1” is assigned the subcode “Subcode 1.1” and “Codename 2” is assigned the subcode “Subcode 2.1”, which in turn is assigned the subcode “Subcode 2.1.1”.
  2. In addition, each newly inserted code is assigned the corresponding text from the second column as a code memo.
  3. Code names and subcode names are each shortened to 63 characters.