Excel: export data from Sharepoint list to Excel

Asked By 0 points N/A Posted on -
qa-featured

Hi!!!!

Are you there and can you suggest a solution? I can't export data from a SharePoint list to a Microsoft Excel 2007 Spreadsheet. During the manipulation, I received this message

 Error:

Cannot get the list schema column property from the SharePoint list.

What can I do immediately to resolve the issue?

Thanks for your time.

SHARE
Answered By 0 points N/A #121210

Excel: export data from Sharepoint list to Excel

qa-featured

Hey Josh,

Data can be easily exported from SharePoint to Excel as both are proprietary of Microsoft and strongly support each other. From the link bar you should select “Documents and Lists” and then select the option “export to excel”.

The Error you have posted is specific when you are trying to export data from SharePoint 3 to Excel 2003 and have some field/column which consists data containing date or time. First try to change its data type to simple text or if you have some lookup field to some formula field. After that, try to export data to Excel.

Hope it will help solve your problem.

Login/Register to Answer

Related Questions