Clicky


Importing Excel Spreadsheet into a SharePoint site

How to import an Excel Spreadsheet into a SharePoint site

1. Login into your SharePoint Site and click on Site Actions.
2. Select Create.
3. Click on Import Spreadsheet from the Customs List.
4. Enter the Name and Description.
5. In the Import from Spreadsheet section, click in the File location box. Click Browse to find the spreadsheet file that contains the list that you want to import, and then click Open.
6. Click Import.

In the Import to Windows SharePoint Services list dialog box, enter the range of cells that you want to use for your list.

7. In the Import to Windows SharePoint Services list dialog box, click Import.

NOTE: Typically, the columns are set up on the SharePoint site based on the type of data that they contain. After you import a list, however, you should inspect the columns and data to make sure that everything was imported as you expected. For example, you may want to specify that a column contains currency rather than just a number. To view or change the list settings, open the list, and then click List Settings on the Settings menu.

With the best SharePoint hosting price plans in the industry, Apps4Rent provides any sized business the power to integrate the virtual collaboration technology into their business model and streamline communications at a minimal SharePoint hosting price rate of $8.95 per month.

Related Links:

Best SharePoint Hosting

Apps4Rent’s SharePoint 3.0 Hosting Services

Free Microsoft SharePoint Hosting Templates

Pointing your SharePoint site after signup

Adding a new SharePoint site with new domain

How many SharePoint sites can I add?

Adding/Modifying themes in SharePoint

Backup and restoring SharePoint sites using SharePoint Designer

Leave a Reply

Submit Your Requirement