Create SharePoint List from Excel Spreadsheet

The advantages of using a SharePoint list instead of just uploading an Excel file to SharePoint is that multiple people can edit the file simultaneously. You avoid version sprawl by only having one centrally located version of the list and you can always download the list as a file if needed.

Here are the steps:

  • Make sure your Excel file is saved in the newest format, it needs to have a .XLSX extension. If it does not, simply save it in this newer format. The old format is .XLS.
  • Browse to your SharePoint site using Internet Explorer. This task requires IE as it is the only browser that works with ActiveX controls.
  • Follow these steps here using Internet Explorer: Create a list based on a spreadsheet.