Suggested searches

Looking for a free online survey tool? offers a general survey tool with standard question types, randomisation blocks and multilingual support. Always free.

Get started for free
Request consultation

Do you need support in running a pricing or product study? We can help you with agile consumer research and conjoint analysis.

Request consultation

Excel Export of Conjoint Simulations now supports exporting simulation charts to Excel, to make it easier than ever to include your simulations into documents or presentation decks. Even the colours assigned in the online simulator will be carried over to the exported charts!

This walk-through demonstrates how to export beautiful charts from the simulator in less than two minutes.

To follow the instructions, navigate to your experiments page and open the Report for Example experiment 8: Subscription plan optimisation for a streaming service.

Step 1 - Assign colours to SKUs

Within the online simulator, assign colours to your tested SKUs in a meaningful way. Here we have two separate brands, so we are assigning all SKUs of one brand different shades of red, and the other different shades of blue.

Online simulator for conjoint analysis

Step 2 - Check revenue/profit calculations

Specify the formula used in calculating the revenue/profit. Here we are going to follow’s default formula for a market index of 1000 products.

Revenue and profit projections with online tool

Step 3 - Export simulation charts

Under the market overview tab, select export to Excel. Enable the option to export simulation charts. This will only take a couple of minutes.

Export conjoint simulator to Excel

Step 4 - Open excel file

Moving to the simulation tab, we see that the preference share graph has already been built, following the colours specified in the online simulator.

Preference share in excel

Step 5 - Create revenue graph

Now let’s also create the revenue graph from scratch. We will select all of the revenue data and insert a new stacked column chart. Using the Excel Add-in, we will:

  • Use the function Re-colour chart from cells to apply the colours set in the online simulator to our new chart
  • Use the function Hide Zeros to hide all values approaching zero, to remove clutter from the charts.
Revenue graph styling

Step 6 - Insert graph into presentation deck

Finally we can add turn out charts into a presentation slide. By simply adding titles, the charts are transformed into a professional looking presentation slide.

Powerpoint slide with profit and revenue

Would you like to try new excel export functionality? Log in to explore simulation reports.

Ability to export simulator for BPTOs

Brand Price Trade Off Simulator

With, 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.’s Excel Plugin Excel Plugin

To improve your Excel charting experience, the Excel Add-in is now available online. The add-in contains multiple functions that help with charting 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