There is a “gotcha” when importing lists from Excel to SharePoint. After selecting the file to import, a message may appear that says, “The specified file is not a valid spreadsheet or contains no data to import.”
Before spending hours trying to fix a file that’s not broken, all you have to do is add your SharePoint site to Trusted Sites in the security tab of your browser. While the message doesn’t seem to reveal that this is the problem, it will likely fix it immediately. You won’t even need to restart your browser.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/33965/a-gotcha-when-importing-lists-from-excel-to-sharepoint "