Survey Data: Missing or duplicated variables during import

If individual variables are not correctly identified during the import of survey data from an Excel spreadsheet, one of the following problems may be the cause:

  • Variable names in MAXQDA are up to 63 characters long. If the Excel spreadsheet contains variable names that are longer, only the first 63 characters will be imported. Please ensure that the variable names differ in the first 63 characters, so that MAXQDA will be able to assign the values correctly.
  • Please check whether your Excel table contains unnecessary spaces at the end of variable names and delete them.

You can find detailed descriptions about importing survey data from Excel spreadsheets in MAXQDA in the “Survey Data from Excel” chapter of the online manual.

More FAQs