How to import a spreadsheet into SharePoint
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”.
I’ll give Here I’ll filter on “List” and then select to “Import Spreadsheet” and click “Create”.
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”.
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.