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 did export operation of custom library in Central Administration. Library has some custom fields and Lookup field on existing library on the site.

After exporting main library and all dependecie librarys for lookup field .. i did import using Sharepoint shell - Import-SPWeb.

New imported list does not have information in lookup fields/columns .. neather if I edit items in this library there is no connection to the library where I lookup info. This is very bad. I don't have any atention to do this manually for all 600 entrys.

Thanky you for answering.

share|improve this question

Lists do not export the values of the lookup fields as there is no gaurentee the list will exist in the destination. Other fields behave this way too, particularly person/group fields.

share|improve this answer

In addition, lookup fields and person fields do not store the value, but rather the ID of the row from the original list. At the target site, even having the same list may not work, because the items may have been created in a different order, and the ID numbers will be different.

You can transport the values over via Access or Excel, though.

share|improve this answer

*After exporting list to a new location. Look Up Columns are not working because they lost the relation among them. Solution to this problem you need to recreate the look up columns.*

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.