Nick Grattan's Blog

About Microsoft SharePoint, .NET, Natural Language Processing and Machine Learning

Finding the Id (Guid) for a SharePoint List

with 46 comments

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:

http://moss2007/ProjectX/_layouts/listedit.aspx?List=%7B26534EF9%2DAB3A%2D46E0%2DAE56%2DEFF168BE562F%7D

  • 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!

Advertisements

Written by Nick Grattan

April 29, 2008 at 11:10 am

46 Responses

Subscribe to comments with RSS.

  1. […] About « Finding the Id (Guid) for a SharePoint List […]

    • Excellent!! thanks you very much

      Bazaleel

      December 8, 2011 at 11:18 am

  2. 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

  3. Ken, thanks! That’s easier! Nick.

    nickgrattan

    April 29, 2008 at 4:50 pm

  4. […] Finding the Id (Guid) for a SharePoint List […]

  5. Thanks for the info. That is good.

    raja

    August 1, 2008 at 11:26 am

  6. Really useful!! saved my bacon! thanks

    Will

    February 2, 2009 at 3:13 pm

  7. hi can u tell me how to get a GUID of a site collection??

    vinod

    July 3, 2009 at 12:13 pm

  8. 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

  9. 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

  10. you are a life saver my friend

    bob e

    December 8, 2009 at 5:00 pm

  11. 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

  12. Thanks Nick!

    janice lagundi

    March 9, 2010 at 12:34 am

  13. […] 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 […]

  14. …but how best to get a site by guid, that’s the question

    Woody

    August 4, 2010 at 12:36 pm

  15. 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

  16. 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

  17. […] targeting settings” in your SharePoint library/list settings, follow the steps in this blog to decode the […]

  18. 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

  19. 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

  20. 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

  21. […] 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/ […]

  22. Thank you so much. works great

    MtnJim

    November 25, 2012 at 4:36 pm

  23. Another way to get List ID is through SharePoint Designer under List Information section

    Anh

    February 22, 2013 at 9:31 pm

  24. 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

  25. 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

  26. 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

  27. 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

  28. 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

  29. 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

  30. 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

  31. Great tip! Thank you hips!

    Marika Daboja

    February 12, 2014 at 11:51 pm

  32. […] Getting the List’s GUID is from the comment on this article. […]

  33. […] 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 […]

  34. 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

  35. 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

  36. Thank you Very much.

    Ranjith

    September 28, 2016 at 8:39 pm

  37. […] Bron: Finding the Id (Guid) for a SharePoint List | Nick Grattan’s Blog […]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: