Problem with exporting "or_other" data


I created a multiple choice field, with an ‘Other’ option. The type is “select_multiple need or_other”. On the form itself, the questions works as expected, as a text field appears to enter the ‘Other’ value if selected. This data seems to be captured, as this new ‘other’ column can be seen on the online Data Table from the ‘Projects’ section. However, when exporting the collected data as either ‘XLS’ or ‘CSV’, the value from the ‘Other’ column is not exported at all

Steps to Reproduce

  1. …Create a form with a multichoice question type with the ‘or_other’ modifier.
  2. …Add some data to the survey, including ‘Other’ values
  3. …Export this data as ‘XLS’ or ‘CSV’

Expected behavior

I expect to have the values collected by the ‘Other’ field, present as a new column on the exported data

Actual behavior

The column ‘Other’ does not seem to be exported

Additional details

The data seems to be collected, as this column appears on the online Data Table.

  • What should topics in this category generally contain?

  • Do we need this category? Can we merge with another category, or subcategory?

Hi @ibagur,

Welcome to the community! We would advise uses to use the following method to handle other responses as outlined in the support article User-Specified “Other” Responses for Multiple-Choice Questions. This method of using the other should solve your issue.

Besides, it seems that you are using the following method as outlined in the image below:

In the survey tab of your xlsform:

In the choices tab of your xlsform:

Reference xlsform:
or_other examples.xlsx (10.9 KB)

When using the xlsform, you are not able to download the other that has been captured while collecting data. As a reference, please see the image shared below (where data is being downloaded as XLS version):

However if you try downloading your dataset as xls (legacy) you should be able to download the same. As a reference, please see the image shared below:

Hence request you to use this method to download your dataset with other that you have captured.

Have a great day!