Import from multiple lines of spreadsheet

[SteveT]

Is it possible to import data from multiple lines a spreadsheet into a single datapage record. 

For example, a home inventory spreadsheet

the spreadsheet contains "community name' and 'city' in line 1, cell 1 and cell 2 of the spreadsheet

And line 2 of the spreadsheet contains 10 other fields related to that same data record.  address, price, phone, etc. 

or, would the spreadsheet need to be modified to put the community name in cell on of all related records before import. 

Thanks! Steve

[Wikiwi]

@SteveT 1 cell in your excel file will correspond to 1 cell in your Caspio table which means 1 row of data in your excel file will be 1 record in Caspio. I would suggest modifying your Excel file first before importing it to Caspio.

[telly]

Hi @SteveT

You may also use Application Scheduled Task, once you have imported the filed then manually run the task or you can schedule the task after you have imported the record.

For more information you may check this link: https://howto.caspio.com/tasks/