Export data from a table
Qualifiers
You want to export all the records from a table to review what they all are
Use the data as a template to build a Data File so you can Import data to a table
File size limits to the export file process apply
In Live
Go to Setup / Export Table Data
Module - select the module that the data belongs to
Table - select the table to import the data to
Include Field Headers - leave checked
5 Sample Rows Only - leave un-checked
Remove Null Values - leave un-checked
Click on Download button
Save your file