Skip to main content
Question

Bulk data update in Quick Base

  • June 18, 2018
  • 0 replies
  • 68 views
I have already imported data into a number of Quick Base tables from excel. These tables are relational and I had to build the relationship outside of Quick Base before importing the complete set of data. Now there is a need to add one more column to one of the tables. Is there a way I can bulk update or import values into this new column?
    This topic has been closed for replies.

    Yes, but you will need to export a spreadsheet of enough columns to identify the record along with the [Record ID#] field.
    The using vlookup in excel or some other method, create an excel sheet with the Record ID# field and that new data element (filed).  When you import and include the [Record ID#] field it will update existing records and not duplicate them.  Be care not to import blanks into an existing fields as that would overwrite existing data to blank. The safest way is to just import the [Record ID#] field and the new column(s).
    Terms & ConditionsAccessibility statement