Use a excel template to upload data to appsheet

[frankwanglinked]

Hi, I'm new to appsheet. Come up a question that is it possible to upload a csv or excel sheet/data to appsheet?

Provide a excel template to the user, and then they can put some data into the template, and upload the excel/csv to appsheet. Then i can use the data from the uploaded excel to do some kind of automations. Is it possible to do so? if so, how can i do this?

Thanks ahead.

[Joseph_Seddik · Accepted solution]

Import a CSV file for this view - AppSheet Help

[Joseph_Seddik · Accepted solution]

Import a CSV file for this view - AppSheet Help

[VarunChandran · Accepted solution]

First create a csv file with all the columns which are presented in the table. After that store the file in Appsheet database. then you need to create two actions for that table.

Action 1. Open a File Action. In this action for file give your template file path. So that users can directly download the template from the app and fill the data.

Action 2: Import a csv file to this view. With this action users can upload their csv file and the data will be uploaded to the table.

[frankwanglinked]

Thanks, helped me  a lot.