How to create a SharePoint list based on a spreadsheet?

You can save time when you create a list by importing a spreadsheet file, if your data is already in a spreadsheet format. When you create a list from a spreadsheet, its headings become columns in the list, and the rest of the data is imported as list items.

After you import data into a SharePoint list, you can customize its settings and continue to add data to it, as you would any list on a Microsoft Windows SharePoint Services site.

To create a list based on a spreadsheet, you must be using a spreadsheet program that is compatible with Microsoft Windows SharePoint Services, Microsoft Internet Explorer, and Microsoft Windows. For example, you can import a list from Microsoft Office Excel 2007 that you created to store and manage contracts with vendors.

1. Click View All Site Content, and then click Create on the All Site Content page.
2. Under Custom Lists, click Import Spreadsheet.
3. In the Name box, type a name for the list. The list name is required.

The name appears at the top of the list page, becomes part of the Web address for the list page, and appears in navigational elements that help users to find and open the list.

4. In the Description box, type a description of the purpose of the list. The description is optional.
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.
7. In the Import to Windows SharePoint Services list dialog box, enter the range of cells that you want to use for your list. Depending on your spreadsheet program, you may be able to select the range of cells that you want directly in the spreadsheet.
8. In the Import to Windows SharePoint Services list dialog box, click Import.

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 SharePoint 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 Site Hosting Plans

Free 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