How to export results for individual respondents into Excel?


You can download the report in Excel from the “Excel export” button;

  • Select the “My experiments” option from the left-hand menu.
  • Under the “Experiment Status” column of the displayed table, select the “View report” link in the row corresponding to the survey data you wish to export.
  • In the “Market overview” tab, select the “Excel report” button on the right-hand side of your screen.

Exporting raw data from Conjoint.ly report into an Excel file


How do I get individual partworths for each respondent?

To view individual partworths for each respondent, you can export the report as an excel file using the “Excel Export” button (as shown above) and have a look at the “individual preferences” tab.

In order to understand the meaning of these coefficients in a brand-specific conjoint, let’s take a look at Example experiment 2 in your experiment list:

  • Column ASC: Opt-in is the reverse value of “None of the above” option. A higher opt-in value means that the respondent is less likely to select the “None of the above” option.
  • Preferences for brands are highlighted in columns B2 to B4. In this case, preferences for column B1 (Landrange Hoover) are not shown / set to 0 (because it is a dummy variable / point of reference for brands)
  • Similarly, preference for levels are highlighted in subsequent columns. The columns highlighted below (B1A2L2 and B1A2L3) represent the preferences for price of Landrange Hoover, where:
    • B1A2L1 = Not shown / 0 (because it is a dummy variable / point of reference for prices)
    • B1A2L2 = Preferences for Landrange Hoover price of $23,000
    • B1A2L3 = Preferences for Landrange Hoover price of $25,000

Where can I find the utility for “None of the above”?

The utility for “None of the above” can be found in Excel report, under the “Individual preferences” tab under the “ASC Opt-in” column. —–


Are there other output formats available?

You can also download your raw data in JMP output;

  • Select the “My experiments” option from the left-hand menu.
  • Under the “Actions” column of the displayed table, select the down-pointing arrow in the row corresponding to the survey data you wish to export.
  • Select “Export to JMP” from the dropdown menu.

Exporting raw data from Conjoint.ly report into JMP output


This question from our users was answered on 26 September 2019, updated on 6 October 2019. If there is anything else you'd like to know, please do not hesitate to contact us.