How to import Excel spreadsheets to SharePoint as lists

Excel and SharePoint lists were always connected and have a lot in common however the available methods to transform a spreadsheet into a list were outdated and not compliant with the latest web standards.

During the last Microsoft Build the world was introduced to the new Microsoft Lists, a new application in the Microsoft 365 ecosystem that will leverage the power of SharePoint list. While we don’t have the chance to play with Microsoft Lists a new feature to import Excel spreadsheets has landed on SharePoint.

The new import feature takes advantage of the modern SharePoint and has support in all major modern browsers.

How to create SharePoint lists from Excel files using modern SharePoint

The process to create SharePoint lists from Excel file is quite simple yet very powerful, to use it you have to do the following:

  1. On your modern SharePoint site go to Site Contents
  2. Click on New
  3. On the Create a list pane click on From Excel
  4. Provide a name for your list
  5. Upload your Excel file
  6. Select one of the available tables in the file
  7. Define a column type for each one of your columns, or remove them from the import
  8. After a few seconds SharePoint will open your new list with the content you had in the Excel spreadsheet

To view the entire process in action check out the video below.

Time vector created by stories – www.freepik.com


4 Responses to “How to import Excel spreadsheets to SharePoint as lists”

  1. Sergio Fernando Fangueiro

    May 31, 2020

    Hi João. Did not know this option. However on design menu of Excel you have an option to upload Excel spread sheet into your site collection.
    Just put site collection url and name, and voila: you will have Excel as a list on your sharepoint site

    Reply
  2. Kevin McKnight

    July 29, 2020

    This is great, thank you! How do you import the Excel table to an existing SharePoint List?
    In my case, its an excel contact list I’d like to import to my newly created SharePoint List.

    Reply
    • João Ferreira

      August 4, 2020

      Hi Kevin,

      With this method you don’t do the import to an existing list, to do something like that I suggest you to the following:

      1 – Export your existing list from SharePoint to Excel, instructions about how to do it are available here.
      2 – Merge the data from both lists
      3 – Use the method described in this article to create a new list in SharePoint

      Might not be an optimal solution if you plan to do this a lot of times but it might work.

      Have a nice day 🙂

      Reply

Leave a Reply


Web developer focused on SharePoint branding, blogger, tech enthusiast. Travelling and sports are my addictions, knowledge and success are my daily motivations.