"Unknown Error" when importing an Excel spreadsheet to SharePoint Online 2016

Published on
3,167 Points
1 Endorsement
Last Modified:
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016.
But that just resulted in getting an error message 'Unknown Error'...

Frustrated by getting a less than helpful "Unknown Error" when I tried to import a Spreadsheet into a Team Site made in SharePoint 2016, I went hunting for a solution.

Trying to Google a solution for hours didn't help, nor did reading several articles on Microsoft's Support website give me any luck.

Until I finally realized that I was logged in with different accounts in Office and SharePoint!

So I finally found the solution to this problem. 

I just logged out from Excel, and then logged back in again using the same admin account that I use in SharePoint, and it worked!

A simple fix, yet effective!

I hope this will also help you if you strike the same issue.

Author:Måns Ekman
1 Comment

Expert Comment

by:Andreas Wennborg
Solved my problem. Thanks!

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Join & Write a Comment

This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month