From the course: Sharepoint Online Essential Training: Beyond the Basics

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Create a new list from an Excel table

Create a new list from an Excel table

From the course: Sharepoint Online Essential Training: Beyond the Basics

Start my 1-month free trial Buy for my team

Create a new list from an Excel table

“

So if Microsoft Lists don't include the template you want, one way to create a new list is by using data that already exists. My favorite SharePoint list is actually a list that already exists someplace else. And because the business world is so Excel-centric that somewhere else is often Microsoft Excel in a workbook, we can take a table from Excel and push it into SharePoint as a custom list, or we can pull it from Excel using SharePoint. Let me show you how we're going to do that. So we're going to go to new list. And in this case, at the top, we're going to choose from Excel. Notice we could also do this with the CSV. And I'm going to upload the file and it will be placed in my site assets library, not in my document library. So I could choose an Excel workbook that I'd already put in the document library, and that's not hard to do. It's actually very easy thing to do to upload a file. You know how to do that. But if it isn't already there, it's going to be placed not in documents…

Contents