Import CSv

Is there a way to just update certain columns when importing a CSV rather than replacing the whole record or having to download all the data first then update the column you want and then import?

I simply want to download a list of addresses input an appointment date against all the addresses and then import just the dates I have input?

thanks

You can:

  • Either use a sheet formula like VLOOKUP() once to update the missing records, then sync with the app, or
  • Import your partial file in a new AppSheet table, then fill in the corresponding fields using App Formulas and Behavior Actions.
2 Likes

Consider adding your use case to the suggestion to provide More control over csv import action

3 Likes

That is a very good work around idea thank you

2 Likes