# How to import large volume of SharePoint list items from CSV to a SharePoint Online list

**URL:** <https://community.origamiconnect.com/t/how-to-import-large-volume-of-sharepoint-list-items-from-csv-to-a-sharepoint-online-list/125>\
**Category:** Admin Tips and Shortcuts\
**Created:** [March 29, 2021, 10:29pm UTC](https://community.origamiconnect.com/t/how-to-import-large-volume-of-sharepoint-list-items-from-csv-to-a-sharepoint-online-list/125 "2021-03-29T22:29:47Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![origami](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.origamiconnect.com/origami/32/436_2.png) [@origami](https://community.origamiconnect.com/u/origami)\
**Post date:** [March 29, 2021, 10:29pm UTC](https://community.origamiconnect.com/t/how-to-import-large-volume-of-sharepoint-list-items-from-csv-to-a-sharepoint-online-list/125/1 "2021-03-29T22:29:48Z")

</div>

If you need to import a large volume of list items from CSV or Excel, for example, when importing Info Directory articles in Origami, use this PowerShell script.

```
# Change this URL to point to the URL where your Info Directory is located
Connect-PnPOnline -Url "https://[your_tenant].sharepoint.com"

# Change this path to point to CSV version of the List
$CSVData = Import-CSV -path "C:\Users\adminuser\Desktop\Test.csv"

foreach ($row in $CSVData) 
 {
  $tags = $row.Tags.Split(";");
  $tagLine = "";
     foreach ($tag in $tags) 
     {
	    if ($tag.IndexOf(" ") -eq 0)
	     	{
		    	$tag = $tag.Substring(1,$tag.Length-1);
		    }
	    $tagLine += '"'+$tag+'", ';
     }
     $tagLine = $tagLine.Substring(0,$tagLine.Length-2);
     Add-PnPListItem -List "Info Directory" -Values @{"Title" = $row.Heading; "InfoPostAttachments"='[{"id":0,"title":"Download or Link","linkUrl":"'+$row.Link+'","openWindow":false}]'; "InfoPostBody"=$row.Description; "InfoPostTags"='['+$tagLine+']'}}

```

You’ll also notice we have **C:\Users\adminuser\Desktop\Test.csv**.  
Here is what that CSV looks like:

 ![image](https://canada1.discourse-cdn.com/flex031/uploads/origamiconnect/original/1X/be27b3f34708c6f42ac28f2c9307dde6a4ca8182.png)