Exporting Rows

The Export option at the bottom of the edit data screen allows for filtered rows of data to be exported in tab delimited or MS Excel format. Exporting smaller sections of data can save time and reduce the risk of an accidental edits to data that did not change. Data can be filtered by one or more columns. The data returned is the data that meets the filter criteria. When the required subset of data is complete, the data can be exported in tab delimited format or MS Excel format.

For example, if there is a table with 100,000 rows and changes need to be made to 50 rows with common data values, table data can be filtered down and the filtered rows can be exported in MS Excel format. After any edits, the data can be re-imported and appended to the table.

The number of rows to be exported from the edit table data screen is listed at the top of the screen. All data that meets the filters is exported. Exports are not done per page.

Filtered Data for Export

1. On the Edit Data screen, enter filter criteria for the rows or rows where you want to filter data.
2. Click the filter icon. The screen refreshes with the data that matches the filter. The number of rows returned is listed at the top of the screen.
3. When the subset of data is complete, select the type of export needed; tab delimited or MS Excel.

Tab delimited reports are presented immediately. MS Excel reports can be saved to a table job or run immediately. Please see Export Data to MS Excel Workbook for more information.

To allow for exports to MS Excel, the same setup procedures for table data exports must be in place.

Data exported in tab delimited format cannot be appended to the table.