Edit multiple rows using CSV export and import

You can edit multiple rows in a table by:

  1. Exporting the rows of a view to a CSV file using the Export this view to a CSV file action.
  2. Updating the row data in the CSV file. When the key value in the CSV row matches the key of an existing table record, then that table record will be updated when the CSV file is Imported.
  3. You can also add new rows to the CSV file.
    1. If the key value specified in the CSV row does not match the key of an existing table record, then a new record with the specified key will be added to the table.
    2. If the key value is omitted from the CSV row and the table's key field contains an Initial value of UNIQUEID() or RANDBETWEEN(), then the system will add the new row and initialize the row's key field to the Initial value.
  4. Importing the rows of the CSV file to the view.

Import and Export are symmetric. If you Export in a locale it is best to Import in that locale.

This action only works on desktop browsers and not on iOS or Android devices.

Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center