Home >Tips > SharePoint Online from Scratch > Problems when exporting Excel data to SharePoint kalmstrom.com site map icon Site map  

Export/Import Excel to SharePoint Issues

A SharePoint Online tutorial by Peter Kalmström

SharePoint iconIn 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. 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.
  • Excel iconThe 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.

To get more control and synchronization both ways, use the Access method to import Excel data to SharePoint.






back icon next icon
Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved