The Export to SharePoint button in Excel gives a quick an
easy way of transferring data from Excel to SharePoint,
but the method has some issues.
In the demo below Peter Kalmström, CEO and Systems Designer
of kalmstrom.com Business Solutions, explains what you should
be aware of when exporting from Excel to SharePoint using
that Export button. The demo shows the classic list interface,
but by default the exported data opens in the modern interface
- but still in the edit/grid mode.
A new SharePoint list will be created for your data.
Excel does not push data into an existing list
The columns created in the new list are list columns,
not site columns.
Generally you should use site columns as much as possible.
Site columns belong to the entire site, while list columns
only belong to one list.
The
default view mode of the new list is Datasheet/Quick
Edit/Grid, not Standard view. But having the Datasheet
view as default creates problems when you want to show
the list in a web part.