Share via

Microsoft Lists does not import columns from excel

Anonymous
2023-07-06T20:51:35+00:00

I am trying to import a table from Excel into Lists, but it does not import the first two columns.

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-07-07T03:34:42+00:00

    Dear Thomas Castillo1

    Based on our investigation, ID and Type are default existing columns in SharePoint list. These 2 columns are auto filled and contents inside is not customizable. Your first 2 columns names are conflict with the existing ones. Please change the column names, for example, IDs, Types, and check if it works.

    If there is any misunderstanding, please feel free to correct me.

    Have a nice day!

    Best regards,

    Sophia

    11 people found this answer helpful.
    0 comments
  2. Anonymous
    2024-01-25T12:35:56+00:00

    Just to make above a little clearer - rename the column header "ID" and "type", once renamed - ie "Identifier" "Close" this will fix it.

    0 comments