SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
I know you can import excel sheets into SharePoint, thereby creating a brand new list, but I want to import an excel sheet into an existing list and after the fact the list and excel sheets share separate column names.
For an example, the excel sheet will have something called "Additional Needs", but the list's equivalent of that column is called "Comments". They are both the same thing, just named differently.
Regardless of column names, you can't import an Excel sheet into an existing SharePoint list.
Out of the box, the best option would probably to copy and paste your content from Excel to SharePoint Quick Edit mode. But the copy and paste is far from perfect between Excel and SharePoint (you lose stuff on the way).
Another option is to go through a 3rd party software such as SharePoint List Synchronizer. Disclaimer: this product is edited by SoftFluent, my employer.
