How can I Extract Data from Survey Monkey

[Kealkil4]

Has anyone got experience on how to get data from Survey Monkey into Power BI Desktop?

[deannarscott]

Good Morning,

I wanted to let you know that SurveyMonkey now has a Certified Power BI Data Connector. You may access it here in the SurveyMonkey App Directory. https://www.surveymonkey.com/apps/qL5WNYqHKY6GGeqJjDA1YA_3D_3D/details/

[DavesBI]

I use EXCEL (2016) to get my survey results. (Insert > Store "Scroll down or search for the Survey Monkey add-In" follow instructions). Then run a macro to convert to a table and refresh. This file then feeds to Power BI where a cross analysis with other data sets (such as income). It's a very good way to analyse customer insights and check to see if there is a correlation on sales / customer service. You can react in near real time when customers are displeased or when income is low.

[mtmcd]

Hi Dave - can you share the macro to convert the survey monkey export to a table?  There is always a lot of transposing to do before being able to analyze in Power BI

[v-ljerr-msft]

Hi @Kealkil4,

There is no Content Pack or Connector for Survey Monkey currently as smoupre mentioned above.

However, from one comment of Mike Snow in the idea here, you should be able to get data from Survey Monkey into Power BI Desktop in a indirect way currently: First export data to CSV from Survey Monkey, import it to a worksheet, and then consume the worksheet with Power BI.

Could you go to check if it works?

Regards

[Kealkil4]

I have committed to Analyse the results of a Survey for a group to which I belong.

I will try the CSV route once the Survey replies are complete, and will advise on how I get on.

Kealkil4.

[Greg_Deckler]

A bit surprisingly, there is no Content Pack or connector for Survey Monkey, you can vote for the Idea here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13946139-integration-to-survey-mo...

This one is Under Review:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7052904-ability-to-grab-data-from...