How to export results for individual respondents into Excel?


The Conjoint.ly Excel Plugin helps with charting Conjoint.ly outputs, including simulations charts from the Conjoint.ly online simulator (scenario modelling and price elasticity charts), colouring for TURF analysis, and other useful utility functions.

You can download your survey 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.
  • Select the “Excel report” button in the bottom left corner of your screen

DExporting data from Conjoint.ly report into an Excel file

How do I download answers to additional questions by respondent?

The answers to the additional questions by respondent are available within the excel export under the “Respondents” tab.

The column participant_id lists a unique ID for each person who responded to the survey.

status_included_in_analysis is whether the individual respondent is included in the analysis. Respondents may be excluded because of low quality responses or disqualified for not matching the survey criteria. Click on the filter on this column and select only 1 to show only responses from participants who are qualified and included in the analysis.

Filtering responses by those included within the report

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.