What is your export & import technique ?

[kvngo94]

HI guys, 

I want to learn how you guys are doing export and import in an easy way 

Since export csv columns shown as label text so it's ok to show the data to other people 

But if I want to export the view, then edit in csv file and import again, it's very difficult since the import only accepts the key value for ref columns.

Could you guy please advise any idea of how to do this in a good way ? Thank you.

[RedVox]

Appsheet doesn't offer much for importing data.  If you're storing your data in sheets, you can make a little AppScript web app for importing data.  ChatGPT is pretty good at helping newbies with AppScript projects.  I did something similar that way.  

[kvngo94]

Thank you for your suggestion, I'll check this. Nice day ~

[AleksiAlkio]

One way is to send the CSV with the Bot as then you have the possibility to add what ever data into it.

[kvngo94]

HI Aleksi, could you please advice more detail on this method ? thank you

[AleksiAlkio]

Start from this article.. https://support.google.com/appsheet/answer/11575675?hl=en&sjid=15661527516270601765-EU

[nicolasfsamaja]

HI! i have to make an import of products and prices.
The issue is that the man who uploads does not know the codes:
idprod1 
banana
15 usd

is it possible that he uploads 
Banana 15 USD
or necesary it should be
idprod1 15 USD

(This is an easy example fot my issue)
Thanks