Once all is set and done, it will create a list for you.Make appropriate selections and click Create at the bottom of the screen. By default, the columns will import as a Single line of text, but depending on your data, you might want to switch to a different type of column (i.e., Date and Time, Currency, Choice (drop-down)). The only other important step – you need to define the type of column you will create. Next, you have to choose the Table (tab) from the Excel you want to import.For this article, I will choose one I already have in the document library. 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.

Import json into excel 2013