Instead, it just creates a Choice Type Column, but then allows users to add (type in) values manually.
We can either upload one from the computer or select an existing one from the default document library on a site. 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.