How to export and import from View in Drupal7? i have a view in my project. And i want to import and export the views in Excel format. How to achieve this?
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.