In this article we are able to show how to import CSV excel data in to SharePoint List, some time we have to Import large amount of information from excel CSV to SharePoint list for this we can use PowerShell script, we created a list with name "ImportCSVData" with three fields Year,MovieName,HeroName.
How to add fields to list in sharepoint using powershell
Copy value from one filed to another field using PowerShell - See more at: http://www.dotnetsharepoint.com/2015/07/copy-value-from-one-filed-to-another.html#sthash.QPHZ7Tjz.dpufCopy value from one filed to another field using PowerShell
Date formula in SharePoint calculated valueDate formula in SharePoint calculated value
Excel will looks like this
$info = Import-CSV ‘D:\ImportData.csv' -header("Year", "MovieName","HeroName")
$web = Get-SPWeb -Identity "http://dotnetsharepoint.com/sites/sharepoint2013/importdata"
foreach ($rows in $info )
$item = $list.Items.Add();
$item["Year"] = $rows.Year
$item["MovieName"] = $rows.MovieName
$item["HeroName"] = $rows.HeroName
Write-Host "Excel information Updated successfully in to List"
How to update the modified by using power shell
SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM