SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two custom lists on the SharePoint website and I would like to create a list which combines/joins the two lists. Is this possible and if so what are the best methods or third party tools for achieving this?

Regards, Sharmila

share|improve this question
Are you actually trying to combine the lists? Or just trying to show them as joined in a view somewhere? – Kit Menke Apr 18 '12 at 13:45
I need to join lists and i want to access the resulting data in a custom webpart – sharmila Apr 19 '12 at 5:35
up vote 4 down vote accepted
  1. You can export the lists in Excel sheets. Combine them and create another list using the combined excel sheet. This way will only allow you to combine data upto that particular point of time. i.e, its not dynamic.

  2. You can combine lists using a Data view web part creating a new linked resource. Refer this blog for details. And afterwards you can export this combined Data View web part using javascript. Find all the details here for exporting. Exporting from a Data View web part would be dynamic and real time.

Good Luck .

share|improve this answer
Thank you:) I have the linked datasource and now I need to access this datasource in a custom webpart – sharmila Apr 19 '12 at 5:36

You can use SPSiteDataQuery to combine or join multiple lists created out of same list template.

It is beautifully explained in the following link:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.