Export/Import Excel to SharePoint Issues
A SharePoint Online tutorial by Peter Kalmström
earlier articles we have described how to
export an Excel table to a SharePoint list using the Export to SharePoint
button in Excel and how to
import an Excel table to a SharePoint list using the Import Spreadsheet app.
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.
- 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 of the new list is Datasheet/Quick Edit, not Standard
view. But having the Datasheet view as default creates problems when you
want to show the list in a web part.
- The SharePoint list that Excel creates will not have the new experience.
To get the new experience, more control and synchronization
both ways, use
the Access method to import Excel data to SharePoint.
More demos about moving Excel data to a SharePoint list
Data sharing: Excel versus SharePoint
Export an Excel table to a SharePoint list using the Excel Export button
Import an Excel table to a SharePoint list using the Import Spreadsheet app
Enhance SharePoint list created from Excel export/import
The Access method to import Excel data to SharePoint
Also refer to the
kalmstrom.com Blog post about the Excel-SharePoint tutorials in the series
SharePoint Online from Scratch.