Unable to export data from Excel to SharePoint list

Question

Hello all,

I created a SharePoint list to manage assets, and I am trying to export the data i have from excel to SharePoint list, and it displays this error message, what steps have to been taken to accomplish this task.

Answer 1

I'm glad to hear you found a workaround for the issue, if you have any other issue about SharePoint, you are welcome to raise a ticket in this forum.

By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.". So, I would make a brief summary of this thread:

You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community members to see the useful information when reading this thread. Thanks for your understanding!

[Unable to export data from Excel to SharePoint list]

Issue Symptom:

OP created a SharePoint list to manage assets and try to import the data from excel to SharePoint list. It displays this error message.

Current status:

OP found a workaround.

OP created the list in SharePoint site and by feeding the excel, then edited the rest.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

What types of columns are created in the SharePoint list?

Whether this issue occurs in all lists or only one list? All users or one user?

1.Make sure that you are using a supported browser for exporting SharePoint lists to Excel. I recommend you use Microsoft Edge.

2.SharePoint has limitations on the size of files that can be exported to Excel. The maximum number of rows you can export to an Excel file is 30,000.

3.Check whether you have enough permission to export the SharePoint list to Excel. Make sure that the permission level been granted includes Use Client Integration Features.

4.In the Excel client application, log in the account you used to export SharePoint lists to Excel.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.