Forum Discussion
How can I Extract Data from Survey Monkey
Has anyone got experience on how to get data from Survey Monkey into Power BI Desktop?
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.
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
