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

Also refer to the kalmstrom.com Blog post about the Excel-SharePoint tutorials in the series SharePoint Online from Scratch.



Learn more


---------------------------------------------------------------------------------------






Always the latest news in the kalmstrom.com blog



Follow kalmstrom.com on LinkedIn Facebook, Google+  or Twitter!

back icon next icon