Copying column from excel into sharepoint list

Question

When I look up how to copy a column from excel into a sharepoint list it says that a simple copy paste should work. When I do this however it ends up copying all of the values into one cell. Does anyone know why this is happening?

Answer 1

Here're some references about how to copy column from excel into SharePoint list for you.

How to Import Excel List Items to an Existing SharePoint List

Here are 3 ways to import Excel data to SharePoint list

Import/Copy/Paste Data from Excel into Existing SharePoint List