Data Preview Grid

Data Preview grid is used to show the raw data of the selected table(s) in table canvas.

Data preview grid

By default Data Preview grid shows like below.

Update data preview grid

By clicking Update button, the data preview grid loaded and initially it shows only 100 records.

Load more data

By clicking Load more option, you can get all data in preview grid.

Load more data

By following below procedure, you can export the data to excel file which are displayed in data preview grid.

Click Export All icon in data preview grid.

Export all data to excel

Export Selected Rows option will be enabled by selecting the rows in the data preview grid.
Click Export Selected Rows icon in data preview grid to export selected row(s) of the data.
Export selected data to excel

Now Save as window will open. Enter suitable name and choose the specified location. By clicking Save button, you can save the data in excel format.

Save data to excel

Once data saved successfully, you will get message as follows.

Exported successfully alert window

Click Yes to view the saved data in excel file as follows.

Excel data