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

Import Excel Table or Range to SharePoint List

A SharePoint Online tutorial by Peter Kalmström

SharePoint iconIn the previous demo Peter Kalmström, CEO and Systems Designer of kalmstrom.com Business Solutions, showed how to export an Excel table to a SharePoint list.

You can also do it the other way around and import the Excel table to SharePoint with the Import Spreadsheet app. If you use that method, which is described in the demo below, you can also import a range of cells without formatting them as a table. The data will be imported to a new list with the new experience interface.

NOTE: This method only works in Internet Explorer.

When you have imported the Excel data to SharePoint with the Import Spreadsheet app, 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 import. The range or table will be imported just as it is.

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

Excel iconThese are the steps to import Excel data to a SharePoint
list with the Import Spreadsheet app:
  1. Click on the settings gear and select 'Add an app'.
  2. Search for Excel and select the Import Spreadsheet app.
  3. Give the app a name and browse to the Excel file you want to import.
  4. Enter the URL of the SharePoint site to where you want to import the Excel table.
  5. Click on Import, and you will be asked to log in to SharePoint again.
  6. Select the table or range that you want to import and click on Import.
Now the Excel data you selected will be imported to the SharePoint app.

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.

Learn more


Always the latest news in the kalmstrom.com blog

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

back icon next icon