While importig exccel sheeet to SharePooint listtt

sns 9,246 Reputation points
2022-11-08T17:40:25.483+00:00

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.

258366-import.png

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments No comments
{count} votes

Accepted answer
  1. Xyza Xue_MSFT 30,176 Reputation points Microsoft External Staff
    2022-11-09T02:26:37.267+00:00

    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.
      258460-image.png

    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.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.