Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have several lists in my SharePoint 2010 and I'm seeking how to export the list settings - mainly the columns name and type (e.g. Name which is single line of text).

How can I do this?

(this isn't the same as exporting the list that has data in it so I can save my data in a spreadsheet).

Thank you in advance.

share|improve this question
add comment

4 Answers

you will need to save the list as a template. when doing this you will have the option to save the content along with it. Then when you create a new list use that template.

share|improve this answer
    
Actually, I just tried the template method and it just makes me an template. No option to export (or save) the list settings (columns and types) to a text file or spreadsheet. –  steve02a Mar 7 '12 at 22:48
    
list settings -> save list as template -> then you should have a check box at the bottom that says "Include Content" –  ironman99 Mar 8 '12 at 15:09
add comment

You can go to the list settings page and click Save list as template - it will create a template that allows to clone list structure with or without its data.

share|improve this answer
    
Will this actually let me export (or save) the list settings so say, a text file, or spreadsheet? –  steve02a Mar 7 '12 at 22:44
    
No, there's no such OOTB functionality. It's relatively easy to implement it with Visual Studio but I don't understand what's the goal? –  Alex Boev Mar 8 '12 at 6:31
add comment

Is this 2010? There is a button available in the ribbon when viewing the list - "Export to Excel". That should do what you want.

share|improve this answer
    
Sorry folks. Every solution here was to export the content of a list (data someone input). Not what I was looking for. I just copied and pasted (to notepad) my list settings. Thanks anyhow. –  steve02a Mar 9 '12 at 19:13
add comment

I had this same question come up at work. The point was if SharePoint was corrupted and you had to rebuild lists and libraries, you'll have the settings saved (column types/names; sorting settings; view ranges) without having to guess at what those were when they were made. Right now our option is to go into each library/list setting and write down our selections in advanced settings.

share|improve this answer
    
Hi Jess, was this intended as a comment on the original question? If you wanted to add a comment but lack the required privileges, you can flag this post for a mod to review. Just leave a notice in the flag reason field. –  SPArchaeologist Oct 11 '13 at 12:35
add comment

Your Answer

 
discard

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.