While importig exccel sheeet to SharePooint listtt

sns 8,656 Reputation points

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.


A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
7,093 questions
0 comments No comments
{count} votes

Accepted answer
  1. Haoyan Xue_MSFT 11,246 Reputation points Microsoft Vendor

    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.

0 additional answers

Sort by: Most helpful