You can paste the URL to the list you’re wanting to import, but delete everything after the site’s name in the URL.ĥ. Do not select From Online Services > From SharePoint Online list (this option would be for O365 only and O365 users will not need this post’s workaround).ģ. Note: There are two SharePoint list options under Get Data. Navigate to the Data ribbon –> Get Data > From Other Sources > From SharePoint List Rather than export from SharePoint we are going to open Excel and import from SharePoint.Ģ. If you can’t download or use Internet Explorer (IE) you can still get your lists exported to Excel by working in reverse. Using Internet Explorer to open and export your SharePoint list might be the simplest way to export your list. To export a list, you must have a Microsoft SharePoint Foundation-compatible application.Ĭlicking “OK” only redirects you to page that is most definitely not an Excel export: The workaround But for those of you, like me, who are still on SharePoint 2013 or 2016 you may have tried to use “Export to Excel” on a SharePoint list or library and received the following error message: If you’re using SharePoint online (O365) you won’t run into this issue.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |