.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

List Import Tool

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :SharePoint

Hi All,

Is there a free tool or component in SharePoint that allows column mapping and importing into an existing list?

I have an CSV (Excel) file with 5000+ rows that I need to import into an existing list.

I do not want to write a program so I hope an existing one exists.

SharePoint 2007.


View Complete Post

More Related Resource Links

Import Excel spreadsheet To Sharepoint List

Hi, I am having sharepoint 2010 RTM trial on Windows Server 2008 SP2. I want to populate csv filke data to new sharepoint list. I am using custom List Wizard to achieve this... When I Import csv on server then everything is fine but when i inport csv from client, i get the following error "The Specified is not valid Spreadsheet or contains no data to import" I have also checked to import excel workbook but it gives the same error on client and do great on server..... can anybody have any idea what is wrong ?? thanks

Is there any tool like SharePoint list schema generator for SharePoint 2010.?

Is there any tool like SharePoint list schema generator for SharePoint 2010.?

How to import two excel files into one list?

I know that I can export Excel data into new list in MOSS 2010 via Excel 2010. But when I was trying to add data into existing list, it was impossible. I know one way - copy data in Excel and paste it into the list in DataSheet View. Is there another way?

import data from infopath xml forms to SharePoint list

Hi. I have this issue, a customer has an old application that consists of a SharePoint 2003 site and a 'forms library' with forms listing information about physical servers. The infopath (2003) form is pretty straight forward and has a few dropdowns from lists and so on. Now, we need to move this to 2010 and preferably to a list only using oob functionality. I would like to know if anyone has a clue as to how I can get the data from the hundreds of xml files into a list, could be to excel and then to SharePoint, or any means Necessary. I would prefer it if it can be scripted or done using standard tools from Microsoft, no 3rd party custom xml importer...(if it's not really good and free :-) ) ThanksThomas BalkestÃ¥hl - Technical Specialist - SharePoint

How to provision custom list and import custom aspx pages automatically in sharepoint?

What is best way to create custom list (Document library) and import custom .Net pages automatically. The goal is to avoid create the list and upload those .net page to the list manually. Any code snippet that would be great help. thanks

Can I import a databse from MS Access into a SharePoint list if it contains attachments?


I have 2 issues I am trying to accomplish:

Background:  I have a SharePoint list of over 8000 entries.  This list contains Text (entries) and document attachments.  The list is approximately 400MB.  I have exported the entire SharePoint list into an Access database.  I now want to import parts of the database back into seperate SharePoint lists.

Endstate:  Break the list into seperate lists.  The seperate lists will be broken down by month.  The lists need to include all content from the original list (attachements included)

Issue 1:  Can I import only selected filtered fields into SharePoint from the Access database?

Issue 2:  Can I import the selected filtered fields to include the attachements?


Not able to Import Spreadsheet into SharePoint list.


Hello All,

I am working on WSS 3.0  and with MS Office 2007. I want to import an excel spreadsheet into SharePoint list using the feature provided under "Custom List -> Import Spreadsheet". Whenever I try to Import SpreadSheet i got following error;

Cannot connect to server at this time. Your table cannot be published.

Simultaneously, I am not able to utilize Export to Spreadsheet functionality present under " Actions => Export to Spreadsheet". Whe i tried to export the list it gives "Cannot connect to sharepoint list" error.

Can anyone help me to fix this issues?
Thanks in advance. Waiting for your valuable response.



Import and Export List data in excel sheet


Hi ,

I need to import based selective data from excel sheet and export data from sharepoint list, I'm new in Sharepoint.

can anybody guide me? What all possible ways are there and which would be the best.



Sharepoint Export Import List Items



My requirement is to export the list items in Pages library with its meta data i.e. Created Time and Modified Time.

I am trying Export Import code, but it does not import time. It imports the CreatedBy and ModifiedBY acuurately but createdTIme and Modified Time comes as current time, the time i run the import.

Pls help


private static void ExportItems()
      string exportFolder = @"C:\exports\";
      string exportFileName = "Export_File.cmp";

      using (SPSite site = new SPSite(sourceSiteUrl))
        using (SPWeb oWeb = site.OpenWeb())
          SPList oList = oWeb.Lists["Pages"];
          SPListItem oItemA = oList.GetItemById(2480);

          SPExportObject exportObject = new SPExportObject();
          exportObject.Id = oItemA.UniqueId;
          exportObject.Type = SPDeploymentObjectType.ListItem;

          SPExportSettings exportSettings = new SPExportSettings();
          exportSettings.LogExportObjectsTable = true;
          exportSettings.LogFilePath = exportFolder + "Exportlog.log";
          exportSettings.SiteUrl = sourceSiteUrl;

Import list from excel file



I try import a table from excel file to become a SharePoint list.

I want the first column in the excel to become the title column (linked to item).

I did some tests and in each tests it tooks a different column of the excel to be the sharepoint column which is "linked to item with edit menu".

What is the logic and how may i control which excel column will be that sharepoint column?


Customizing List tool bar in Sharepoint



I used following Script, to disable "Upload Document" and "Upload Multiple Documents". However, the menu that holds these two menu items i.e "Upload" menu should be disabled as well. How can I achieve this? Any help?








<script type=&quo

Import List of Worksheet Names from Multiple Sheets Excel File

I am only interested in OPENROWSET/OPENQUERY or xp_cmdshell solutions. Thanks.
Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Import-SPWeb, List does not exist error

I have a strange problem with custom lists in an imported site.
After exporting the site in Central Admin by clicking "Export a site or list" and importing it with "Import-SPWeb" (on a different farm), I cannot read or create new items in custom lists in the imported site. However, by code, i.e. using PowerShell or custom Web Parts, I can read items in the list without any problems.

If I click on any item in a list however, I get an error saying "List does not exist. The page you selected contains a list that does not exist.  It may have been deleted by another user."

I guess it has something to do with permissions, since I get an "Access denied" error when trying to create new items through the browser. The permissions settings seem fine in the browser though...

EDIT: This seems to occur only on lists where I have created custom list forms, like Disp and Edit pages. I guess it has something to do with these files. Are any one else having the same problem?

EDIT 2: Correction, this occurs on every list.

Automatic List Import from Excel


there is a greate function in SharePoint 2010 to create a list from an excel sheet.
Now I have the problem, that I want to reimport this list every night automaticly.

What do I have to do to solve this problem ?


Generate scripts tool blok on geting list of objests in database (last indefinitly)


I' using SQL server 2008 R2 with merge replication. Suudenly if I tray to start Generate scripts tool to generate scripts for view, functions and sp's on one database generation of scripts block on Getting the list of objects in 'database' faze. This faze run indefinitly and listing of object and generation of scripts  don't take place.

Database has more then 1600 merge articles.

Thanks in advanced. 

Import excel to sharepoint list

Could any one post me a sample code in c# to import data from an excel to a new sharepoint list

tool tip in the list field


hi ,

I am using share point 2007 (out-of-box) .

I have a list with field1, field2.on mouse over of filed1 , field2 data should be displayed as tool tip.

how I can achive this ??

Thanks and Regards

Prashanth J

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend