How to export and import from View in Drupal7?
You can use views data export module.


  This module is designed to provide a way to export large amounts of
  data from views. It provides a display plugin that can rendered
  progressively in a batch. Style plugins are included that support
  exporting in the following types:

CSV
Microsoft XLS
Microsoft DOC
Basic TXT
XML.