Importing Data from Spreadsheet

Canvas has introduced a capability to transform data from an inline spreadsheet to a data source that is relevant for your application. You can import tabular data present in a spreadsheet using File Import feature and convert those as data source automatically, process the data if required and render the data into your application. This data can be rendered as widgets such as charts, grids etc. You can therefore create widgets from spreadsheets by loading the data into the database.

Note:
The following factors are to be considered before spreadsheet import:

The file formats currently supported are XLS, XLSX, and CSV.
By default, the file size limit is 10 MB. The default file size limit can be changed to the required limit by set the property, MAX_FILE_SIZE_MB, in the componentspreferences.properties file in the Canvas Studio Resource JAR (expertctstudioResource.jar) on the app server. However, it is recommended to limit the spreadsheet file size to 25 MB for smooth import into Canvas Studio.
If your spreadsheet has multiple sheets, the Canvas Studio imports the first sheet only.
Duplication of column headers is not allowed since no two identical columns can be created.
Data Grouping, Formulas, Macros embedded in the spreadsheet will not reflect in the imported data. However to achieve this, you can specify rules in the Advanced configuration section.
By default, all the data are imported as strings. If the data type needs to be changed, you can do so in the Advanced configuration section while importing, refer Steps to Import Data from Spreadsheet.

Refer the following page: