Can’t Import SpreadSheet to SharePoint List: The specified file is not a valid spreadsheet or contains no data to import

In this blog, I will show How to solve the below import Excel sheet issue in SharePoint

The specified file is not a valid spreadsheet or contains no data to import


Scenario

I have an Excel file as shown below,

The specified file is not a valid spreadsheet or contains no data to import

I have tried to import this Excel file to SharePoint using Import spreadsheet feature

The specified file is not a valid spreadsheet or contains no data to import

But unfortunately, I got this error

The specified file is not a valid spreadsheet or contains no data to import

The specified file is not a valid spreadsheet or contains no data to import


Cause

Continue reading “Can’t Import SpreadSheet to SharePoint List: The specified file is not a valid spreadsheet or contains no data to import”

Advertisements

Export Data View To Excel In SharePoint 2016 / 2013

In this article, I will show How to

Export Data View Web Part To Excel In SharePoint 2013 / 2016

Scenario

In SharePoint 2013, I created a Data View Web Part with an external database connection as a data source via SharePoint designer.

Export Data View to Excel In SharePoint Continue reading “Export Data View To Excel In SharePoint 2016 / 2013”