Updating DataCData Excel Add-In for Google BigQuery 2019 - Build 19.0.7354
After Querying Data to pull data into your sheet, you can edit cells and post the changes to the rows you select. Select the data manipulation operation on the CData ribbon. The add-in only saves the changes in the selected rows. You must also enable data modification options for the connection to save changes. See Establishing a Connection for details.
From the CData ribbon, click Update Rows. Note that not all cells can be updated; read-only cells are marked in their column headers. Also, business rules in your Google BigQuery data source may prevent you from making certain changes. See Data Model for more notes on updating Google BigQuery