Unlink Excel Table From Sharepoint List. Give the app a name and browse to the Excel file you want to import. Export the Excel Table to a SharePoint List Select the table and go to the Table Tools Design tab and select the Export command then choose Export Table to SharePoint List.
You can change the field type of the column if needed and all your table data will be copied to the new list. Navigate to the SharePoint site that contains the list you want to synchronize with Excel. If you want to retain the list as a table you would have to import the data into the database first and then delete the linked table.
Let us see how to display an excel document using the SharePoint excel web access web part in SharePoint Online classic sites.
While still selecting the data table choose Export option from the ribbon and select Export table to SharePoint List option. This refresh functionality is really cool if you lets say build some sort of pivot tablescharts based off SharePoint data and want to update your chart based on changes in SharePoint. Click the name of the SharePoint list on the Quick Launch or click Settings click Site Content and then locate the list. After adding a List Item go the excel worksheet- right click on the Table data- Table Click on Synchronize with SharePoint.