While importig exccel sheeet to SharePooint listtt

Question

Customer is using import spread sheet option, those steps include --> site content--> Adding new list --> upload excel file--> Provide the column names and creating the list.

so user is facing below error while doing above steps.
and this is issue happening in the SharePoint online list, before migration it is was in SharePoint 2013 and it was working fine over there.
Please suggest what could be the cause and provide me the solution. Thank you.

Answer 1

Hi @sns ,
Make sure your excel data is correct and in the format that SharePoint expects -

1. Does not contain blank rows.
2. More importantly, the column which you select as Title should not have blank cells/entries.
3. Title is always mandatory, so you cannot have blank values here.
4. Fix all blank entries in excel (for Title column) and re upload.
5. Make sure your Excel list is formatted as a table.
   

---

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.