How to Import an Excel Spreadsheet to Sharepoint


Microsoft SharePoint has a variety of features allowing employees, in any business, to collaborate with each other on different projects and data. One of its features is the ability to manage and work on documents from any location. This is possible because the data is held in a cloud platform. But to work with standard Microsoft Excel spreadsheet information in SharePoint, you must first upload the Excel cell information to a SharePoint list.

  • Open Microsoft Sharepoint, and click on "Site Actions" and "View all Site Content."

  • Select the "Create" tab in the new window, and choose the "Import Spreadsheet" link.

  • Type the name you want to give the Excel data in SharePoint, and write a description that will help you remember the type of data it is.

  • Locate the Excel file with the "Browse" button and click "Import" again. Leave the default cell value range, and click "Import" again. Wait for a pop-up window to appear demonstrating your Excel document. Select the rows you want to import by clicking and dragging the cursor over the sections. Remember to highlight the titles, otherwise, you won´t know what the values are for.

  • Click on the small icon in the "Import to Windows SharePoint Services List" box. This is the small icon that looks like a sheet of paper with an incoming arrow on it. It sits next to the input box, with the list of row numbers.

  • Press the "Import" button once more, and wait for the data to be imported into the SharePoint list.


  • Photo Credit Burke/Triolo Productions/Brand X Pictures/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!