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 would like to know if I can use an existing list as a template but to exclude some columns before creating the list template. Or alternatively exporting to excel but keeping the options of drop down lists etc. as when I export to excel it loses the choice fields and makes it a text field and I have to redo all the choices.


share|improve this question

If you export the list as a template, this will produces a .stp file.

This file is actually a simple cab file you can extract, tweak, and rebuild.

Depending on the complexity of the tweak, you can either :

  1. export the list as a stp file, then tweak it, then rebuild the stp
  2. export the list, reimport in a temp list, tweak the temp list, then reexport the temporary list
  3. Move to Visual and a custom list definition
share|improve this answer

You can:

  1. Export the list as an .STP file
  2. Import the list back into SharePoint into a new location.
  3. Delete the columns you don't want.

Additionally, you may rename the .STP file to a .CAB file, extract Manifest.xml from the .CAB file, modify Manifest.xml. If you use NotePad++ and the XML tools to do this, it's actually not that hard, you just have to collapse all the elements and open the ones you want and then you may delete them.

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.