Forum Discussion
SharePoint List from Excel File
I have several SharePoint lists.
Several of the names of the lists need to be changed.
Several of the columns in the lists need to be changed.
As a test, I've used Power Query to change the names of the columns
and saved the file.
When I try to create a SharePoint list out of the Power Query edited Excel
file the columns are now 'field_1', 'field_2', etc.
Is there anyway to use the SharePoint 'Create a list - from Excel' and retain
the column names rather than the transition forcing 'field' on all column
names?
1 Reply
You can use the import spreadsheet function or just copy and paste.
