question

MarwaMostafa-8996 avatar image
0 Votes"
MarwaMostafa-8996 asked ·

Is there a way to export a specific view having groups as is to excel in SP2016?

Hello,

Our case is that we have SharePoint 2016 and we have custom lists/libraries with views including filtering and grouping.

When we open these views and export to excel, the excel shows data without filtering or grouping so is there a way so as to have the excel identical to what we see in the system?

Or is there some other action to do to achieve this function?

Thank you
Best Regards,
Marwa Mostafa

office-sharepoint-server-developmentoffice-sharepoint-server-customization
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

sadomovalex avatar image
0 Votes"
sadomovalex answered ·

it works like you described by default, but there is workaround for this problem: SharePoint List View - Export to Excel with Formatting and Grouping.


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered ·

Hi @MarwaMostafa-8996 ,

Per my test,the Export to Excel function exports data according to the view you choose.Even if you filter on the view of all items, all the data of this view will be exported rather than the data filtered.

So if you want to do a filter, you could create a new view in which only the items you want are displayed. Then the exported item will be the item you want:
74092-2.jpg

And group is currently not supported to be exported to excel. As suggested in the post sadomovalex mentioned, you could create a new view(filtered),export to excel and try to set the grouping in excel:
74084-3.jpg


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


2.jpg (64.9 KiB)
3.jpg (14.1 KiB)
· 2 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

And isn't there any other way to export the grouped view even if not in excel (in any other format)?

Thank you
Regards,
Marwa

0 Votes 0 ·
ElsieLu-MSFT avatar image ElsieLu-MSFT MarwaMostafa-8996 ·

Hi @MarwaMostafa-8996 ,

In fact, the export to excel function can only export all columns so far. You could export filtered items by creating a new view as a workaround. However, exporting grouped views directly from the list is currently not supported. What can be done at present is to do some settings in excel to achieve the goal.

I would suggest you go to this SharePoint UserVoice to vote, comment or make your suggestions.

============================
If my answer is helpful, please click "Accept Answer" and upvote it. :)

Thanks,
Elsie Lu

0 Votes 0 ·