Next, we have to choose an Excel file.You are going to see three options on how you can create a custom list.On a SharePoint site where you want to create a list, click Gear Icon > Site Contents.Step 2: Import an Excel spreadsheet to a SharePoint custom list To do so, in Excel, highlight the range first, Format as Table, click OK. What you need to do is define the list above as a Table.Below is an example of a Project List I maintain in Excel.You can’t just take any Excel list and import – it has to be formatted as a Table. This is super important for this process to work. Step 1: Make sure your Excel list is formatted as a table Let me walk you through the process on how to import an Excel spreadsheet to a SharePoint custom list. Recently, Microsoft has added a new capability to SharePoint Lists, where users can import Excel spreadsheets to a SharePoint Custom list, and the whole experience is smooth and extremely pleasing. We had a few options available, but each one came with a long list of quirks that made the whole process and result less than desirable. Importing Excel to SharePoint has always been somewhat of a matzo ball.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |