Import Data from Spreadsheet to SP List V1.1

Rating:        Based on 1 rating
Reviewed:  1 review
Downloads: 776
Released: Jul 15, 2009
Updated: Jul 15, 2009 by ramp
Dev status: Stable Help Icon

Recommended Download

Application Import Spreadsheet To SharePoint List Version 1.1
application, 554K, uploaded Jul 15, 2009 - 776 downloads

Release Notes

Import from Spreadsheet to a SharePoint List is the missing facet to the WSS 3.0 / MOSS 2007 List
features. SharePoint lets a user create a custom list from a spreadsheet, export data from a SharePoint List
to a spreadsheet, but lacks the ability to import new data to an existing SharePoint list.

This SharePoint feature developed in C# .Net is an easy to install and intuitive to use feature that will allow
a user to select an Excel spreadsheet, map the SharePoint list columns to the spreadsheet columns (top
row in the sheet) and import data.

This feature works in WSS 3.0 and MOSS 2007 environments. (x86 systems or 32-bit servers only).
Note: A version of this feature compatible with the 64-bit servers will be made available shortly.

Version 1.1
Addressed Issues:
1) Proper exception handling if tried to install on for 64-bit servers. (This version is 32-bit compatible only).
2) Type mismatch for date fields exception thrown if the date field was empty.
3) Skip blank/empty rows in the excel spreadsheet from getting imported. Any invalid entried for date fields (or any fields) will be treated as null values and ignored from being imported.

Installation Procedure:
1) Run the given ImportSpreadsheetToSPList.exe file.
2) Select the Sites where you wish to install this feature in the installation wizard.
3) After successful installation, activate the feature in the SharePoint Site collection features for all the sites.
4) Once activated, Import from Spreadsheet feature will be available of the Actions menu of all the SharePoint lists.

A detailed installation guide is available in the readme file provided in the feature download.

Reviews for this release

Install went well; however, there isn't much explanation on how to do the import. I noticed the spreadsheet must have EXACT column names as you would see in Settings > List Settings in order for it to load correctly. Once you can see the columns and make your selections, you can click 'import', but you are given a 'page not found' error. Although this error occurs, it will still import the data.
by jpagtalunan on Jul 30, 2009 at 6:51 PM