Import from Spreadsheet App: An unexpected Error has occurred

Office 365 E3. Excel 2016. New Team Site. Logged in as Site collection owner (global admin).

Attempting to create a new list via the SharePoint app "Import from Spreadsheet"

Steps to reproduce:

1) Create a basic spreadsheet with a single worksheet in Excel 2016 with 4 columns, 3 rows of data. Save and exit Excel.

2) Login to SharePoint online team site as site collection owner.

3) Site Contents-->Add an app-->Import Spreadsheet

4) Enter List name, then click "Browse" button to open .xlsx file location

5) Click "Import"

Result: An unexpected error has occurred.

 

Question Info


Last updated May 15, 2020 Views 18,975 Applies to:

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

hi mts bob,

regarding the situation, please try add your sharepoint site to the trusted sites of internet explorer.
1. click tools > internet options > security > trusted sites > sites.
2. enter your sharepoint site address, then click add.
3. uncheck the require server verification (https:) for all sites in this zone option.
 

if the issue persists, to further look into the situation, we’d like to confirm some information:
1. have you ever used this app successfully?
2. try with another excel file.
3. try to reset your ie settings. click tools > internet options > advanced > reset.
4. the version of your operating system.

meanwhile, you can consider using the workaround to export the spread to a sharepoint list referring to this article: export an excel table to sharepoint

regards,
jiaxing bian

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

1) It's already part of the trusted sites list.

2) I've used this app many times previously but with Excel 2013.

3) I can't get any Excel file to import with this app - have tried several.

4) I did a full advanced IE reset - problem remains

5) I am running Windows 10 Enterprise 10576 and Excel 2016 16.0.6001.1034

8 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

hi mts bob,

given the issue, could you provide us with some additional information in the private message for our further investigation? you can access private messages via https://community.office365.com/user/conversations.

meanwhile, i would suggest you follow the workaround below and check if you can export the worksheet to a sharepoint online list:

1. create a worksheet in excel 2016 and add several rows and columns.
2. select the cells and click the insert tab > table.

3. click ok.
4. in the design tab, click export > export table to sharepoint list….

5. in the address field, enter your site’s url. in the name filed, enter a list name.
6. click finish.

thanks,
lingyu sun

28 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi MTS Bob,

We've escalated the case to the related team for further investigation. They will look into the issue further, and if there's an update, they may contact you directly via the email address web***@the*** you provided. We'll also update here when we get a response. Thanks for your patience and cooperation.

Regards,
Lingyu Sun

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Is there any update to this issue?  I am having the same exact issue and am using Excel 2016.  

I tried the workaround, it worked, but created an access table in SharePoint.  This isn't what I am going for.

Thanks

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Chris,

Because this feature is crossing Excel 2016 and SharePoint Online, it is complex for investigating the root cause. Currently, the engineering team is still actively working on it. 

We will keep query the status of this issue, and will update you once we get any further feedbacks from them.

Given the workaround I provided above, it will create a Datasheet View in your imported list by default. You may follow the steps below to create a new Standard View instead:

1. In the imported list, click the LIST ribbon > Create View.
2. Select Standard View.
3. Give it a name and tick Make this the default view.
4. Click OK.

Thanks,
Lingyu Sun

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Any update on this. I have the exact same issue MST Bob and haven't found any fixes.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi HCLAdmin,

The engineering team still discussing on the fix. Sorry for taking long. Please understand that because this feature is crossing Excel 2016 and SharePoint Online, both the engineers of the two product teams are involved. 

We will keep our eyes on this issue, and will keep you update once there's a response from them.
 
Thanks for your patience.

Lingyu Sun

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi All,

The issue is now fixed by the product team and will be published in the February PU. So you can get the fix at the beginning of March if you are using the CB upgrade mode, but you need to wait for June if you are using the CBB upgrade mode. 

For the upgrade mode concept, please check https://blogs.office.com/2015/09/10/admins-get-ready-for-office-2016-rollout-begins-september-22/.

Thanks for all your understanding and patience.

Best regards,
Lingyu Sun



Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I had to install Office 2010 alongside Office 2016/2013 to get the Import Spreadsheet app to work on SP 2013. This has worked on several user's machines.

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.