How to import a spreadsheet into SharePoint

Posted on

Please note that this is a shortened, fast-speed video with the objective to give you a glimpse of ways in which you can improve your business productivity. The full video: “Increase visibility by sharing your data” shows you how to perform the steps in a slower, more user-friendly fashion.

Learn how to import a spreadsheet into SharePoint in Microsoft Office 365

Here I have a spreadsheet that I want to import into our SharePoint team site. I’ll close it down and then I’ll open up SharePoint. I’ll click ”Site Actions” and then ”More Options”.

How to import a spreadsheet into SharePoint

I’ll give Here I’ll filter on “List” and then select to “Import Spreadsheet” and click “Create”.

How to import a spreadsheet into SharePoint

I’ll give the list a name and a short description, and then I’ll click “Browse” to open up my Excel file. Excel opens up and I get to define which data I want to import. I’ll select “Table Range” and then I’ll select “Table number 1” and then I’ll click “Import”.

How to import a spreadsheet into SharePoint

The data is uploaded into SharePoint and here the entire team can read and update the list.

Sign up today to see more

Sign up for a membership today to get access to our full video library.