How to Export to Excel from a SharePoint 2016 Custom List view

Question

Hi,

we have a requirement that How to Export to Excel from a SharePoint 2016 Custom List view, by using the list tab export to excel ,it will be iqy extension which doesnt work in case of custom list.

Please help me how to achive this requirement,

Regards,
Abdulla

Answer 1

Hi @Abdulla Khan Pathan

This is a known issue in SharePoint. For that, a lot of people avoid custom lists in SharePoint (After using custom lists, some built-in functions may be restricted).

Please make sure you are not using special characters when working with custom lists.

You may run into this problem whether you are using a custom list or not. Avoid using special characters in the column names, such as #, @, %, etc. You may have to delete the column and recreate it without special characters before you can export the list to Excel.

In addition, a workaround is to:

Go to the Site Assets Library on the same site

Create an Excel file

Data > Get Data

Connect to SharePoint list

---

If an 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.

Answer 2

Dear @Itch Sun-MSFT ,

I have tried the above options but no luck, as when i tried to export from the other site list it is working, except the one list, and when exported to excel, while open the doc it throwing an error that "Cannot connect to the server at this time, Changes to your data cannot be saved"

It will be appreciate if we resolve this.