You can export data for all records from a dataflow to a comma separated value (CSV) file. You can then import the data into other applications such as Microsoft Excel.
This procedure saves data for all of the records from a dataflow to a CSV file. The first (or header) row in the CSV file lists the field names. Subsequent rows list the corresponding values for each record. Field names and data values are enclosed between double quotation marks (").
All the records created by the dataflow are exported to the browser default download folder. The exported file name is DataflowName_StageLabel.csv, with the dataflow name and stage label of the dataflow that created the records. If records created by a dataflow are exported repeatedly, the files are numbered incrementally in parentheses after the dataflow name as DataflowName_StageLabel(number).csv.
After you complete this procedure, you can open the file and edit records in
another application, such as Microsoft Excel or a text editor. After you complete the
changes, you can load the data back into a workflow in Enterprise Designer.