Wednesday 3 August 2016

Import CSV File in SharePoint list

Import CSV File in SharePoint list

$CSVData = Import-CSV -path "C:\Demo.csv" -Header("Title","Status")
$web = Get-SPWeb -identity "http://ServerName/"
$list = $web.Lists["ListName"]

foreach ($row in $CSVData)
 {
   $item = $list.Items.Add();
   
   $item["Title"] = $row.Title


   $item["Status"] = $row.Status
   $item.Update()
 }