Export list names into CSV using PowerShell in SharePoint 2013/2016

This SharePoint PowerShell tutorial explains, how to export all list names to CSV file from the SharePoint site using PowerShell.

To find out list in PWA site or Web URL of the SharePoint site, follow from the below steps and exported the SharePoint list successfully.

Open SharePoint PowerShell ISE with administrator permission and run below PowerShell cmdlet which will get all the list names from the SharePoint site.

Add-PSSnapin Microsoft.Sharepoint.Powershell

$site = Get-SPSite “Your web URL”
$sitelists = foreach ($web in $site.AllWebs) {
foreach($list in $web.lists){ $list }}
$sitelists |select Title | Export-CSV C:\Users\Downloads\liststitles.csv
Remove-PsSnapin Microsoft.SharePoint.PowerShell

Run this script by pressing F5 or run button shown below

Note: here some access denied error will come as below, Assign full permission to a located path and run this again.

It will create a .csv file on the located path. You can the CSV file will open like below.

export list name into csv using PowerShell sharepoint

You may like following SharePoint list and library tutorials:

This tutorial, we learned how to get all list names in CSV using PowerShell in SharePoint 2013/2016.

Tags: get list name using powershell in sharepoint, get list name using powershell in sharepoint 2013, get list name using powershell in sharepoint 2016, export list name into csv using PowerShell sharepoint 2013

free sharepoint training

SharePoint Online FREE Training

JOIN a FREE SharePoint Video Course (3 Part Video Series)

envelope
envelope
>