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.


How do you interpret individual Gabor-Granger results from Excel?

To interpret individual Gabor-Granger results from Excel, see below image. Please note:

  • “No” means that the respondent indicated that they would not be willing to purchase the product at all
  • “Yes” means that the respondent indicated that they would be willing to purchase the product but not at any of the presented prices
  • The number value indicates the highest price that the respondent would be willing to pay for the product

Interpreting the individual results from a  Gabor-Granger test in Excel

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 6 October 2019. If there is anything else you'd like to know, please do not hesitate to contact us.