If you want to do it that way, use Views data export. 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 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
