• Home

Import data from CSV and SQL to a SharePoint list

By peter.stilgoe

This SharePoint feature allows you to quickly import data from a CSV file or a SQL stored procedure to any custom SharePoint list.

Once you have added the solution to your farm and activated it on your site collection an additional menu option will be available on the Action menu of each custom list that will take you to the import CSV or SQL page.

Simply select which option you want – either import from a CSV file or import from a SQL stored procedure. Next, browse to the CSV file or enter the SQL connection and name of the stored procedure and hit the Import button.

There is a check box option to delete all items from the list before doing the import which is not selected by default.

Click Here

More From pstilgoe

• Converting a Sharepoint List into XML | Sharepoint Consultant, Automation & Stuff
• Using a lookup to return data from a list on a different site
• Creating an Org Chart using Visio 2007 and a SharePoint List

Ask pstilgoe To Recommend Your Posts

CSV , NHS Sharepoint , Sharepoint / MOSS / WSS , Sharepoint Lists

Sharepoint / MOSS / WSS, Sharepoint Lists, SQL Server 2 Comments November 3rd, 2009

About... peter.stilgoe

This author published 482 posts in this site.
Sharepoint, InfoPath, K2, Nintex, Business Process Mapping, Business Intelligence, Automation, ECM, Document Management, Document Imaging, Internet Marketing & Online Business Consultant Email / MSN: pstilgoe@hotmail.com LinkedIn: Pete Stilgoe - Sharepoint Consultant

Share

2 Comments

• At 2010.10.28 12:21, oli said:
  

  Hello Peter,
  It’s actually a nice idea to share such information. But when coming from Google it would be nice to know following information:
  1. Sharepoint Version = ?
  2. You are talking of a feature/tool but you don’t mention it’s name or even it’s location
  3. The link “Click here” doesn’t work at all…

  I tried to import a spreadsheet over the “import spreadsheet-option” what wasn’t working. First of all when I click Browse to locate the file, the file-extension-filter only allows me to import the following types:
  1. All files (*.*)
  2. Image files (*.jpg,*.png,…)
  3. Websites (*.htm, *.html)

  When I choose all files and select my “xls, csv or whatever I tried”-file and click on Import, a dialogue box pops up telling me that there’s no data in it. But there is data in it. The file was a spreadsheet export from another list in sharepoint. I also did unlink it from sharepoint so that I really only have a normal xls/csv file with content in it.

  Thanks for your post!
  Greetz Oli

  [Reply]

  [Reply]
• At 2010.10.28 12:32, peter.stilgoe said:
  

  Looks like he reconfigured his site, you can find the solution here:

  http://www.aidangarnish.net/post/Easily-import-data-from-CSV-and-SQL-to-a-SharePoint-list.aspx

  [Reply]

  [Reply]