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

AppSheet AppSheet Q&A
, ,
1

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.

Date Widget
10/1/2012 50
11/1/2012 48
12/1/2012 46
1/1/2013 21
2/1/2013 50
3/1/2013 52
4/1/2013 35
5/1/2013 45
6/1/2013 51
7/1/2013 50
8/1/2013 49
9/1/2013 43
10/1/2013 47
11/1/2013 38
12/1/2013 11
1/1/2014 55
2/1/2014 55
3/1/2014 52
4/1/2014 45
5/1/2014 43

Thank you for any help.

1 Like
2

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?

1 Like
3

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.

4

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