How to Import Excel Data to SharePoint

If you are running a SharePoint Server and  have an excel spreadsheet of about 5000 rows / 40 columns, which you would like to import to a SharePoint list. Do you have any opinions on how to get these data into a SharePoint list?  Moreover, if these data need to be updated after importing them to a SharePoint list, do you have any opinions on how to update the existing data? In this article, you will find some ways to achieve those goals. With  SharePoint out-of-the-box, there are two methods that you can use to move your data from an Excel spreadsheet to SharePoint. One is to directly import your Excel spreadsheet into SharePoint list. The other is to utilize the cut and paste feature to directly move your Excel spreadsheet information into the datasheet view.   Using the first method - cut and paste into SharePoint datasheet, you have to make sure that the number of columns and rows in your Excel spreadsheet are exactly the same as in the SharePoint datasheet. There is no way of creating new columns and rows on paste.   The second method is to import from Excel spreadsheet into SharePoint list. To do this you have to first make some preparations before you can import into SharePoint such as ensuring that the list is clean with no blank columns or rows; ensure that the list has headers, that is, all columns should have a title; column data has to be consistent; and the first row is a representation of the rest of the data. All these steps can quickly become cumbersome especially if your list contains a lot of data and the time it takes to reorganize the data for importing can quickly make importing a very hard task.   There are some of the other problems you may run into when setting up to import your Excel spreadsheet. The first problem is that SharePoint list does not support importing Excel data into existing SharePoint lists. Another problem is that SharePoint cannot map Excel columns. The third problem is that the spreadsheet program has to be compatible with SharePoint.   If you want to update the Excel data that has already  been imported into SharePoint list, in my opinion, you can only achieve this by buying a third-party product. Excel Import may meet your needs.

Top 10 Benefits of using Microsoft SharePoint Server

What is SharePoint?

​Microsoft SharePoint 2010 makes it easier for people to work together. Using SharePoint 2010, your people can set up Web sites to share information with others, manage documents from start to finish, and publish reports to help everyone make better decisions.

How to Remove Missing WebPart during SharePoint Upgrade

If you are upgrading SharePoint 2007 to SharePoint 2010 and getting "MissingWebPart" error when using the Test-SPContentDatabase cmdlet in PowerShell, this tip will help you diagnose the issue.

Following is the original error:

Category: MissingWebPart

Error: True

UpgradeBlocking : False

Message: WebPart class [8c8bca43-cbc1-da50-d518-54614c79b3f5] is referenced [1] times in the database [WSS_Content], but is not installed on the current farm. Please install any feature/solution which contains this web part.

Remedy: One or more web parts are referenced in the database [WSS_Content], but are not installed on the current farm. Please install any feature or solution which contains these web parts.