Nick Grattan's Blog

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

Bulk Editing of SharePoint List Items

with 5 comments

Imagine you have a list with a “Confirm” yes/No field and you want a user to be able to view items and click a Check box on those items which are completed and click a Save button:


This saves the user opening each item in turn, changing the “Confirm” field and saving the item. This can be done using the SharePoint Designer and using a DataView. To do this:

  • Select File + New + Page to create a new ASPX page.
  • Choose “Create from Master Page…” and click OK and OK again to use the default master page..
  • Save the page as “BulkEdit.aspx” in the list’s folder, e.g. “ConfirmList” where the existing AllItems.aspx file exists.
  • “Create Custom Content” for “PlaceHolderMain” using the quick link:


  • Open the “Data Source Library” pane and click the list, e.g. “ConfirmList” and select Show Data:


  • Select the Insert Selected Fields as… button in the Data Source Details panel and select Multiple Item Form:


  • From the “Common Data View Tasks” menu select Edit Columns and remove all columns bar “Title” and “Confirm” (or whatever columns you want displayed).

You will now set the “Title” column to be read-only so that only the “Confirm” check box is editable.

  • Single click a “Title” edit box and click the “Common FormField Tasks” button (the greater than sign) and select “Text” from the “Format as” list.
  • Save the file.
  • To test, navigate to the page, e.g. TestSite/Lists/ConfirmList/bulkedit.aspx.

Also take a look at, this uses an XML file as the data source rather than a SharePoint list.

Written by Nick Grattan

May 13, 2008 at 12:13 pm

5 Responses

Subscribe to comments with RSS.

  1. […] Bulk Editing of SharePoint List Items […]

  2. And 2 years later I stumble accross this great post… Thanks!


    April 23, 2010 at 2:26 pm

  3. Thanks for nice and effective post!

    SH Pavel

    November 26, 2010 at 2:40 am

  4. Thank you so much it solved my issue


    July 12, 2013 at 1:18 pm

  5. Hi, this would solve a mojor issue for me. But I don’t get what you are using: when you create the aspx page and Custom Content, are you in Sharepoint designer. I’m using SP designer 2013 and cannot see this quick link you are refering to. Thank you.


    March 7, 2014 at 1:02 pm

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: