How to import data from excel to my application

How to import data from excel to my application

Dear All,

Hi ! I just heard about Zoho and I am really excited about Zoho creater.  I want to create an application which will need two tables for calculation.  One table is a lookup table, which will be used for looking up some criteria and pick up value from that table and use it for calculating value from another table. 

Presently I am managing the calculations with Excel with Hlookup and vlookup functions but now I want to create it as application.

To summarise :

  • I need to maintain a table for calculation purpose.
  • I need to import excel data(csv will also do) to my application.
  • I want to iterate from rows of imported tables and calculate some values.
  • Make the resultant calculated data available for download in Excel format.

Can I do that with Zoho Creater? 

How to maintain the master table which will have various parameters.  I presently have it in excel sheet. 


Please guide me.