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.

  • 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


Excel icon 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




Follow kalmstrom.com on LinkedInFacebook or Twitter!

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

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved