SharePoint Basics - How to import Excel Spreadsheets to a SharePoint list

Importing an Excel Spreadsheet to a SharePoint list used to be a bit of a nightmare. All columns were created as single line of text columns, by default the list was saved in datasheet view and the entire process would often fail if you were importing large data sets.

Recently however, Microsoft has improved this process, making the whole experience smooth, easy, and efficient.

So how do you do it?

First of all, you will need to format your Excel spreadsheet as a table:

Highlight the range in your table that you want to import, then select “Format as a Table”

Excel import 1.png

Here’s how it should look:

Ex cel import 2.png

Next, navigate to the SharePoint site where you want to create the list. Click the gear icon and then Site Contents.

Excel import 3.png

From the “New” drop down, select list:

Excel import 4.png

You will then see 3 options – Select “From Excel”:

Excel import 5.png

Then click “Upload” and select your Excel Spreadsheet.

Excel import 6.png

The next important step is to choose the table (tab) you want to import and then define the type of columns you want to create. By default, the columns will import as a single line of text, but depending on your data you might want to change to a different type of column (e.g. Choice (Drop down), Date and Time).

Excel import 7.png

Then click “Next” to finish creating your list which will look something like this:

Note that once you have finished this process, there is no link between the list and your Excel Spreadsheet – changing one will not change the other. It is also a one-time operation – you cannot import additional rows at a later date.

Previous
Previous

Version History in SharePoint

Next
Next

Getting to know the fastest growing business app in Microsoft History