Forum Discussion
How to export only the filtered items in the sharepoint online list.
Here we have a lot items in the SharePoint List. When I apply a filter to any of the columns in the list, and for example, 10 results appear, when I click “Export to Excel”, it exports the entire List (ie 1440 rows), and not just the 10 results. Is there a way to export only the 10 results? Please advice.
Unfortunately, this is not possible using SharePoint default "Export to Excel" functionality.
However, you can develop your own custom list view command set (button in command bar) to export the selected/filtered list items.
Check below link (s) as reference for similar solutions:
- SPFx Export Selected Items to Excel - ListView Command Set
- Overview of the SharePoint Framework
- Build your first ListView Command Set extension
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
