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.

GET YOUR FREE COPY OF MY THREE SHAREPOINT TIPS TO SUPERCHARGE YOUR PRODUCTIVITY HERE:

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 YouTube channel:

🚩 Connect with me on social:

This video was created using Camtasia 2020. You can download your free trial at the following links:



The audio in this video was recorded using a Blue Yeti Nano. You can purchase yours at the following links:

Note that I may earn a small commission at no additional cost to you from purchases made using these links

[LuiIacobellis]

GET YOUR FREE COPY OF MY THREE SHAREPOINT TIPS TO SUPERCHARGE YOUR PRODUCTIVITY HERE:

[pravinshingadia]

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

[MrPotatoeHead]

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 ?

[blanklate]

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?

[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.

[rvalentine]

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!!

[terriwalker]

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?

[tokalwarshashikant]

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

[ChrisSmithFW]

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

[Nottttttttttttttttttttt]

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