Home >Tips > SharePoint Online from Scratch > Export Excel to SharePoint kalmstrom.com site map icon Site map  

Export Excel Table to SharePoint List

A SharePoint Online tutorial by Peter Kalmström

SharePoint iconExcel tables can be exported to SharePoint, and in the demo below Peter Kalmström, CEO and Systems Designer of kalmstrom.com Business Solutions, shows how to do it.

The major benefit of this method is that it is simple and quick. However, when Excel creates the list in SharePoint it makes a number of "mistakes". In the article "Enhance SharePoint list created from Excel export" we describe how to fix most of those problems, but one mistake that cannot be easily fixed: the SharePoint list that Excel creates will not have the new experience.

When you have exported the Excel data to SharePoint it can only be updated in SharePoint. Changes in SharePoint can be pulled down to Excel by using the Excel Refresh button, but not vice versa. You should also be aware that you cannot change the order of columns or exclude columns from the export. The table will be exported just as it is.

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

Excel iconThese are the steps to export Excel data to a SharePoint
list via the export to SharePoint command in Excel:
  1. Format the data as a table. Note that this is only possible if there are no blank rows or columns among the data.

  2. Click on the Export button under the TABLE TOOLS tab and select 'Export Table to SharePoint List'.
     
    Excel Export button

  3. Enter the URL to the SharePoint site where you want to import the Excel table.

  4. Check the box for read-only connection.

  5. Enter a name for the new SharePoint list.

  6. Click Next and then Finish.
Now a new SharePoint list will be created on the site you gave the URL to, and the data from the Excel table will be distributed into it.

When the process is finished you will get a link to the new list. You can also open the list by clicking on the Open in Browser button in Excel.





More demos about moving Excel data to a SharePoint list


The Data sharing: Excel versus SharePoint

Enhance SharePoint list created from Excel export

Problems when exporting Excel data directly from Excel to SharePoint

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.







Always the latest news in the kalmstrom.com blog



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

back icon next icon