|
|
|
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 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.
Example:
You have an excel file that contains customer information and you are managing the following information on your local machine. Let’s assume the file looks like the below:
If you want to manage the same information from SharePoint, you have to import the excel file into SharePoint as list.
Here are the steps to convert an Excel spreadsheet into a SharePoint list:
The above step creates the SharePoint list with name “Customer Data”
Tips: You have to specify the Range of your excel data. (Click on "Sheet1! " text on dropdown to activate the excel sheet; Select the required data range by choosing the required contect on excel file.)
If You receive "Object doesn't support property or method" error message when you are trying to import a spreadsheet, click here to read the steps to troubleshoot the issue.
| |
|
