How to export a table from Excel to SharePoint list

A couple of days ago someone asked about how they can create a SharePoint list from an Excel file. There are a couple of methods available to perform this task but on this blog post, I will do the easiest way on my opinion to make this to happen.

The required action to be able to export the Excel file to a SharePoint list is to create a table from your Excel file. After that, you will unlock this. With this action, for example, it will allow you to use the column formatting to show the data in a better experience and more. For regular use, there are limitations using this method.

In the case that you intend to use the Metadata on your list or Choice, that is not possible with this method. This option to export to a SharePoint list is only available on the Excel Desktop version.

  1. Open the Excel file
  2. Select the data that you want to tranform as a table
  3. Create a Table
  4. Go to the Design Option on the top bar
  5. Click on the option Export and then Export Table to SharePoint list
  6. Paste the URL of the site where you want this list on Address
  7. Give a Name to the list that will be created
  8. Description is optional
  9. If you want this Excel to be updated once the SharePoint list is updated, select the checkbox Create a read-only connection to the new SharePoint list
  10. Click Next if all the fields are with the correct format click to Finish

Conclusion

Depending on the size of the Excel file this can take a while or be almost instantaneously. Now you can start to explore the SharePoint list features.

3 Comments

  1. Kevin McKnight said:

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

    July 29, 2020
    Reply
    • David Ramalho said:

      Hi Kevin,

      You will need to code PowerShell script or similar to import the data to your SharePoint list.
      You can save your file as CSV and then use the PowerShell command to use CSV.

      My best,
      David Ramalho

      August 3, 2020
      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *