![[Keriacoder] - Powershell](http://keriacoder.com/wp-content/uploads/2015/08/KC-featured-image.png)
[Powershell] – Import to Sharepoint List from CSV
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
Add-PSSnapin Microsoft.SharePoint.PowerShell } # define web application where list is located $web = Get-SPWeb http://contoso/ $list = $web.lists["List Name"] $cnt = 0 # define csv document path foreach($i in Import-CSV 'E:\Scripts\Excel\ImportFromCSV.csv') { $new = $list.Items.Add() $new[“Title”] = $i.'Title' $new.Update() $cnt++ } "Added " + $cnt.ToString() + " records." "Data successfully imported. Press any key to continue…" $null = $Host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown") |
Please take note that this code must be run on the same server where the web application is with authenticated privilege.
Leave a Reply
Want to join the discussion?Feel free to contribute!