Hello, Is it possible to export to excel, only the data present in a SharePoint view and not all items? thanks, Sherazad

Hello Sherazad! You can absolutely do that. Here are the steps: In the SharePoint list in question, select 'view' (top right) and then from the drop-down choose the view that filters the data you want. Then apply it. In Modern experience, look for the export button in the toolbar and select 'Export to Excel'. You will have a .iqy file that downloads. Open it IN Excel and it will ONLY show the data visible in the view you chose. Then, in Excel, click 'Save As' and save it as a .xlsx. Please take the time to accept the answer so others are able to use the solution in the future :)

Exporting on data present in a SP view

Accepted answer

Samantha St-Louis 195 Reputation points

2025-01-17T19:51:19.06+00:00
Hello Sherazad!

You can absolutely do that. Here are the steps:

In the SharePoint list in question, select 'view' (top right) and then from the drop-down choose the view that filters the data you want. Then apply it.

In Modern experience, look for the export button in the toolbar and select 'Export to Excel'.

You will have a .iqy file that downloads. Open it IN Excel and it will ONLY show the data visible in the view you chose.

Then, in Excel, click 'Save As' and save it as a .xlsx.

Please take the time to accept the answer so others are able to use the solution in the future :)
Please sign in to rate this answer.

1 person found this answer helpful.
Ling Zhou_MSFT 21,015 Reputation points Microsoft Vendor

2025-01-20T05:34:51.8666667+00:00

Hi @Sherazad Ahmed,

Thanks for reaching out to us. We are very pleased to support you.

According to the information you provided and the research I have done, I may understand that you want to export all the items under a particular view in SharePoint Server. If there is anything wrong, please correct me.

If there is not anything wrong, it is suggested that you please try Samantha St-Louis's solution.

If you have problems with exporting your data, please do not hesitate to contact me.

Moreover, if the issue can be fixed successfully, please click "Accept Answer" so that we can better archive the case and the other community members who are suffering the same issue can benefit from it.

Your kind contribution is much appreciated.

Ling Zhou_MSFT 21,015 Reputation points Microsoft Vendor

2025-01-24T06:17:34.59+00:00

Hi @Sherazad Ahmed,

I hope you are doing well.

I am writing to confirm if you had a chance to review this answer.

I would greatly appreciate an update when time allows, since your input is crucial for the whole troubleshooting progress.

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

If it doesn't work, please let us know the progress.

By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Sherazad Ahmed 71 Reputation points

2025-01-24T14:00:18.1766667+00:00

Thank you for the information Samantha. It worked. There was a delay because for some reason, when you first posted the response, I was unable to view all of the comment.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Exporting on data present in a SP view

0 additional answers

Your answer