Enable filtering the results in Microsoft Forms
*English follows Japanese
■Title(件名):
回答結果のフィルタリング機能について
Enable filtering the results in Microsoft Forms
■Description(内容):
Microsoft Forms では、Forms 上の回答結果の確認画面にてフィルタリングを行う事ができず、全ての結果のみ確認可能です。例えば、複数の部署からの回答がある場合、部署ごとの回答結果をまとめることが出来ません。Excel に出力した際にはフィルタリングは可能ですが、Forms 上でもフィルタリングが行えるとより良いです。
そのため、Forms 上の回答結果の確認画面においてもフィルタリングを行える機能の実装を要望いたします。
In Microsoft Forms, it is not possible to filter the form results from view results page. We only can view all the results unsorted.
For example, even though there are results responded by multiple departments, we cannot compile the results for each department.
We can export the form results to Excel file and filter the results but it is more convenient if we could do the same on Forms.
Therefore, I hope the Filter feature will be implemented to view results page as well.
Thank you for your consideration.

9 comments
-
Anonymous commented
Hi,
All of your reply wishes can be sorted and filtered in seconds with Excel. Don't expect a survey to do all the work that Excel was made for. All replies are asking for filtering by time, date, or location, etc. You can filter by every "Forms" question in Excel. Every question becomes a column.
Please remember as in one comment below, that this is one of the best "data collection" survey's in the world. Excellent collection, pretty good quick and easy view charts and graphs, and exports quick and easy to Excel for all the analysis you could ever want. Remember what is is made for.
PS If you start to create your survey in a Sharepoint Onedrive, it will always keep your Excel data, your charts, your tabs / pages, pivot tables etc intact, and live.
It is awesome!! -
Anonymous commented
Being able to filter the results is crucial. Also sorting the results backwards (last entry first) would be a great improvement, as most questions we get relate to the most recent entries. Now this requires exporting the results to Excel.
-
Cheryl Hooper commented
An absolute must if we are going to go with Forms as our main survey tool!
We need to be able to filter responses by location, or other characteristics/responses to questions. -
Paulius setiawan commented
Killer feature !!!
I am more interested in filtering it by the creation date.
-
Anonymous commented
This form filtering function would make this form the ultimate in data collection tool on the market. This form is one of the best that I have used in the "Survey World"
-
Anonymous commented
Me too! Need this functionality.
-
Jenn Clegg commented
I am requesting this feature as well.
-
Palak commented
I have a similar request. I would like to filter based on a date range that they completed the survey. This is especially useful for ongoing surveys. Being able to filter and download multiple reports based on certain responses (not open text) would be extremely useful.
-
Bridgette commented
I have a similar request. I would like to filter based on a date range that they completed the survey. This is especially useful for ongoing surveys. Being able to filter and download multiple reports based on certain responses (not open text) would be extremely useful.