11

Pretty self explanatory. I just need to export lists easily to xml format. Are there any tools that accomplish this?

Alex Angas
  • 59,219
  • 41
  • 137
  • 210
Kilhoffer
  • 32,375
  • 22
  • 97
  • 124

7 Answers7

16

This is the method I use:

http://servername/site/_vti_bin/owssvr.dll?Cmd=Display&List=YOURUNIQUELISTID&XMLDATA=TRUE

Works like a charm.

  • In rejected edit, @reuben.ahmed suggests that one should, "replace the server name and the query string value with specific values." – trashgod Jul 01 '11 at 20:24
  • Here's a link that works: http://sharepointsolutions.blogspot.com/2009/04/silverlight-easiest-method-to-get.html – Shane Castle Mar 13 '12 at 20:42
  • 2
    Also note that you can append a View querystring variable to filter the results and/or get values from more site columns in the output. get the View ID from the address bar after clicking "Modify View" from the ribbon. – Jay Apr 04 '12 at 14:40
  • Actually this didn't work for me. I had to change Cmd=ExportList – Ruchira Sep 27 '17 at 01:27
4

You could also use the Lists webservice. http://server/_vti_bin/Lists.asmx

jwmiller5
  • 2,584
  • 1
  • 15
  • 34
3

You can write a c# application pretty easily to connect to the sp list and export it out yourself.

A quick search on codeplex search comes up with one such program already made for this purpose! Hope this can help you: http://www.codeplex.com/SPListReader http://www.codeplex.com/SPListReader/Release/ProjectReleases.aspx?ReleaseId=15420

ImJustPondering
  • 1,818
  • 1
  • 11
  • 3
3

Any chance that the RSS feed is going to be XML enough for you?

Nat
  • 14,175
  • 5
  • 41
  • 64
1

On the SharePoint list click Actions > Open With Access > Right click on the table and choose export to xml.

  • What version of SharePoint? I just tried this and I don't have an "Open with Access" action. I can export to an Excel workbook, but it links to the SP list and doesn't let you export it. – Patrick Cuff Nov 07 '08 at 12:27
  • ad "What version of SharePoint?": Can you edit your original question to clarify what SharePoint version you are using? – vitule Nov 07 '08 at 17:43
  • Well, it's tagged MOSS. That can only mean SP 2007 – Kilhoffer Jan 30 '09 at 14:53
0

You can create a 'Content Query Tool Part' to export a list of pages on your SharePoint environment to a generated XML list. My favorite feature with this tool is that you can sort and filter the content you want generated on your XML file. You can learn more about it here through this tutorial by Waldek Mastykarz

klewis
  • 7,459
  • 15
  • 58
  • 102
0

In the actions menu of the list, select export to spreadsheet. Then open the exported Excel Web Query file and from the File menu, select "Save as" and save it as XML.

ashwnacharya
  • 14,601
  • 23
  • 89
  • 112