Skip to content
Kunal Kankariya
  • Home
  • About
Search

Home » Create SharePoint List From Excel

Create SharePoint List From Excel

3 Comments / SharePoint / May 31, 2020 July 16, 2020

No, I am not talking about the “Import Spreadsheet” App that’s already present. This is a new “Create SharePoint list from excel” feature in SharePoint online.

Microsoft has now made it easier to create a SharePoint list from an excel file by allowing users to upload the file. This has been rolled out worldwide now in SharePoint Online on modern sites.

Create SharePoint List from Excel

So, how does this work?

Browse to “Site contents” and hit the “New button”. Click on List. Select “From Excel” on the left and you are all set to create a list from an excel file.
The excel file needs to be selected either from the default “Documents” library on the site or uploaded from the local drive. This file first gets uploaded to the “Site Assets” library and then it is read by SharePoint for import.

Here’s some of my observations after I got hands-on with this feature –

  • Unlike the “Import Spreadsheet” app, this doesn’t require ‘ActiveX’ and hence there is no dependency on IE. This will run on all major browsers
  • The datatype of the column is pre-selected based on the data in the column. The wizard also provides the option of modifying the datatype of columns before the list is created
  • The ‘Title’ column can be chosen as well ( Any one column can be set as ‘Title’)
  • Columns can be excluded from import if required
  • Currently supports upto 20k records
  • You need to have at least one formatted table in your excel

Some more : 

  • It wasn’t able to detect a “User” field from the data. I tried adding columns as “Display Names”, “Email”, “User ID” etc., – So no support for peoplepicker field ?
  • CSV files aren’t supported
  • It relies on the “Site Assets” library, if you don’t have one in your site then this won’t work (Upload button will be disabled). Similarly, you also need at least “Contribute” access to the “Site Assets” library
  • You are allowed to choose files that aren’t excel. In this case, the file just gets uploaded to the “Site Assets” library and you can’t proceed further
  • If you upload the same file multiple times, it creates a copy and doesn’t replace the existing file. It doesn’t honour versioning settings of the “Site Assets” library as well. So, if you have a file (excel or not) that you want to upload as copy to “Site Assets” without changing the name of the file yourself, you can use this feature (side-effect :D)

Have you observed anything different with this feature? Do let me know in the comments sections.

close

Oh hi there! 👋
It’s nice to meet you.

Subscribe to receive awesome content in your inbox, every week.

I don’t spam! Read my privacy policy for more info.

Thank you! Check your inbox or spam folder to confirm your subscription.

Spread the love

Related Posts:

  • Configure a Teams App with Power Apps and SharePoint as two separate tabs
    Configure a Teams App with Power Apps and SharePoint as two…

Post navigation

← Previous Post
Next Post →

3 thoughts on “Create SharePoint List From Excel”

  1. Sushmita
    June 3, 2020 at 4:07 pm

    Nice and well explained

    Reply
    1. KK
      June 4, 2020 at 10:36 am

      I am glad that you enjoyed reading the content Sushmita. Thanks.

      Reply
  2. Tarun
    October 1, 2021 at 4:48 pm

    Hi KK,

    Nice work!

    Can you please create an article on searching and showing data from the SharePoint list from user input inside the PVA bot for Teams?

    Thanks!

    Reply

Leave a Comment Cancel Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Connect

Categories

  • .Net (2)
  • Authentication (2)
  • Azure Logic Apps (1)
  • Information Governance (1)
  • Information Protection (3)
  • Microsoft Teams (1)
  • msal (2)
  • Power Apps (6)
  • Power Automate (1)
  • Power Virtual Agent (3)
  • SharePoint (5)

Tag Cloud

AAD ALM Azure Azure App Azure DevOps Azure Logic Apps Bot browserautherror Build Tools canvas app CDS Computer Vision container controls Custom Connector Excel group Information governance Information protection Lists m365 microsoft 365 Microsoft Information Protection MIP msal msal-broswer MS Teams oAuth Office 365 Plans Power Apps PowerApps Power Automate Power Platform Power Virtual Agent Pricing PVA Secure security & compliance Sensitivity Labels SharePoint Spfx Web API webinar webparts
Copyright © 2023 Kunal Kankariya
  • Privacy Policy
  • Home
  • About