How To Create a SharePoint Online List From an Excel Spreadsheet

This tutorial will show you how to create a list from an Excel spreadsheet in SharePoint Online. Specifically, this tutorial will show you how to create a SharePoint Online list by importing data stored in a Microsoft Excel spreadsheet. Create SharePoint lists from excel spreadsheets is incredibly easy and provides you with the ability to preview your data and change your column data types as required.
🔔MASSIVE SHAREPOINT LIST NEWS - CLICK TO LEARN MORE🔔: bit.ly/3yIiE9D
GET YOUR FREE COPY OF MY THREE SHAREPOINT TIPS TO SUPERCHARGE YOUR PRODUCTIVITY HERE:
bit.ly/3Q921sH
Timeline
0:00 - Start
0:45 - How to create a list in SharePoint Online
1:10 - How to create a list in SharePoint Online from a template
1:35 - How to create a list in SharePoint Online from a spreadsheet
2:20 - How to format as a table in Microsoft Excel
4:10 - How to change the data type of a list column in SharePoint online
6:15 - How to display a SharePoint list on the site navigation menu
🔔 Subscribe to my KZbin channel:
/ @luiiacobellis
🚩 Connect with me on social:
Twitter: / luigiiacobellis
Instagram: / luigiiacobellis
LinkedIn: / liacobe
For Business Inquiries, Contact me at [e-mail]
This video was created using Camtasia 2020. You can download your free trial at the following links:
Camtasia US: bit.ly/3eRT9a7
Camtasia Germany: bit.ly/3eTZVw2
Camtasia France: bit.ly/3tsIsP2
Camtasia Spain: bit.ly/3rYWCHn
Screenshots included in this video were created using Snagit 2020. You can download your free trial at the following link: bit.ly/30RJ3h6
The audio in this video was recorded using a Blue Yeti Nano. You can purchase yours at the following links:
Amazon US: amzn.to/30UENgN
Amazon Canada: amzn.to/3sxq7Ar
Amazon United Kingdom: amzn.to/2NyrY90
Amazon Germany: amzn.to/3tRHDQe
Get a Subscription to Microsoft 365 & Get Access to Microsoft Teams for Your Friends & Family: bit.ly/3t86RdH​
Note that I may earn a small commission at no additional cost to you from purchases made using these links

[@LuiIacobellis]

🔔HUGE SHAREPOINT NEWS! CLICK TO LEARN MORE🔔: bit.ly/3yIiE9D GET YOUR FREE COPY OF MY THREE SHAREPOINT TIPS TO SUPERCHARGE YOUR PRODUCTIVITY HERE: bit.ly/3Q921sH

[@pravinshingadia7337]

Love your video. No messing around and straight to the point

[@LuiIacobellis]

Glad you found it helpful! I try to get right to the point!

[@spitsparrow]

Does the sharpeoint list stay synced to the spreadsheet? So if people are updating the spreadsheet it always update the list?

[@MrPotatoeHead002]

Thanks for the video. Question for you if I may. If you exported a list into Excel and some of the entries from that list had comments attached to them how can those comments be added to the Excel file so that when the Excel file is then used to create a new list the comments are also included in the new list entries ?

[@hakhandan]

Thanks for the video. Can I assume that if the Excel file being read from Library, any changes made in the file would be automatically reflected in the list? Or do we need Power Automate to set it up somehow to get updated in desired intervals? By changes I mean adding new rows mostly with no change in columns. Thanks.

[@LuiIacobellis]

Hi, no changes made to the source file would not update the List. If using a list stored in a library, SP would reference that file once during creation and that is it. You would need to setup a Power Automate flow to try & update the list after the fact. Hope this helps!

[@rvalentine1000]

GM, nice video, Once the list is created will this be a editable input from within SharePoint? I have a user who wants data pulled from SharePoint to look like the Excel SS that they created. Your video helps me understand but just want to make sure or would we need to create a new view in SharePoint to display what they are asking for? Appreciation in advance!!

[@LuiIacobellis]

Hi there, yes would the list is created you will be able to edit the data within the list. You can edit items individually using the form view. Alternatively, you can use the quick edit function to allow for editing the data in a tabular view (similar to editing data in Excel). I've just posted this new video showing how to copy and paste data from an Excel spreadsheet to a SharePoint list which shows how to edit the data in a tabular format. kzbin.info/www/bejne/rIfEgGmud81mbNU Hope this helps!

[@blanklate073]

Hello, what if i already have a Sharepoint List made from excel file and then i add a new column does that reflect to the existing list? If not is there a way?

[@terriwalker6705]

If you want to import an Excel spreadsheet, but don't want all of the columns, should the spreadsheet be adjusted in Excel prior to import or is there a way to select the specific columns that you want prior to executing the import?

[@LuiIacobellis]

Hi there, if you skip to 5:02 of the tutorial, you'll notice that when I click on the data type drop down, the last option is "Do Not Import". Selecting that value will skip that specific column on the import process. Hope this helps! Thanks for watching.

[@tokalwarshashikant1006]

Thanks for video, Once the Computer list is imported on SP, can I import the excel file again with same name to SP whenever there is change in excel file through VBA. (In short can I import the excel file to replace the existing list with same name or update it from document library using VBA) I appreciate your help in advance thanks

[@LuiIacobellis]

Hi there, unfortunately you cannot update a Sharepoint List through importing an Excel Spreadsheet. To do this, you would need to build a workflow using Microsoft Power Automate. I am going to be posting a tutorial in the next few weeks outlining how to do this. What you can do is copy and paste the days from your spreadsheet to the Sharepoint list. Hope this helps! Thanks for watching

[@kristiandemian3955]

@@LuiIacobellis waiting for the Power Automate video!! :)

[@LuiIacobellis]

@@kristiandemian3955 Its next up on my list! I'm hoping it will be live in a week or so! Thanks for the comment and for watching!

[@ChrisSmithFW]

Thank you but how to update an existing list from Excel is missing. Good tutorial though.

[@LuiIacobellis]

Hi Chris, my apologies for the delay. Unfortunately there is no way to update a list using out of the box functionality in SharePoint. There are some solutions posted on the Microsoft Tech Community that detail workflows you can build in Power Automate to do this and there are a few third party tools that can also do it. Although these are rather costly. I do have in my backlog to post a tutorial outlining how to create a workflow to do this in the future. Hope this helps and thanks for watching

[@Nottttttttttttttttttttt]

How can I delete this list, this is not what I wanted

[@LuiIacobellis]

support.microsoft.com/en-us/office/delete-a-list-2a7bca5b-b8fd-4e5b-8f4b-2ac034f3070d