SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I get the following error when trying to import an excel spreadsheet into a SharePoint list.

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

I have added this site to “Trusted Sites” list in the IE 8 but this does nothing.

Setup: I am using Excel 2010, Windows 7, IE 8, SharePoint Server 2010 which are all loaded on a Windows 7 laptop.

I followed these directions for importing a spreadsheet as a list:

share|improve this question
Is the problem just on your computer and whether did you tried it in any other browser and if it works then ? – Muhammad Raja Mar 6 '13 at 23:36
I installed SharePoint Server 2010 on my Windows 7 laptop and everything is being run locally browser IE 8 accessing sharepoint site all on my laptop. – Remy Mar 7 '13 at 3:17
Does this happen with all spreadsheets or just this one? – John Chapman Mar 7 '13 at 3:58
It is happening with all spreadsheets. I followed these directions:… – Remy Mar 7 '13 at 11:08
up vote 2 down vote accepted

Well, I searched some more and found the solution (thanks to SunnyLowe)

The real problem here is Internet Explorer (IE).

  1. In IE, from the File menu or Tools Icon, select Internet Options|Security Tab

  2. In the "Select a zone to view... ", click Trusted Sites so it is highlighted. Then click Sites to add the site to your trusted sites list. Tab. (This was already automatically done for me).

  3. Set the Security level for this zone of the Trusted sites to Low.
  4. Then reload the webpage, and it should load fine.

I had only checked # 2 and didn't see mention of# 3 of above until I found SunnyLowe's post here:

share|improve this answer

I had the same error when required field "Title" was hidden in the list and I did not insert data from EXCEL to that column.

Try to check out if there are columns in the list which are not in the excel. Try to copy column one by one...

Should be one or more column missing.

Hope it helps,


share|improve this answer

This is a simple issue of your site not added to trusted site in internet options of Internet explorer. Add it to trusted sites then try.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.