Exporting as an Excel Workbook

Follow these steps to export the results of your Conjoint.ly experiment to an Excel workbook.

1. Add outputs to export

Select which outputs you would like to add to export by navigating to each output and clicking on the “Add to export” button. Alternatively, click on the “Export analyses” button at the bottom of the page to open the analysis cart with respondent information, conjoint data, and data dumps automatically added.

add output to export

2. Open analysis export cart

Click on the Export analyses button at the bottom of the screen in the insights tab to open the analysis export cart. Here you will be able to see all the outputs you have added to export.

check the outputs in the analysis cart

You can also add respondent information, conjoint data, data dumps, and an interactive simulator through on the “Add more outputs” dropdown menu.

check the outputs in the analysis cart

3. Export as Excel

Once all the desired outputs have been added to the cart, click the “Make Excel file” and Conjoint.ly will compile the download file.

This process can take a few seconds. When the file is ready, click on the “Download it now” button on the sidebar to download the Excel workbook.

Export the PowerPoint presentation

Can I export a simulator for BPTOs

Brand Price Trade Off Simulator

With Conjoint.ly, you can now export the Excel simulator for Brand Price Trade-Offs. The Excel simulator allows you to calculate the preference share of up to 150 SKUs, at varying prices, both before and after an adcept is shown.

How can I get Conjoint.ly’s Excel Plugin

Conjoint.ly Excel Plugin

To improve your Excel charting experience, the Conjoint.ly Excel Add-in is now available online. The add-in contains multiple functions that help with charting Conjoint.ly outputs.

Some of these functions include:

  • The ability to automatically recolour charts from data cells, for quick and easy chart-making
  • A function that enables quick calculation of the price elasticity of demand between two price points
  • A button that transforms conditional formatting to static formatting with ease, allowing you to combine multiple forms of conditional formatting.

Download Excel Plugin

How do I get individual partsworth for each respondent

To view individual partworths for each respondent, ensure that “Conjoint data” is included in your export cart.

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

To find the utility for “None of the above”, look for the “ASC Opt-in” column:

How do I download additional question answers for each respondent?

To download additional question answers for each respondent, make sure that “Respondent info” is included in the analysis cart when you export.

Each row represents one participant who responded to the survey. Respondents are identified through the ID in the row participant_id.

Note that this sheet includes respondents that were not included within the analysis. Respondents may be excluded for a variety of reasons, including low-quality responses or being disqualified for not matching the survey criteria.

To filter by respondents who were only included within analysis for the report, filter the column status_included_in_analysis to only show participants with a value of 1.

Filtering excel output by those included in analysis

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

After downloading the Excel export with “Respondent info” included, navigate to the “Respondent” tab in the worksheet. You can then view the individual responses. Please note that:

  • 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