How to read data from excel and in which format we can save that data in Appian?

There is a smart service to load data into DB. I recommend a two-step approach with a staging table with text fields only. Then write a stored procedure to transform the data into the final table.

I would like to challenge why you try to do this? What is the overall target?

Hi,

As Stefan mentioned save the data from excel to database if you are planning to store all the data from Excel. In case if your requirement is to read a particular row in Excel file and don't want to save all the data you can use readexcelsheet() function which is available in excel tools plugin.

Keep in mind if you use this function readexcelsheet() to read large amount of data it will impact on your application performance. So, I would recommend to load the data to DB directly instead of reading the file.  

Also, Excel Tools has a function to read Excel data straight into local data where it could be parsed and dealt with without needing to just dump it straight into the DB first.  "readExcelSheetPaging()" (formerly "readExcelSheet()").

Will try it out. Thank you

Scope is to enter multiple request at a single go.

What amount of data will effect the application performance? requirement is to read data which will be not more than 100 rows.

Requirement is that the data is from two tables/multiple tables with one to many relationship. what approach you suggest here. to have parent data in one sheet and child data in second sheet. or anything else?