Copy Paste Values from Excel/Text Files/CSV/Websites/etc?

Noob here.  So feel free to explain it like I'm 5. 

Will AppSheet allow for large volume cut/paste (see ex. below) from excel, text files, etc?  I'm trying to create an app where a user can cut data from various programs or websites and paste it into AppSheet.  From there the App will run a bunch of calcs, forecasts, etc.  Ideally I'd like the user to be able to paste in ~100+ months of historic data, but at a minimum it needs to be 50 months in the format below.  Even if the user has to paste in columns individually (like the "Data Source" allows) that would be ok.  

 

DateWidget
10/1/201250
11/1/201248
12/1/201246
1/1/201321
2/1/201350
3/1/201352
4/1/201335
5/1/201345
6/1/201351
7/1/201350
8/1/201349
9/1/201343
10/1/201347
11/1/201338
12/1/201311
1/1/201455
2/1/201455
3/1/201452
4/1/201445
5/1/201443

Thank you for any help.

Solved Solved
0 3 273
1 ACCEPTED SOLUTION

Unfortunately that is not possible directly through the app because the app works more on row basis. Have you thought to import the data with the CSV?

View solution in original post

3 REPLIES 3

Unfortunately that is not possible directly through the app because the app works more on row basis. Have you thought to import the data with the CSV?

Thanks for the reply.  I have thought about it, but users are going to have to convert data to a csv.  I'm building this app to be more user friendly than a current excel model and this step moves in the opposite direction.  The rest of the app would increase the UX, but I'm going to have to think id the tradeoffs are worth it.   

What about if you paste the data into one long text column and then the app will generate those rows in the background?

Top Labels in this Space