Extract filtered data from Microsoft Form

Question

Hello,

I have a Microsoft form, shared with many people every day. The answers are collected and gathered in an excel file (normal).

I would like to extract these data to make separate and filtered excels (and also automatically updated when new answers arrive).

For example:

In my form, there is an answer "A" and an answer "B".

I have a team to analyze the "A" answers and another one to analyze the "B" answers.

But these teams do not have to access each other's responses.

How to provide an A file to team A and a B file to team B that is updated each time a new response is submitted?

We could do it with Google Forms but for technical reasons we have to switch to Microsoft Forms.

Any help/advice would be very useful.

Thanks in advance

Answer 1

Hello Igor,

I tried it and it works but for a small volume of data. The forms file will be fed day after day and the data will keep growing.

After a while my excel files (to be shared) took several minutes to open, and finally now it doesn't open anymore (even though I work online).

Unless I'm doing something wrong, I'll unfortunately have to give up on the idea.

Thanks for the help anyway

Answer 2

Hello Fabien,

We apologize that we couldn’t provide a proper solution for this scenario.

If you would require assistance, feel free to post back to us and we will do our best to help you.

Thank you for your time and patience.

Best Regards,

Igor | Microsoft Community Moderator