Finding the Id (Guid) for a SharePoint List
There are times when you need to find the Id (a Guid) of a list – for example, when setting the Task list to be used with SharePoint Designer Workflows (see my blog post here). Here’s a simple way of doing this:
- Navigate to the SharePoint list using the browser.
- Select the Settings + List Settings menu command.
- Copy the Url from the browser address bar into Notepad. It will look something like:
- Delete everying before and including “List=”.
- Change “%7B” to “{”
- Change all “%2D” to “-“
- Chnage “%7D” to “}”
You are now left with the Id:
{26534EF9-AB3A-46E0-AE56-EFF168BE562F}
Update: See Ken’s Comment for a simpler solution (thanks!):
A (slightly) easier way if you have MOSS 2007 is to go to the List or Library settings as described above, then right-click on the “Audience targeting settings” or “Information management policy settings” links and choose Copy Shortcut.
You can then paste the URL and there’s no need to decode the GUID. For some reason these links aren’t URL encoded.
Update: These techniques work for SharePoint 2010 Standard/Enterprise editions as well. Using Ken’s tip does not work for SharePoint 2010 Foundation as these list settings options are not available so you’ll need to use my first suggestion in this case.
Update: And it works for SharePoint 2013 too!
[…] About « Finding the Id (Guid) for a SharePoint List […]
Changing the Task list for SharePoint Designer Workflows « Nick Grattan’s Techy Blog
April 29, 2008 at 11:32 am
Excellent!! thanks you very much
Bazaleel
December 8, 2011 at 11:18 am
Good tip!
A (slightly) easier way if you have MOSS 2007 is to go to the List or Library settings as described above, then right-click on the “Audience targeting settings” or “Information management policy settings” links and choose Copy Shortcut.
You can then paste the URL and there’s no need to decode the GUID. For some reason these links aren’t URL encoded.
Ken Pespisa
April 29, 2008 at 4:33 pm
How to find an Id for the list which is on app?
sara
November 19, 2015 at 9:28 pm
Ken, thanks! That’s easier! Nick.
nickgrattan
April 29, 2008 at 4:50 pm
[…] Finding the Id (Guid) for a SharePoint List […]
SharePoint, SharePoint and stuff : SharePoint Kaffeetasse #61
May 5, 2008 at 1:48 pm
Thanks for the info. That is good.
raja
August 1, 2008 at 11:26 am
Really useful!! saved my bacon! thanks
Will
February 2, 2009 at 3:13 pm
hi can u tell me how to get a GUID of a site collection??
vinod
July 3, 2009 at 12:13 pm
an easier method may be to open up the site settings and go to “site lists and libraries” …. it will list the GUID like so: “/_layouts/ListEdit.aspx?List={C51B49FA-4F6C-407A-B65D-943CBB1E9BD2}”…. the main benefit being you don’t need to convert the hex character codes into { – }
tyler
August 7, 2009 at 1:18 am
er… to clarify, lists & libraries will show a list of links of which you can copy to avoid the unescaping
tyler
August 7, 2009 at 1:19 am
you are a life saver my friend
bob e
December 8, 2009 at 5:00 pm
You can also use this site http://www.albionresearch.com/misc/urlencode.php to encode the GUID
Gene Vangampelaere
December 17, 2009 at 8:33 am
Thanks Nick!
janice lagundi
March 9, 2010 at 12:34 am
[…] a couple of items to the list using the SharePoint UI. Using the technique described in Finding the Id (Guid) for a SharePoint List, I obtained the GUID of SharePoint list which is used to construct the connection string. The […]
Using OLEDB with SharePoint Lists | Sev17
March 21, 2010 at 4:45 pm
…but how best to get a site by guid, that’s the question
Woody
August 4, 2010 at 12:36 pm
For Lists: Setup an Excel file to do it, I paste the URL for the Lists in Column A and the following formula in Column B:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(REPLACE(A1,1,FIND(“=”,A1),””),”%7B”,”{“),”%7D”,”}”),”%2D”,”-“)
DJ
August 13, 2010 at 2:01 pm
how do you find the guid for the userlist?
Stefanie
September 20, 2010 at 6:19 pm
[…] https://nickgrattan.wordpress.com/2008/04/29/finding-the-id-guid-for-a-sharepoint-list/ […]
SPDataSource Information - Etch LTD
September 7, 2010 at 4:30 pm
[…] https://nickgrattan.wordpress.com/2008/04/29/finding-the-id-guid-for-a-sharepoint-list/ […]
SPDataSource Information - Etch LTD
September 7, 2010 at 4:30 pm
This post just shaved off a few hours of work for me. Its a great tip everyone working with MOSS should be aware of.
Thank you for sharing it!
MichaelL
November 5, 2010 at 5:11 pm
[…] targeting settings” in your SharePoint library/list settings, follow the steps in this blog to decode the […]
Electronic Signature Template Part - Mel Balsamo
November 30, 2010 at 10:51 am
http://meyerweb.com/eric/tools/dencoder/
figsworld
March 18, 2011 at 3:39 pm
I’ve written a small C# application to “find” a List by it’s GUID. Maybe also interesting 😉
http://nexpose.ch/web/tech/2011/02/18/sharepoint-subsite-diagram/
cansik
March 28, 2011 at 12:20 pm
with SP2010 it’s possible to copy the address link from the option “Add new item”. It contains also the GUID for the list.
To find the option “Add new item” you have to browse to the list site.
I don’t know, if this behaviour is the same in SP2007?
ntr
May 10, 2011 at 2:31 pm
Thanks for the tip!
Navigating to “New Item” in SharePoint 2007 has the list name and not the ID in the URL. Regards, Nick.
Nick Grattan
May 11, 2011 at 5:20 am
Yet another way is to change Brett’s example URL
from
http://moss2007/ProjectX/_layouts/listedit.aspx?List=%7B26534EF9%2DAB3A%2D46E0%2DAE56%2DEFF168BE562F%7D
to
javascript:alert(unescape(‘%7B26534EF9%2DAB3A%2D46E0%2DAE56%2DEFF168BE562F%7D’))
It’ll display a dialog box that you can copy the value from.
(mind the single quotes)
Andy
Andrew
June 8, 2011 at 8:37 pm
bynP5b http://fnYwlOpd2n9t4Vx6A3lbk.com
geoge
July 28, 2011 at 1:47 pm
[…] Step 1 : Find the sharepoint library GUID You can use the below blog to get the GUID https://nickgrattan.wordpress.com/2008/04/29/finding-the-id-guid-for-a-sharepoint-list/ […]
Unable to edit column in SharePoint Library | MY BLOGS
August 15, 2012 at 11:57 am
Thank you so much. works great
MtnJim
November 25, 2012 at 4:36 pm
Another way to get List ID is through SharePoint Designer under List Information section
Anh
February 22, 2013 at 9:31 pm
Also: I couldn’t find any of the menu options (perhaps I’m not priviledged enough), but the RSS feed button at the bottom of my page had the listid in the clear…
Jeremy
March 7, 2013 at 4:06 pm
I’ll right away grab your rss as I can not find your e-mail subscription
link or newsletter service. Do you’ve any? Kindly let me know so that I could subscribe. Thanks.
www.fortebelanger.com
April 9, 2013 at 1:29 pm
I guess the problem to this method (and how I found this article!) is that if you can’t display the list i browser then you can’t access the URLs to glean the GUID.
SharePoint Designer also shows list GUIDs in the list property page. But if your list is very broken (or you’re searching a Project Server list) then SP Designer might not even open the list properties page.
I used a simple PS script based around the one at the blog below – it lists all List GUIDs for a site:
http://sharepointdiva.wordpress.com/2011/11/29/powershell-create-site-collection-3/
Using this, I manually built an ‘editlist.aspx’ link which let me go and fix some broken column definitions.
Hope this helps someone.
Matt
April 12, 2013 at 1:14 am
Anybody know how to find the GUID of an Item in an Announcement List? Audit logs show the Item ID (GUID) which is meaningless unless you know which article is relates to. Help!
flo
April 30, 2013 at 2:56 pm
Go to List Setting and Modify List Audience Targeting Settings
then you can view List Id on address
like this : ******/_layouts/ListEnableTargeting.aspx?List={b9d8d92f-c9a4-49a4-86e0-5ace01f2fa0e}
Khasragh
June 3, 2013 at 1:44 pm
Hello,
I got tired of doing this in notepad, so I built a List ID, View ID calculator. Just copy the URL in and hit the button. Easy.
Here’s the List ID, View ID calculator:
http://www.surfpointtech.com/2013/10/14/sharepoint-list-id-and-view-id-calculator/
Miles
October 15, 2013 at 6:04 pm
Reblogged this on SharePoint : How to ?? and commented:
Finding the Id (Guid) for a SharePoint List: useful staff
sabrinechouk
December 16, 2013 at 1:13 pm
Great tip! Thank you hips!
Marika Daboja
February 12, 2014 at 11:51 pm
[…] Getting the List’s GUID is from the comment on this article. […]
Get Sharepoint List Access from SQL Server - elbsolutions.com Project List & Blog
March 26, 2014 at 3:17 pm
[…] to give two shout out links, without which this code would never have materialized. The first is how to find a SharePoint list’s GUID from Nick Grattan’s SharePoint blog. The second is the Connection Strings website, where I […]
Excel Geeking: Using VBA And ADO To Pull Data From SharePoint Lists | Scott C Lyerly
May 14, 2014 at 8:51 pm
Thanks Nick. It was a nice tip. Also thanks to Ken for finding more easier way. It still valid for SharePoint Online as well.
Janaka LP
September 23, 2014 at 9:33 am
i write it in adotable connection string and table name=SELECT FROM table but it is not connect
where is the mistake
Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes;DATABASE=https://kabinhizmetleri.thy.com/Genel/Baskanliklarimiz/UCUSISLGNMDYRD/KabinHizmetleriBsk/formcenter/_layouts/15/ListGeneralSettings.aspx?;LIST={12F9AE9C-E50C-4744-911E-DEB730AF1DDF};
FERHAT ERGİN TURAN
September 17, 2015 at 9:52 pm
[…] with 37 comments […]
SharePoint: Finding the Id (Guid) for a SharePoint List – discosdancefloor
February 8, 2016 at 3:01 pm
Thank you Very much.
Ranjith
September 28, 2016 at 8:39 pm
[…] Bron: Finding the Id (Guid) for a SharePoint List | Nick Grattan’s Blog […]
Finding the Id (Guid) for a SharePoint List | Nick Grattan’s Blog | Het leren van SharePoint ontwikkeling
January 29, 2017 at 9:46 am
Thank you, just what I needed!
Shawn H - SF
June 28, 2019 at 7:10 pm
[…] GUID: Finding The GUID of a Sharepoint List […]
Excel and SharePoint Solutions – Excel Help
May 19, 2020 at 1:20 pm
Thanks so much!
Dan
January 15, 2021 at 12:06 pm