If you want to do it that way, use [Views data export][1]. Here is an excerpt about it from the module's project page:

 > ... 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.

Then, re-import using the [Feeds][2] module. Here is an excerpt about it from the module's project page:

 > Import or aggregate data as nodes, users, taxonomy terms or simple database records.

 > - One-off imports and periodic aggregation of content
 > - Import or aggregate RSS/Atom feeds
 > - Import or aggregate CSV files
 > - Import or aggregate OPML files
 > - PubSubHubbub support
 > - Create nodes, users, taxonomy terms or simple database records from import
 > - Extensible to import any other kind of content
 > - Granular mapping of input elements to Drupal content elements
 > - Exportable configurations
 > - Batched import for large files

  [1]: https://www.drupal.org/project/views_data_export
  [2]: https://www.drupal.org/project/feeds